cache.mysql.func.php
1.91 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
<?php
/**
* [WeEngine System] Copyright (c) 2014 WE7.CC
* WeEngine is NOT a free software, it under the license terms, visited http://www.we7.cc/ for more details.
*/
defined('IN_IA') or exit('Access Denied');
function cache_read($key) {
$cachedata = pdo_getcolumn('core_cache', array('key' => $key), 'value');
if (empty($cachedata)) {
return '';
}
$cachedata = iunserializer($cachedata);
if (is_array($cachedata) && !empty($cachedata['expire']) && !empty($cachedata['data'])) {
if ($cachedata['expire'] > TIMESTAMP) {
return $cachedata['data'];
} else {
return '';
}
} else {
return $cachedata;
}
}
function cache_search($prefix) {
$sql = 'SELECT * FROM ' . tablename('core_cache') . ' WHERE `key` LIKE :key';
$params = array();
$params[':key'] = "{$prefix}%";
$rs = pdo_fetchall($sql, $params);
$result = array();
foreach ((array)$rs as $v) {
$result[$v['key']] = iunserializer($v['value']);
}
return $result;
}
function cache_write($key, $data, $expire = 0) {
if (empty($key) || !isset($data)) {
return false;
}
$record = array();
$record['key'] = $key;
if (!empty($expire)) {
$cache_data = array(
'expire' => TIMESTAMP + $expire,
'data' => $data
);
} else {
$cache_data = $data;
}
$record['value'] = iserializer($cache_data);
return pdo_insert('core_cache', $record, true);
}
function cache_delete($key) {
$sql = 'DELETE FROM ' . tablename('core_cache') . ' WHERE `key`=:key';
$params = array();
$params[':key'] = $key;
$result = pdo_query($sql, $params);
return $result;
}
function cache_clean($prefix = '') {
global $_W;
if (empty($prefix)) {
$sql = 'DELETE FROM ' . tablename('core_cache');
$result = pdo_query($sql);
if ($result) {
unset($_W['cache']);
}
} else {
$sql = 'DELETE FROM ' . tablename('core_cache') . ' WHERE `key` LIKE :key';
$params = array();
$params[':key'] = "{$prefix}:%";
$result = pdo_query($sql, $params);
}
return $result;
}