php简易留言板程序代码

这是一个最基础的留言板程序了，但是己经有了留言板程序基本功能，很适合于php初学者用用，学习用啊，当然也可以用于企业网站也是很不错的哦。

代码如下

复制代码

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);
?>

简易留言板教程（PHP iask）

while($rs=mysql_fetch_object($result)){
?>



if(isset($_SESSION['login'])&&$_SESSION['login']){
?>



}
?>




}
?>

留言人：name?> |Email：email?>|QQ:qq?>|留言时间：post_time+8*3600)?>

回复 | 删除

留言内容：post))?>


回复内容：revert))?>[revert_time!="") echo date("Y-m-d H:i:s",$rs->revert_time+8*3600)?> ]

if($page>0) echo "上一页|" ;
if($page下一页" ;
?>

姓名：
Email：
QQ：
留言内容：
管理员登录

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
tem;
exit();
}
if($qq==""&&$email==""){
echo
tem;
exit();
}
if($qq!=""&&(!is_numeric($qq)||$qq>9999999999||$qq echo
tem;
exit();
}
if($email!=""&&(!ereg("^([a-zA-Z0-9_-])+@([a-zA-Z0-9_-])+(.[a-zA-Z0-9_-])+",$email)||strlen($email)>60)){
echo
tem;
exit();
}
if(strlen($post)>400){
echo
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
tem;
}
else{
echo
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 ""; exit(); } else { echo ""; } } ?> 用户名： 密码：

删除留言的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 ""; 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 ""; } } ?>

回复留言的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 ""; exit(); } if($_POST['Submit']){ if(!get_magic_quotes_gpc()){ foreach ($_POST as $items){ $items = addslashes($items); } } if(strlen($_POST['revert'])>400){ echo ""; 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 ""; exit(); } else { echo ""; } } ?> 回复内容：