memcached优化方案实例

最新推荐文章于 2024-08-19 13:32:03 发布

weixin_30480075

最新推荐文章于 2024-08-19 13:32:03 发布

阅读量51

点赞数

文章标签： memcached 数据库 php

原文链接：http://www.cnblogs.com/chenliuxiao/p/9335945.html

版权

<?php
//引入memcached
require_once '../class/memcached.class.php';

//连接MySQL
$link = mysqli_connect("localhost", "root", "", "laravel");

//给memcached传值
$mc = new memcached(array(
'servers' => array('127.0.0.1:11211'),
'debug' => false,
'compress_threshold' => 10240,
'persistant' => true,
));

//获取文章id
$id = $_GET['id'];

//设置key
$key = "news_click_" . $id; // 33 100 news_click_33 102

//获取key
$click = @$mc->get($key);

//如果内存中没有
if ($click === null) {
//如果内存中没有，去数据库读点击数
//根据id，读文章记录
$sql = "select clicknum from news where id=$id";
//执行
$result = mysqli_query($link, $sql);
//获取结果
$arr = mysqli_fetch_assoc($result);
//获取浏览量
$click = $arr['clicknum'];
//自增浏览量
$click++;
//添加内存
$mc->add($key, $click);
} else {
//如果有内存, 直接自增值
$mc->incr($key, 1);

//本次访问量+1
$click++;

//减少数据库压力,5次一蹦
if ($click % 5 == 0) {
$sql = "update news set clicknum=$click where id=$id";
mysqli_query($link, $sql);
}

}

//数据库表中，记录的点击数要自增1
echo "document.write('{$click}')";

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
</head>
<body>
    <h1>隔壁老王，帮助别人，从不留名</h1>

    <div>发布时间：2018-07-03&nbsp;&nbsp;点击数：
        <script type="text/javascript" src="click.php?id=1"></script>
    </div>

    <hr/>
    <div>很随便</div>
</body>
</html>

转载于:https://www.cnblogs.com/chenliuxiao/p/9335945.html

weixin_30480075

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
memcached优化方案实例

<?php//引入memcachedrequire_once '../class/memcached.class.php';//连接MySQL$link = mysqli_connect("localhost", "root", "", "laravel");//给memcached传值$mc = new memcached(array( 'servers' => arra...
复制链接

扫一扫