留言界面功能包括 添加新留言,对留言进行编辑和删除,个人中心和退出登陆
源码如下
<?php session_start(); ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<?php
if (isset($_SESSION["uid"])){
echo "欢迎你:" . $_SESSION["username"];//开头设置session这里调用session
echo "<br>";
$uid = $_SESSION['uid'];//活动当前用户的uid
echo "<a href='pcenter.php?uid=$uid'>个人中心</a>";
echo "<br>";
echo "<a href='123.php'>退出</a>";
}else{
die("无权访问,请登录后查看!<meta http-equiv='Refresh' content='0;url=123.php'/>");
}
?>
<center>
<title>留言</title>
</head>
<body>
<h1>欢迎你!</h1>
<table border="0" cellpadding="30">
<tr>
<th>留言人</th>
<th>留言</th>
<th>ip</th>
<th>性别</th>
<th>时间</th>
</tr>
<?php
include "conn.php";
$sql = "select * from message";
$result = mysqli_query($conn,$sql);
while ($message = mysqli_fetch_array($result) ) {
$uid = $message['uid'];
echo "<tr>";
$sql1 = "select username,sex from user where uid =$uid";//通过uid获得当前用户的名字和性别
$result1 = mysqli_query($conn,$sql1);
$persion = mysqli_fetch_array($result1);
$user = $persion["username"];
$sex = $persion["sex"];
echo "<td>". $user ."</td>";
echo "<td>". $message["content"] ."</td>";
echo "<td>". $message["ip"] ."</td>";
echo "<td>". $sex ."</td>";
echo "<td>". $message["time"] ."</td>";
//echo $message["uid"];
echo "<br>";
//echo $_SESSION["uid"];
if ($message["uid"] == $_SESSION["uid"]) //判断登陆人的uid和留言人的uid时候一样,如果一样就是一个人,可以对留言进行操作
{
echo "<td> <a href='bianji.php?mid=".$message["id"]."'>编辑</a> <a href='del.php?mid=".$message["id"]."'>删除 </a></td>";//编辑和删除是单独对每条留言进行操作,每条留言都有一个id
//echo "</tr>";
}else{
echo "<td>编辑 删除</td>";
}
echo "</tr>";
}
?>
</table>
<form method="post" action="message.php">
<textarea name="content" rows="10" cols="80"></textarea>
<br />
<input type="submit" name="submit" value="添加留言">
<input type="reset" name="reset" value="重置">
</center>
</body>
</html>
效果图:
2、对留言的编辑功能包括只能对当前用户留的言进行编辑,然后保存
<meta charset="utf-8">
<?php
include "conn.php";
//$mid = $_GET["mid"];
//$result = mysqli_query($conn,$sql);
//$message = mysqli_fetch_array($result);
if (isset($_POST["submit"])) {
$cmid = $_POST["cmid"];
$content = $_POST["content"];
if(!empty($content)){
$sql2 = "update message set content='$content' where id=$cmid";
//echo $sql2;
$result1 = mysqli_query($conn,$sql2);
if ($result1) {
echo "<script>alert('编辑成功')</script>";
echo "<script>window.location.href='ly.php'</script>";
}else{
die("数据库错误" .mysqli_error($conn));
}
}else{
echo "留言不能为空!";
}
}else{
$mid = $_GET["mid"];
$sql = "select * from message where id = $mid";
$result = mysqli_query($conn,$sql);
$message = mysqli_fetch_array($result);
}
?>
<!DOCTYPE html>
<html>
<head>
<title>留言编辑</title>
</head>
<body>
<form method="post" action="bianji.php">
<textarea name="content" rows="10" cols="80" ><?php echo $message["content"];?></textarea><!--将原来的留言放到编辑框中进行编辑-->
<br />
<input type="hidden" name="cmid" value="<?php echo $_GET["mid"];?>"><!--设置一个隐藏属性,获得留言的id-->
<input type="submit" name="submit" value="添加留言">
<input type="reset" name="reset" value="重置">
</form>
</body>
</html>
效果图:
3、删除留言,只能删除当前用户的留言
源码如下:
<meta charset="utf-8">
<?php
include "conn.php";
$mid = $_GET["mid"];//获得该条留言的id
$sql = "delete from message where id=$mid";//通过id删除这条留言
$result = mysqli_query($conn,$sql);
if($result){
echo "<script>alert('留言删除成功!')</script>";
echo "<script>window.location.href='ly.php'</script>";
}
效果图:
用户1的留言已删除