function apiCache($tablePubinfo, $tableId, $urlGet, $names) { $file = new File(); //$sId = isset($_GET['sid']) ? $_GET['sid'] : 0; $n = "wx_" . $tablePubinfo . "_" . $tableId . "_" . $urlGet; $file->cacheData($n, $names); //生成缓存 //if($file->cacheData('index_mk_cache')){//获取缓存 //if($file->cacheData('index_mk_cache', null)){//删除缓存 }
// http://app.com/list.php?page=1&pagesize=12 require_once './response.php'; require_once './db.php'; require_once './file.php'; $page = isset($_GET['page']) ? $_GET['page'] : 1; $pageSize = isset($_GET['pagesize']) ? $_GET['pagesize'] : 1; /// 判断参数是否正确 if (!is_numeric($page) || !is_numeric($pageSize)) { return Response::json(401, "参数错误"); } $dbs = array(); $offset = ($page - 1) * $pagesize; $sql = "select * from help_category limit " . $offset . " , " . $pageSize; $cache = new File(); /// 假如不存在缓存数据 if (!($dbs = $cache->cacheData('index_om_cache' . $page . '-' . $pageSize))) { try { $connect = Db::getInstance()->connect(); } catch (Exception $e) { return Response::json(403, "数据库链接失败", $dbs); } $result = mysql_query($sql, $connect); if (!$result) { } else { while ($db = mysql_fetch_assoc($result)) { $dbs[] = $db; } } /// 把新数据缓存一份 if ($bds) { $cache->cacheData('index_om_cache' . $page . '-' . $pageSize, $dbs, 1200);
} 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); }
public function index() { ini_set('error_log', APPPATH . '/logs/error.log'); //設定錯誤訊息存放路徑 //============config=================== $this->config->set_item('appID', 'CONFIG:寫入成功'); echo $this->config->item('appID') . "</br>"; //============session==================== $this->load->library('session'); $this->session->set_userdata('sessionName', 'SESSION:寫入成功'); //unset($_SESSION['sessionName']);//清session session_write_close(); if (isset($_SESSION['sessionName'])) { $data['info'] = $_SESSION['sessionName']; } //=============cookie====================== setcookie("cookieName", "COOKIE_VALUE:寫入成功", time() + 3600 * 24, "/"); //setcookie("cookieName","",time()-3600*24,"/");//清cookie echo "</br>" . $this->input->cookie("cookieName", TRUE) . "</br>"; //==============ip========================== //$ip=$this->input->ip_address(); $ip = $_SERVER["REMOTE_ADDR"]; if ($ip != "192") { error_log("設定錯誤訊息測試"); } echo "</br>IP:" . $ip; //=============sql injection================ $this->load->library('saferequest'); //$this->fb->info($this->saferequest->safe("/*",$this->saferequest->postfilter), "info"); //==============loadmodel===================== $this->benchmark->mark('code_start'); //效能測試開始 $this->load->model('helloworld_model'); // $result=$this->helloworld_model->get_helloworld("helloworld"); // $data['name']=$result; //靜態緩存數據 require_once APPPATH . '/libraries/my/file.php'; $file = new File(APPPATH . "cache/cachefiles/"); if (!($dataCache = $file->cacheData('helloworld'))) { //不存在就寫入cache $result = $this->helloworld_model->get_helloworld("helloworld"); $data['name'] = $result; $file->cacheData('helloworld', $result, 10); } else { echo "</br></br>cached helloworld</br>"; $data['name'] = $dataCache; } $effected = $this->helloworld_model->insert_helloworld("testtest地址"); $this->fb->info($effected, "資料寫入成功"); $this->benchmark->mark('code_end'); //效能測試結吏 //==============debug========================= // $this->fb->setEnabled(true); // $this->fb->info($data['name'], "info"); // $this->fb->groupEnd(); //============讀取子樣版======================= //$this->output->cache(1);//cache頁面,1代表分鐘 //$this->output->delete_cache();//刪除cache,要等時間到才會刪除 $this->load->library('modules/helloworldhead'); //讀取lib,再由lib的此檔load view $data['head'] = $this->helloworldhead->head(); //子樣版變數head $this->load->view('helloworld', $data); }
<?php // 让crontab定时执行的脚本程序 */5 * * * * /usr/bin/php /data/www/app/cron.php // 想获取video中 6条数据 require_once './db.php'; require_once './file.php'; $sql = "select * from video where status = 1 order by orderby desc"; try { $connect = Db::getInstance()->connect(); } catch (Exception $e) { // $e->getMessage(); file_put_contents('./logs/' . date('y-m-d') . '.txt', $e->getMessage()); return; } $result = mysql_query($sql, $connect); $videos = array(); while ($video = mysql_fetch_assoc($result)) { $videos[] = $video; } $file = new File(); if ($videos) { $file->cacheData('index_cron_cahce', $videos); } else { file_put_contents('./logs/' . date('y-m-d') . '.txt', "没有相关数据"); } return;
<?php // http://www.app.com/list.php?page=1&pagesize=12 require_once '../basic/format.php'; require_once '../core/cache.php'; // 加载缓存文件 $file = new File(); $data = $file->cacheData('index_cache'); if ($data) { return Response::show(200, '首页数据获取成功', $data); } else { return Response::show(400, '首页数据获取失败', $data); } exit; $page = isset($_GET['page']) ? $_GET['page'] : 1; $pageSize = isset($_GET['pagesize']) ? $_GET['pagesize'] : 1; if (!is_numeric($page) || !is_numeric($pagesize)) { return Response::show(401, '数据不合法', '', 'xml'); } $offset = ($page - 1) * $pagesize; $sql = "select * from areas";
public function cacheData($key, $value = '', $cacheTime = 0) { $filename = $this->_dir . $key . self::EXT; if ($value !== '') { // 将value值写入缓存 if (is_null($value)) { return @unlink($filename); } $dir = dirname($filename); if (!is_dir($dir)) { mkdir($dir, 0777); } $cacheTime = sprintf('%011d', $cacheTime); return file_put_contents($filename, $cacheTime . json_encode($value)); } if (!is_file($filename)) { return FALSE; } $contents = file_get_contents($filename); $cacheTime = (int) substr($contents, 0, 11); $value = substr($contents, 11); if ($cacheTime != 0 && $cacheTime + filemtime($filename) < time()) { unlink($filename); return FALSE; } return json_decode($value, true); } } $file = new File(); echo $file->cacheData('test1');
<?php // 让crontab定时执行的脚本程序 */5 * * * * /usr/bin/php/data/www/app/cron.php // 获取table数据 require_once './db.php'; require_once './file.php'; $sql = "select * from help_category"; $dbs = array(); try { $connect = Db::getInstance()->connect(); } catch (Exception $e) { // return Response::json(403,"数据库链接失败",$dbs); file_put_contents('./logs/' . date('y-m-d') . '.txt', $e->getMessage()); return; } $result = mysql_query($sql, $connect); if (!$result) { } else { while ($db = mysql_fetch_assoc($result)) { $dbs[] = $db; } } $file = new File(); if ($dbs) { $file->cacheData('index_cron_cache', $dbs); } else { file_put_contents('./logs/' . date('y-m-d') . '.txt', '没有相关数据'); } return;
} // 假如文件不存在 返回false if (!is_file($filename)) { return FALSE; } // 读取缓存 file_get_contents $contents = file_get_contents($filename); $cacheTime = (int) substr($contents, 0, 11); $value = substr($contents, 11); if ($cacheTime != 0 && $cacheTime + filemtime($filename) < time()) { unlink($filename); return FALSE; } // 将json解析 返回数组 return json_decode($value, true); } } $file = new File(); // $data = array( // 'id' => 3, // 'name' => 'test', // 'mail' => '*****@*****.**', // ); // $date = date("Y-m-d H:i:s"); // 若第二个参数为null则为删除缓存 if ($file->cacheData('test1', null)) { // var_dump($file->cacheData('test1'));exit; echo 'success'; } else { echo 'false'; }
<?php require_once './cache.php'; $data = array('id' => 1, 'name' => 'apeng', 'type' => array(1, 2, 3), 'test' => array(2, 3, 4 => array(100, 'type'))); $file = new File(); // if ($file->cacheData('index_cache', $data)) { // 写入缓存 // echo 'success'; // } else { // echo 'error'; // } // if ($file->cacheData('index_cache')) { // 读取缓存 // var_dump($file->cacheData('index_cache')); exit; // echo 'success'; // } else { // echo 'error'; // } if ($file->cacheData('index_cache', null)) { // 删除缓存 echo 'success'; } else { echo 'error'; }