本节内容:
redis数据库管理
一、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 lijie
set user:001:age 20
b.hash:可以当做表,hash table,比string速度快
hset user:001 name lamp age 20
hset user:001 sex nan
hset user:002 name lijie age 20
hgetall 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(!emptyempty($_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 = (!emptyempty($_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(!emptyempty($_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(!emptyempty($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的关注的差集)。