PHP Development App Interface (II)

This will invoke the database connection singleton, file cache class, and development app interface of the previous blog (i)

<?php//http://app.com/list.php?page-=1&pagesize=12require_once ('./response.php '); require_once ('./ File.php '), $file = new file (), $data = $file->cachedata (' Index_cron_cahce '), if ($data) {return response::show (200, ' Home data acquisition Success ', $data);} Else{return response::show (400, ' Home 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, ' data not valid ');} $offset = ($page-1) * $pageSize; $sql = "SELECT * from video where status = 1 ORDER BY: 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, ' home data acquisition succeeded ', $videos)} else {return response::show (400, ' Home data acquisition failed ', $videos);}

PHP Development App Interface (II)