NoSQL数据库之Redis数据库管理(PHP-REDIS实例)

php  /  管理员 发布于 5年前   415

一.redis.php

<?php      //实例化      $redis = new Redis();      //连接服务器      $redis->connect("localhost");      //授权      $redis->auth("lamplijie");      //相关操作      $redis->set("name","lampbrother");      $data = $redis->key("*");      var_dump($data);

页面显示结果：

array(1) { [0]=> string(4) "name" }

 

二.简单回顾redis的四种数据类型

        a.string：最简单的数据类型

set user:001:name lijieset user:001:age 20

        b.hash：可以当做表，hash table，比string速度快

hset user:001 name lamp age 20hset user:001 sex nanhset user:002 name lijie age 20hgetall user:001

        c.list：栈、队列

        d.set：并集、交集、差集

        e.zset：set升级版，多了一个顺序

 

三.小型的用户管理系统（用户的增删改查、分页、登陆退出、加关注）

    redis.php

<?php    //实例化    $redis = new Redis();    //连接服务器    $redis->connect("localhost");    //授权    $redis->auth("lamplijie");

    add.php

<form action="reg.php" method="post">    用户名：<input type="text" name="username"/><br/>    密码：<input type="password" name="password"/><br/>    年龄：<input type="text" name="age"/><br/>    <input type="submit" value="注册"/>    <input type="reset" value="重新填写"/></form>

    reg.php

<?php    require("redis.php");    $username = $_POST['username'];    $password = md5($_POST['password']);    $age = $_POST['age'];    echo $uid = $redis->incr("userid");    $redis->hmset("user:".$uid,array("uid"=>$uid,"username"=>$username,"password"=>$password,"age"=>$age));    $redis->rpush("uid",$uid);    $redis->set("username:".$username,$uid);    header("location:list.php");

    list.php

<a href="add.php">注册</a><?php   require("redis.php");   if(!empty($_COOKIE['auth'])){       $id = $redis->get("auth:".$COOKIE['auth']);       $name = $redis->hget("user:".$id,"username");?>欢迎您，<?php echo $name?>,<a href="logout.php">退出</a><?php}else{?><a href="login.php">登陆</a><?php}    //用户总数    $count = $redis->lsize("uid");        //页大小    $page_size = 3;    //当前页码    $page_num = (!empty($_GET['page']))?$_GET['page']:1;        //页总数    $page_count = ceil($count/$page_size);    $ids = $redis->lrange("uid",($page_num-1)*$page_size,(($page_num-1)*$page_size+$page_size-1));        //var_dump($ids);        /*    for($i=1;$i<=($redis->get("userid"));$i++) {        $data[] = $redis->hgetall("user:".$i);    }*/        foreach($ids as $v){        $data[] = $redis->hgetall("user:".$v);    }        //var_dump($data);    //$data = array_filter($data);?><table border="1">   <tr>      <th>uid</th>      <th>username</th>      <th>age</th>      <th>操作</th>   </tr><?php foreach($data as $v){?>   <tr>       <td><?php echo $v['uid']?></td>       <td><?php echo $v['username']?></td>       <td><?php echo $v['age']?></td>       <td>           <a href="del.php?id=<?php echo $v['uid']?>">删除</a>           <a href="mod.php?id=<?php echo $v['uid']?>">编辑</a>           <?php if(!empty($_COOKIE['auth']) && $id!=$v['uid']){?>               <a href="addfans.php?id=<?php echo $v['uid']?>&uid=<?php echo $id?>">加关注</a>           <?php } ?>       </td>   </tr><?php}?><tr>   <td colspan="4">       <a href="?page=<?php echo(($page_num-1)<=1)?1:($page_num-1) ?>">上一页</a>       <a href="?page=<?php echo(($page_num+1)>=$page_count)?$page_count:($page_num+1) ?>">下一页</a>       <a href="?page=1">首页</a>       <a href="?page=<?php echo $page_count ?>">尾页</a>       当前<?php echo $page_num ?>页       总共<?php echo $page_count ?>页       总共<?php echo $count ?>个用户   </td></tr></table><table border=1>   <caption>我关注了谁</caption>   <?php $data = $redis->smembers("user:".$id.":following");?>   foreach($data as $v) {      $row = $redis->hgetall("user:".$v);   <tr>      <td><?php echo $row['uid']?></td>      <td><?php echo $row['username']?></td>      <td><?php echo $row['age']?></td>   </tr>   <?php   }   ?></table><table border=1>   <caption>我的粉丝</caption>   <?php       $data = $redis->smembers("user:".$id.":followers");       foreach($data as $v) {           $row = $redis->hgetall("user:".$v);   ?>   <tr>       <td><?php echo $row['uid']?></td>       <td><?php echo $row['username']?></td>       <td><?php echo $row['age']?></td>   </tr>   <?php       }   ?></table>

    del.php

<?php   require("redis.php");   $uid = $_GET['id'];   $redis->del("user:".$uid);   $redis->lrem("uid",$uid);   header("localhost:list.php");

    mod.php

<?php  require("redis.php");  $uid = $_GET['id'];  $data = $redis->hgetall("user:".$uid);?><form action="doedit.php" method="post">    <input type="hidden" value="<?php echo $data['uid']?>" name="uid"/>    用户名：<input type="text" name="username" value="<?php echo $data['username']?>"/><br/>    年龄：<input type="text" name="age" value="?php echo $[data['age']?>"/><br/>    <input type="submit" value="修改"/>    <input type="reset" value="重新填写"/></form>

    doedit.php

<?php   $uid = $_POST['uid'];   $username = $_POST['username'];   $age = $_POST['age'];   $a = $redis->hmset("user:".$uid,array("username"=>$username,"age"=>$age));   if($a) {       header("location:list.php");   }else {       header(location:mod.php?id=".$uid);   }

    login.php

<?php    require("redis.php");    $username = $_POST['username'];    $pass = $_POST['password'];    $id = $redis->get("username:".$username);    if(!empty($id)) {        $password = $redis->hget("user:".$id,"password");        if(md5($pass) == $password) {            $auth = md5(time().$username.rand());            $redis->set("auth:".$auth,$id);            setcookie("auth", $auth, time() + 86400);            header("location:list.php");        }    }?><form action="" method="post">     用户名：<input type="text" name="username"/><br/>     密码：<input type="password" name="password"/><br/>     <input type="submit" value="登陆"/></form>

    logout.php

<?php    setcookie("auth","",time()-1);    header("location:list.php");

    addfans.php

<?php    $id = $_GET['id'];    $uid = $_GET['uid'];    require("redis.php");    $redis->sadd("user:".$uid.":following",$id);    $redis->sadd("user:".$id.":followers",$uid);    header("location:list.php");

    当然，采用sdiff user:1:following user:2:following语句，用户1可以向用户2推荐关注（即用户1的关注与用户2的关注的差集）。