/
my_memcache.php
68 lines (54 loc) · 1.19 KB
/
my_memcache.php
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
<?php
function cacheGet($key)
{
global $memcache;
return $memcache->get($key);
}
function cacheSet($key,$data,$delay)
{
global $memcache;
return $memcache->set($key, $data, false, $delay);
}
function sqlQuery($query)
{
$resource=mysql_query($query) or die(mysql_error());
if(!$resource)
die("Íåïðàâèëüíûé çàïðîñ: $query <br> ".mysql_error());
#echo "<b>Çàïðîñ áûë âûïîëíåí:</b>$query<br>";
return $resource;
}
function sqlSet($query, $id)
{
global $memcache;
$memcache->delete("SELECT * FROM goods ORDER BY id ASC;");
$memcache->delete("SELECT * FROM goods ORDER BY price ASC;");
if($id != -1)
{
$memcache->delete("SELECT * FROM goods WHERE id = ".$id.";");
}
return sqlQuery($query);
}
function sqlGet($query)
{
$result = cacheGet($query);
if($result !== false)
{
#echo "<b>Ïîïàäàíèå â êåø:</b> $query<br>";
#echo $result;
return $result;
}
else
{
#echo "<b>Êåø íå ñðàáîòàë:</b> $query<br>";
$resource = sqlQuery($query);
#$result = array();
while ($row = mysql_fetch_assoc($resource))
{
$result[]=$row;
}
cacheSet($query, $result, 3600);
#echo $resource;
return $result;
}
}
?>