【www.bbyears.com--留言】
代码如下
session_start();
$con=mysql_connect("localhost","root","root") or die("链接数据库失败!");
mysql_query("set names utf8");
mysql_select_db("GuestBook");
$pagesize = 10;//每一页显示多少留言记录
if(isset($_GET["page"])&&$_GET["page"]!="") $page=$_GET["page"];
else $page=0;
$sql = "SELECT a . * , b.name, b.email, b.qq, c.revert_time, c.revert
FROM post a
LEFT JOIN revert c ON ( a.id = c.post_id ) , guest b
WHERE a.guest_id = b.id
ORDER BY a.id DESC";
$numRecord = mysql_num_rows(mysql_query($sql));
$totalpage = ceil($numRecord/$pagesize);
$recordSql = $sql. " LIMIT ".$page*$pagesize.",".$pagesize;
$result = mysql_query($recordSql);
?>
<script language="javascript">
function checkInput(){
var Email = document.getElementById("email");
var QQ = document.getElementById("qq");
var name = document.getElementById("name");
var post = document.getElementById("post");
//验证用户名:不能超过10个字符(5个汉字),不能输入非法字符,不能为空
nameValue = name.value.replace(/s+/g,"");
var SPECIAL_STR = "~!%^&*();"?><[]{}\|,:/=+—";
var nameflag=true;
for(i=0;i
nameflag=false;
}
if(nameValue==""){
alert("请填写用户名称!");
return false;
}
if(nameValue.length>10){
alert("用户名称最多10个字符(5个汉字)!");
return false;
}
if(nameflag===false){
alert("用户名称不能包含非法字符请更改!");
return false;
}
//验证QQ号码
var par =/^[1-9]d{4,12}$/;
if(QQ.value!=""&&!par.test(QQ.value)){
alert("请输入正确的QQ号码");
return false;
}
//验证Email地址
var emailpar = /^[w-]+(.[w-]+)*@[w-]+(.[w-]+)+$/;
if(Email.value!=""&&!emailpar.test(Email.value)){
alert("请输入正确的邮箱地址!");
return false;
}
if(QQ.value==""&&Email.value==""){
alert("邮箱和QQ必选其一");
return false;
}
if(post.value==""){
alert("请输入留言内容!");
return false;
}
if(post.value.length>400){
alert("留言内容太长!");
return false;
}
}
</script>
简易留言板教程(PHP iask)
while($rs=mysql_fetch_object($result)){
?>
留言人:name?> |Email:email?>|QQ:qq?>|留言时间:post_time+8*3600)?>
if(isset($_SESSION["login"])&&$_SESSION["login"]){
?>
id?>">回复 | id?>">删除
}
?>
留言内容:post))?>
回复内容:revert))?>[revert_time!="") echo date("Y-m-d H:i:s",$rs->revert_time+8*3600)?> ]
}
?>
if($page>0) echo "上一页|" ;
if($page<$totalpage-1) echo "下一页" ;
?>
post.php文件
header("content-type:text/html;charset=utf-8");
//如果PHP设置的自动转义函数未开启,就转义这些值
if(!get_magic_quotes_gpc()){
foreach ($_POST as &$items){
$items = addslashes($items);
}
}
$name = $_POST["name"];
$qq = $_POST["qq"];
$email = $_POST["email"];
$post = $_POST["post"];
if($name==""||strlen($name)>10){
echo <<
alert("请输入正确的有户名");
history.go(-1);
</script>
tem;
exit();
}
if($qq==""&&$email==""){
echo <<
alert("Email和QQ必须输入一个!");
history.go(-1);
</script>
tem;
exit();
}
if($qq!=""&&(!is_numeric($qq)||$qq>9999999999||$qq<=9999)){
echo <<
alert("请输入正确的QQ号码");
history.go(-1);
</script>
tem;
exit();
}
if($email!=""&&(!ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$email)||strlen($email)>60)){
echo <<
alert("请输入正确的Email");
history.go(-1);
</script>
tem;
exit();
}
if(strlen($post)>400){
echo <<
alert("输入的留言内容太长!");
history.go(-1);
</script>
tem;
exit();
}
//链接数据库
$con=mysql_connect("localhost","root","root") or die("链接数据库失败!");
mysql_query("set names utf8");
mysql_select_db("GuestBook");
//把客户信息插入guest表
$insertSql="insert into guest (name,qq,email) values ("$name","$qq","$email")";
if(mysql_query($insertSql)){
$guestid = mysql_insert_id();
}
else{
echo $insertSql;
echo mysql_error();
echo "数据插入失败!";
exit();
}
//把以上插入取得的客户id和留言信息插入到post表中
$post_time = time();
$insertPostSql = "insert into post(guest_id,post,post_time) values("$guestid","$post","$post_time")";
if(mysql_query($insertPostSql)){
echo <<
alert("留言成功");
location.href="index.php";
</script>
tem;
}
else{
echo <<
alert("留言失败");
location.href="index.php";
</script>
tem;
}
?>
下面为后台管理管理的页面 login.php登录先
代码如下 session_start();
if(isset($_POST["Submit"])){
if(!get_magic_quotes_gpc()){
foreach ($_POST as &$items){
$items = addslashes($items);
}
}
if($_POST["username"]=="phpiask"&&md5($_POST["password"])=="6dc88b87062a5de19895e952fa290dad"){
$_SESSION["login"]=true;
echo "<script>alert("管理员登录成功");location.href="index.php";</script>";
exit();
}
else {
echo "<script>alert("登录失败!");</script>";
}
}
?>
删除留言的delete.php
代码如下
session_start();
header("content-type:text/html;charset=utf-8");
$con=mysql_connect("localhost","root","root") or die("链接数据库失败!");
mysql_query("set names utf8");
mysql_select_db("GuestBook");
if(!$_SESSION["login"]){
echo "<script>alert("权限不足!");location.href="index.php";</script>";
exit();
}
if(isset($_GET["id"])&&$_GET["id"]!=""){
$delRevertSql="delete from revert where post_id=".$_GET["id"];
mysql_query($delRevertSql);
$delGuestSql="delete from guest where id = (select guest_id from post where id=".$_GET["id"].")";
mysql_query($delGuestSql);
$delPostSql="delete from post where id=".$_GET["id"];
mysql_query($delPostSql);
if(mysql_error()==""){
echo "<script>alert("删除成功!");location.href="index.php";</script>";
}
}
?>
回复留言的revert.php文件
代码如下
session_start();
$con=mysql_connect("localhost","root","root") or die("链接数据库失败!");
mysql_query("set names utf8");
mysql_select_db("GuestBook");
if(!$_SESSION["login"]){
echo "<script>alert("没有登录不能回复!");location.href="index.php";</script>";
exit();
}
if($_POST["Submit"]){
if(!get_magic_quotes_gpc()){
foreach ($_POST as $items){
$items = addslashes($items);
}
}
if(strlen($_POST["revert"])>400){
echo "<script>alert("回复内容过长!");history.go(-1);</script>";
exit();
}
$post_id = $_POST["post_id"];
$revert = $_POST["revert"];
$insertRevertSql = "insert into revert (post_id,revert,revert_time) value("$post_id","$revert","$time")";
if(mysql_query($insertRevertSql)){
echo "<script>alert("回复成功");location.href="index.php";</script>";
exit();
}
else {
echo "<script>alert("回复失败!");history.go(-1);</script>";
}
}
?>