欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

mysql如何用mongodb做缓存

程序员文章站 2022-07-03 09:51:43
mysql如何用mongodb做缓存 function query($sql, $cache_expire = ''){ //开启缓存 读取 if...

mysql如何用mongodb做缓存

function query($sql, $cache_expire = ''){

//开启缓存 读取

if($cache_expire > 0){

$mongo = new Mongo();

$cachedata = $mongo->pwashop2->cachedata;//集合句柄

$sql_key = md5($sql);

$select = array('sql_key' => $sql_key);//查询条件

$row = $cachedata->findOne($select);

if($row && isset($row['cache_time']) && $row['cache_time'] > time()){//读取缓存,有数据且未过期

$query = array('读取缓存!!', $row['query'], date("Y-m-d H:i:s", $row['cache_time']));

return $query;

}

}

$query = array(array('username' => 'jwage'), array('password' => date("Y-m-d H:i:s", time())));//数据

//开启缓存 设置

if($cache_expire > 0){

$cachedata->remove($select);//先移除旧数据

$cache_time = time() + $cache_expire; //缓存过期时间

$row = array(

'sql_key' => md5($sql),

'query' => $query,

'cache_time' => $cache_time);

$cachedata->insert($row);

return array('设置缓存!!', $query);

}

return array('未开启缓存!!', $query);

}

$sql = "select 1+1";

$query = query($sql, 30);

echo date("Y-m-d H:i:s", time()).'

';

print_r($query);

exit;