php中memcache 基本操作实例
|
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
|
<!DOCTYPE html><html><head><title>memcache demo</title><meta http-equiv="content-type"content="text/html;chatset=utf-8"></head><body><?php$server_ip = '127.0.0.1';$server_port = 11211;$memcache = new Memcache();$memcache->connect($server_ip,$server_port);$memcache->add("name1","user_name1",MEMCACHE_COMPRESSED,0);$memcache->add("name2","user_name2",MEMCACHE_COMPRESSED,0);$array1 = array('name1' => 'jiajiam1', 'age1'=>12,'country'=>'china');$memcache->add("other",$array1,MEMCACHE_COMPRESSED,20);$memcache->set("name3","user_name3",MEMCACHE_COMPRESSED,0);$memcache->replace("name1","user_name_relpace",MEMCACHE_COMPRESSED,0);$memcache->replace("123","12345");echo"name1:".$memcache->get("name1")."<br/>";$memcache->delete("name1");echo"name1:".$memcache->get("name1")."<br/>";$array_get = array("name1","name2","name3");$result_get = $memcache->get($array_get);foreach ($result_get as $key => $value) {echo"$key:--->$value<br/>";}foreach ($memcache->getStats() as $key => $value) {echo"$key:--->$value<br/>";};echo"<br/>";foreach($memcache->getExtendedStats() as $key => $value) {echo"$key:--->$value<br/>";}$memcache->close();?></body></html> |
我们再来看个更加具体些的实例
|
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
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
|
<?phpinclude('inc/common.inc.php');if (! isset($city) || ! is_array($city) ) { exit;}//print_r ($city);exit;$mem = new Memcache();$mem-> connect('localhost', '11211');$expires=15*60;//check if cache exitsif(($value = $mem-> get($city)) != FALSE) { echo "get key from memcache: "."<br />"; // $return=$mem->get($city); // echo json_encode($return);}//ifelse { $resultJson=fetch_data(); echo count($resultJson)."<br />"; if(count($resultJson)==1 || empty($resultJson)){ //从mysql中取值 echo "get key from mysql:"."<br />"; $query="select * from pm25"; $result=mysql_query ($query) ; while ($row = mysql_fetch_assoc($result)){ $rows[]=$row; } //将获取的值数组存入memcache for($i=0;$i<count($rows);$i++){ $k[$i]=$rows[$i]['city']; $v[$i]['city']=$rows[$i]['city']; $v[$i]['pm25']=$rows[$i]['pm25']; $mem -> set($k[$i], $v[$i], false, $expires); } // $return=$mem->get($city); // echo json_encode($return); }//if else{ echo "get key from new_writed mysql:"."<br />"; write_db($resultJson); $query="select * from pm25"; $result=mysql_query ($query) ; while ($row = mysql_fetch_assoc($result)){ $rows[]=$row; } //write memcache for($i=0;$i<count($rows);$i++){ $k[$i]=$rows[$i]['city']; $v[$i]['city']=$rows[$i]['city']; $v[$i]['pm25']=$rows[$i]['pm25']; $mem -> set($k[$i], $v[$i], false, $expires); } // $return=$mem->get($city); // echo json_encode($return); }//else}//elseforeach ($city as $k=>$v){ $return[$k]=$mem->get($v);}echo json_encode($return);function fetch_data() { $url="http://www.example.com"; //$url=""; $data = http_get($url); $getJson = json_decode($data, true); return $getJson;} //func fetch_datafunction write_db($getJson){ $sql="DELETE FROM pm25"; mysql_query($sql); //sort the json.txt foreach ($getJson as $key => $row) { $area[$key] = $row['area']; $pm2_5[$key]= $row['pm2_5']; } array_multisort($area, SORT_ASC,$pm2_5,SORT_ASC,$getJson); for($i=0;$i<count($getJson)-1;$i++){ if($getJson[$i]['pm2_5']==0) $count=0; else $count=1; $sum=$getJson[$i]['pm2_5']; for($j=$i+1;$j<count($getJson);$j++,$i++){ if(strcmp($getJson[$j]['area'],$getJson[$i]['area'])==0 ){ if($getJson[$j]['pm2_5']==0 ){ continue; } else{ $count++; $sum+=$getJson[$j]['pm2_5']; $pm2_5=$sum/$count; } } else{ //insert into mysql $result['city']=$getJson[$i]['area']; $result['pm25']=intval($pm2_5); $query="insert into pm25(city,pm25) values ('".$result['city']."',".$result['pm25'].")"; mysql_query($query); break; } } } return $getJson;}//func write_db$mem -> close();?> |
以上所述就是本文的全部内容了，希望大家能够喜欢。
