Some Memcache Examples Test For PHP

最新推荐文章于 2025-09-12 13:16:34 发布

转载最新推荐文章于 2025-09-12 13:16:34 发布 · 78 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：https://my.oschina.net/chunto/blog/225598

文章标签：

#php #数据库

本文介绍了如何使用Memcache缓存系统与MySQL数据库相结合来提高数据读取效率。通过具体的PHP代码示例，展示了如何设置和获取Memcache中的数据，并与MySQL查询结果进行对比验证。

为什么80%的码农都做不了架构师？>>>

$array=array('username'=>'zhaoya','passwd'=>md5('zhaoya'));
$memcache=new Memcache();
$memcache->connect('127.0.0.1:11211');
$memcache->set('list',$array);
$list = $memcache->get('list');
print_r($list);

Input:

Array ( [username] => zhaoya [passwd] => 1dd5a1b9647d269f3fb165c27053e2e2 )

简单查询MySQL语句for memcache:

$host = '127.0.0.1:3306';
$user = 'root';
$passwd = '';
$db = 'zsmall';
$conn = mysql_connect($host,$user,$passwd);
mysql_select_db($db,$conn);
$sql = 'select * from zsm_friend_link';
$result = mysql_query($sql,$conn);
while ($row = mysql_fetch_array($result,MYSQL_ASSOC)){
$test_key[] = $row;
}
$sql = md5($sql);
$mem = new Memcache;
$mem->connect("127.0.0.1", 11211);
$mem->set($sql,$test_key, MEMCACHE_COMPRESSED, 600);
print_r($mem->get($sql));
echo "<hr>";
$values=$mem->get($sql);
print_r($values['0']);

Input:

Array ( [0] => Array ( [link_id] => 1 [link_name] => ECSHOP ???????? [link_url] => http://www.ecshop.com/ [link_logo] => http://www.ecshop.com/images/logo/ecshop_logo.gif [show_order] => 50 ) [1] => Array ( [link_id] => 2 [link_name] => ??? [link_url] => http://www.maifou.net/ [link_logo] => [show_order] => 51 ) [2] => Array ( [link_id] => 3 [link_name] => ??????? [link_url] => http://www.wdwd.com/ [link_logo] => [show_order] => 52 ) )

Array ( [link_id] => 1 [link_name] => ECSHOP ???????? [link_url] => http://www.ecshop.com/ [link_logo] => http://www.ecshop.com/images/logo/ecshop_logo.gif [show_order] => 50 ) zhaoya

转载于:https://my.oschina.net/chunto/blog/225598