免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

點(diǎn)擊量統(tǒng)計(jì)有3個(gè)模塊
1 帖子詳細(xì)頁面模塊-點(diǎn)擊量自增，并返回當(dāng)前點(diǎn)擊量
步驟比較簡單，首先連接redis服務(wù)器，接下來發(fā)送一個(gè)incr命令
使用thread:click:{$id}的形式來命名redis的鍵

// Connect redis server$redis = new redis();$redis->connect('127.0.0.1', 6379);// Perform increase action$click = $redis->incr('thread:click:123');

2 帖子列表頁，返回一頁帖子所有的點(diǎn)擊量
首先從mysql獲得需要顯示的帖子列表，然后從redis中獲取需要顯示的帖子點(diǎn)擊數(shù)，兩個(gè)點(diǎn)擊量加起來即當(dāng)前真實(shí)的點(diǎn)擊量

// Connect redis server$redis = new redis();$redis->connect('127.0.0.1', 6379);// Connect mysql server$mysql = new PDO("mysql:host=localhost;dbname=thread","root","",array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); $rs = $mysql -> query("select * from thread limit 30");while($row = $rs -> fetch()){     $click = $redis->get('thread:click:'.$row['id']);    echo $row['id']."	";    echo $row['title']."	";    echo $row['click'], "+", $click, "=", $row['click']+$click;    echo "\n";} 

3 隔一段時(shí)間把redis中的數(shù)據(jù)轉(zhuǎn)存到mysql中，并清空redis
取出所有點(diǎn)擊量的數(shù)據(jù)，更新mysql的點(diǎn)擊量，并刪除redis中與點(diǎn)擊量相關(guān)的鍵

// Connect redis server$redis = new redis();$redis->connect('127.0.0.1', 6379);// Connect mysql server$mysql = new PDO("mysql:host=localhost;dbname=thread","root","",array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8")); // Fetch all clicks$keys = $redis->keys('thread:click:*');foreach ($keys as $key) {    $id = substr($key,10);    $click = $redis->get($key);    $sql = "update thread SET `click` = `click` + $click where `id` = $id";    echo $sql,"\n";    $rs = $mysql -> query($sql);}// Delete clicks in redis$redis->delete($keys);