PHP開發APP介面（二）

標籤：des   blog   http   ar   io   os   sp   on   檔案   

這裡將會調用前面部落格的資料庫連接單例、檔案快取類和開發APP介面（一）

<?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, '首頁資料擷取成功', $data);}else{return Response::show(400, '首頁資料擷取失敗', $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, '資料不合法');}$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, '資料庫連結失敗');}$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, '首頁資料擷取成功', $videos);} else {return Response::show(400, '首頁資料擷取失敗', $videos);}

PHP開發APP介面（二）