先來看下效果截圖
輸入用戶名和密碼后單擊登錄轉(zhuǎn)跳到主頁
201.PNG
這里就是一個簡單的信息顯示頁面
203.PNG
下面看下源代碼
<?php session_start(); ?>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<center>
<title>留言</title>
</head>
<body background="6.jpg">
<?php
if (isset($_SESSION["uid"])){
echo"歡迎你！". $_SESSION["username"];
echo "<a href=\"percenter.php?uid='" . $_SESSION["uid"] . "'\">個人中心</a>";
echo "<a href='denglu.php'>退出</a>";
}else{
die("無權(quán)訪問，請登錄后查看！<meta http-equiv='Refresh' content='0;url=denglu.php'/>");
}
?>
<h1>歡迎你！</h1>
<table border="0" cellpadding="30">
<tr>
<th>留言人</th>
<th>留言</th>
<th>ip</th>
<th>性別</th>
<th>時間</th>
</tr>
<?php
include "my.php";
$sql = "select * from message";
$result = mysqli_query($conn,$sql);
while ($message = mysqli_fetch_array($result) ) {
echo "<tr>";
$sql1 = "select username,sex from user where uid ='".$message["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>";
if($_SESSION["uid"]==$message["uid"]){
echo "<td> <a href='bianji.php?mid=" . $message["id"] . "'> 編輯</a></td>
<td> <a href=\"shanchu.php?mid=" . $message["id"] . "\">刪除</a>
</td>";
}else{
echo "<td >編輯</td>";
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>
這幾行就是核心代碼
限制了只能刪除、編輯自己的留言和 輸出了所有的留言信息
這里有幾個sql和數(shù)據(jù)庫交互的函數(shù)
mysqli_query() , mysqli_fetch_array() ,
<?php
include "my.php";
$sql = "select * from message";
$result = mysqli_query($conn,$sql);
while ($message = mysqli_fetch_array($result) ) {
echo "<tr>";
$sql1 = "select username,sex from user where uid ='".$message["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>";
if($_SESSION["uid"]==$message["uid"]){
echo "<td> <a href='bianji.php?mid=" . $message["id"] . "'> 編輯</a></td>
<td> <a href=\"shanchu.php?mid=" . $message["id"] . "\">刪除</a>
</td>";
}else{
echo "<td >編輯</td>";
echo "<td>刪除</td>";
}
echo "</tr>";
}
?>
這幾行代碼是添加留言的
<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="重置">
看效果截圖
204.PNG
205.PNG
