Php app development interface (2) Here we will call the database connection Singleton, file cache class and APP development interface of the previous blog (1)
CacheData ('index _ cron_cahce '); if ($ data) {return Response: show (200, 'homepage data retrieved successfully', $ data);} else {return Response:: show (400, 'homepage data acquisition failed', $ data);} exit; require_once ('. /db. php '); require_once ('. /file. php '); $ page = isset ($ _ GET ['Page'])? $ _ GET ['Page']: 1; $ pageSize = isset ($ _ GET ['pagesize'])? $ _ GET ['pagesize']: 6; if (! Is_numeric ($ page) |! Is_numeric ($ pageSize) {return Response: show (401, 'invalid data');} $ offset = ($ page-1) * $ pageSize; $ SQL = "select * from video where status = 1 order by orderby desc limit ". $ offset. ",". $ pageSize; $ cache = new File (); $ videos = array (); if (! $ Videos = $ cache-> cacheData ('index _ mk_cache '. $ page. '-'. $ pageSize) {echo 1; exit; try {$ connect = Db: getInstance ()-> connect ();} catch (Exception $ e) {// $ e-> getMessage (); return Response: show (403, 'database link failed');} $ result = mysql_query ($ SQL, $ connect ); while ($ video = mysql_fetch_assoc ($ result) {$ videos [] = $ video;} if ($ videos) {$ cache-> cacheData ('index _ mk_cache '. $ page. '-'. $ pageSize, $ videos, 1200) ;}} if ($ videos) {return Response: show (200, 'homepage data obtained successfully', $ videos );} else {return Response: show (400, 'homepage data acquisition failed', $ videos );}