發(fā)布留言界面
查看留言界面
建立數(shù)據(jù)庫創(chuàng)建表
//conn.php
<?php
$conn = MySQLi_connect("localhost", "root", "root") or die("數(shù)據(jù)庫鏈接錯誤");
mysqli_select_db($conn,"bbs");
mysqli_query($conn, "set names utf8");
?>
數(shù)據(jù)庫
創(chuàng)建發(fā)布留言界面
//add.html
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>留言頁面</title>
<link rel="stylesheet" type="text/css" href="css.css">
<?php include ("add.php")?> //發(fā)布留言數(shù)據(jù)插入數(shù)據(jù)庫
</head>
<body>
<script>
function CheckPost() {
if(myform.user.value=="")
{
alert("請?zhí)顚懹脩?quot;);
myform.user.focus();
return false;
}
if (myform.title.value.length<5)
{
alert("標題不能少于5個字符");
myform.title.focus();
return false;
}
if (myform.content.value=="")
{
alert("內(nèi)容不能為空");
myform.content.focus();
return false;
}
}
</script>
<b> <a href="list.php">瀏覽留言</a> </b>
<hr size=1>
<form action="add.php" method="post" name="myform" onsubmit="return CheckPost();">
用戶：<input type="text" size="10" name="user"/><br>
標題：<input type="text" name="title" /><br>
內(nèi)容：<textarea name="content"></textarea><br>
<input type="submit" name="submit" value="發(fā)布留言" />
</form>
</body>
</html>
創(chuàng)建發(fā)布留言add.php頁面
//add.php
<?php
include ("conn.php");
$id=$_POST['id'];
$user=$_POST['user'];
$title=$_POST['title'];
$content=$_POST['content'];
if($_POST['submit']){
$sql="insert into message(id,user,title,content,lastdate)values('','$user','$title','$content',now())";
mysqli_query($conn,$sql);
echo "<script>alert('提交成功！返回首頁。');location.href='add.html';</script>";
}
?>
創(chuàng)建查看留言頁面
//list.php
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>瀏覽留言</title>
<link rel="stylesheet" type="text/css" href="views/css.css">
<?php include ("conn.php"); ?>
</head>
<body>
<table width=500 border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#add3ef" >
<?php
$sql="select * from message order by id DESC"; //查詢數(shù)據(jù)庫
$query=mysqli_query($conn,$sql);
while($row=mysqli_fetch_array($query)){ ?>
<tr bgcolor="#eff3ff">
<td><font color="red">標題：</font>
<?php echo $row['title'];?>
<font color="red">用戶：</font>
<?php echo $row['user'];?>
<div align="right">
<a href="del.php?id=<?php echo $row['id'];?>">刪除</a>
</div>
</td>
</tr>
<tr bgColor="#ffffff">
<td>發(fā)表內(nèi)容：<?php echo $row['content'];?></td>
</tr>
<tr bgColor="#ffffff">
<td><div align="right">時間：<?php echo $row['lastdate'];?></td>
</tr>
<?php } ?>
<tr bgcolor="#f0fff0">
<td><div align="right"><a href="add.html">返回留言</a> </td>
</tr>
</table>
</body>
</html>
創(chuàng)建刪除留言del.php頁面
<?php include 'conn.php'; $id = $_GET['id']; $query="delete from message where id=".$id; mysqli_query($conn,$query); //頁面跳轉(zhuǎn)，實現(xiàn)方式為JAVAscript $url = "list.php"; echo "<script>"; echo "window.location.href='$url'"; echo "</script>"; ?>
