接上篇简单的Memcache应用-优快云博客

本文链接：https://blog.youkuaiyun.com/q652907386/article/details/52639519

本文介绍了一个使用PHP结合Memcache实现的简单缓存机制，该机制根据查询次数决定是否直接从缓存中获取数据还是从数据库中读取。通过这种方式可以减少数据库的压力并提高查询效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

<?php
//header('content-type:text/html;charset=utf-8');
$name=$_POST['name'];
$pdo = new PDO('mysql:host=127.0.0.1;dbname=lianxi','root','root');
$pdo->exec('set names utf8');
$mem = new Memcache;
$mem->connect('127.0.0.1',11211);
if($cou=$mem->get('num')){
    if($cou<9){
        ++$cou;
        $mem->set('num',$cou);
        $sql="select * from one where name like '%$name%'";
        $arr=$pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
//        $mem->flush();
    }else if($cou==9){
    ++$cou;
    $mem->set('num',$cou);
    $sql="select * from one where name like '%$name%'";
    $arr=$pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
    $mem->set('arr',$arr);

    echo "这次是存进缓存";
//   $mem->flush();

  }else if($cou>9){
        $arr=$mem->get('arr');
        ++$cou;
        $mem->set('num',$cou);
        echo "这是缓存,没有读取数据库";

//        $mem->flush();

    }
//$mem->flush();

}else{
    $sql="select * from one where name like '%$name%'";
    $arr=$pdo->query($sql)->fetchAll(PDO::FETCH_ASSOC);
    $num=1;
    $mem->set('num',$num);
    echo "这是数据库";
 //  $mem->flush();


}

?>
<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
</head>
<body>
    <table border="1">
        <tr>
            <td>编号</td>
            <td>名字</td>
            <td>密码</td>
            <td>时间</td>
            <td>状态值</td>
        </tr>
        <?php foreach ($arr as $key => $val ){ ?>
            <tr>
                <td><?php echo $val['id']?></td>
                <td><?php echo $val['name']?></td>
                <td><?php echo $val['pwd']?></td>
                <td><?php echo $val['time']?></td>
                <td><?php echo $val['sta']?></td>
            </tr>
        <?php }?>
    </table>
</body>
</html>