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';
}
