[root@memcached html]
<?php
$memcachehost = '127.0.0.1';
$memcacheport = 11211;
$memcachelife = 60;
$memcache = new Memcache;
$memcache->connect($memcachehost,$memcacheport) or die ("Could not connect");
$query="select emp_no,salary from salaries where emp_no = 10001";
$key=md5($query);
if(!$memcache->get($key))
{
$conn=mysqli_connect("localhost","root","123456","employees");
$result=mysqli_query($conn,$query);
while ($row=mysqli_fetch_assoc($result))
{
$arr[]=$row;
}
$f = 'mysql';
$memcache->add($key,serialize($arr),0,30);
$data = $arr ;
}
else{
$f = 'memcache';
$data_mem=$memcache->get($key);
$data = unserialize($data_mem);
}
echo $f;
echo "<br>";
echo "$key";
echo "<br>";
foreach($data as $a)
{
echo "key is <b><font color=#FF0000>$a[emp_no]</font></b>";
echo "<br>";
echo "value is <b><font color=#FF0000>$a[salary]</font></b>";
echo "<br>";
}
?>
|
