<?php
$mem = new Memcache;
$mem->connect("127.0.0.1",11211);$sql = 'SELECT xh,xm FROM mytable where bj=8';if ($mem->get('key')) {
$var = $mem->get('key');
echo "cached<br>";
print_r($var);
} else {
$conn = mysql_connect('localhost', 'root', '');
mysql_select_db('mydb');
mysql_query("SET NAMES UTF8");
$result = mysql_query($sql);
while ($row = mysql_fetch_object($result)){
$arr[] = $row;
}
$mem->set('key', $arr, 0, 86400);
echo "noncached<br>";
$var = $mem->get('key');
print_r($var);
}$mem->close();
?>
请问,如何从缓存中取出类似这样的数值?以前没有用memcache,想在想要改进一下。while ($myrow = mysql_fetch_row($result)) {
printf("<tr><td>$myrow[1]</td><td>$myrow[2]</td>");//学号 姓名
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货