memcache

最新推荐文章于 2022-04-27 16:09:51 发布

转载最新推荐文章于 2022-04-27 16:09:51 发布 · 265 阅读

本文介绍了一个基于PHP和Memcache实现的手机号查询系统。该系统通过缓存技术和API调用，有效地提高了查询效率并减少了数据库负担。文章展示了完整的HTML前端界面及后端逻辑，包括如何设置缓存、读取缓存数据以及处理高频查询。

<!DOCTYPE html>
<html>
<head lang="en">
    <meta charset="UTF-8">
    <title></title>
    <script src="jquery-2.1.1.min.js"></script>
</head>
<body>
<center>
    <table>
        <tr>
            <td>用户名：</td>
            <td><input type="text"/></td>
        </tr>
        <tr>
            <td>手机号码：</td>
            <td><input type="text" id="tel"/><span></span></td>
        </tr>
        <tr>
            <td><button>查询</button></td>
        </tr>
    </table>
</center>
</body>
</html>
<script>
$(function(){
    $("button").click(function(){
        var obj=$(this);
        var tel=$("#tel").val();
        var url='http://www.lijian.com/m9/d919a/index.php?tel='+tel;
        $.get(url,function(msg){
         //alert(msg)
//            var str='';
//            for(var i= 0;i<msg.length;i++){
//                str+='<span>'+msg[i].name+'</span>'
//            }
            $("span").html(msg);
        },'json')
    })
})
</script>

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2016/9/20
 * Time: 9:28
 */
header("content-type:text/html;charset=utf-8");
//$pdo=new PDO('mysql:host=localhost;dbname=test','root','root');
//$pdo->exec("set names utf8");
//开启缓存
$mem=new Memcache();

$mem->connect("127.0.0.1",11211);
//清除缓存
//$mem->flush();die;
$tel=$_GET['tel'];

//从缓存取出被查询了的次数
$num=$mem->get($tel);
set_time_limit(0);
$url = "http://api.k780.com:88/?app=phone.get&phone=".$tel."&appkey=20900&sign=b07840f44dc8e8c7b08dd44b12032338&format=json";
if($num){
//已存在
    //每一次加一
    $num++;
    $mem->set($tel,$num);
    //再判断次数
    if($num>5){
        //大于五次取memcache数据
        $str=$mem->get('data'.$tel);
        echo $str;
    }elseif(
        //第五次取出的数据放到memcache
        $num==5
    ){
//        $data=$pdo->query("select * from tel WHERE tel='$tel'")->fetchAll(PDO::FETCH_ASSOC);
//        $str=json_encode($data);
//        $mem->set('data'.$tel,$str);
//        echo $str;
        $str = file_get_contents($url);
        $data = json_decode($str,true);
        $operators = $data['result']['operators'];
        echo json_encode($operators);

    }else{
        //直接查输出
//        $data=$pdo->query("select * from tel WHERE tel='$tel'")->fetchAll(PDO::FETCH_ASSOC);
//        $str=json_encode($data);
//        echo $str;
        $str = file_get_contents($url);
        $data = json_decode($str,true);
        $operators = $data['result']['operators'];
        echo json_encode($operators);

    }
}else{
    //第一次访问
    $mem->set($tel,1);
//    $data=$pdo->query("select * from tel WHERE tel='$tel'")->fetchAll(PDO::FETCH_ASSOC);
//    echo json_encode($data);
    $str = file_get_contents($url);
    $data = json_decode($str,true);
    $operators = $data['result']['operators'];
    echo json_encode($operators);

}