用PHP制作简单的留言板 mysql.ppt

用PHP制作简单的留言板一、操作数据库读取数据：
$sql="select*fromuserswherename='".$username."'";
$result=mysql_query($sql);
$num=mysql_num_rows($result);
$rs=mysql_fetch_array($result);添加数据：
$sql="insertintousers(id,name,sex,password,realname,address,tel,email,flag,qq,time,odernum)values('$getid','$name','$sex','$password','$realname','$address','$tel','$email',0,'$qq',NOW(),0)";
$result=mysql_query($sql);
mysql_close();删除数据：
$sql="deletefromlowhereid=".$id;
mysql_query($sql);
mysql_close();修改（更新）数据：
$sql="updateuserssetqq='".$newqq."'wherename='".$username."'";
mysql_query($sql);
mysql_close();Style获取留言者IP，留言时间检查表单是否为空检查Email格式检查纯数字输入打开QQ对话框打开OutlookExpress发送E-mail分页的实现if($page==1)
$number=1;
else
$number=($page-1)*$pagesize+1;
if($_SESSION["key"]==1)
$sql="selectid,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time,'%Y年%m月%d日%T'),revert,flagfromloorderbyiddesclimit$offset,$pagesize";//用到了DATE-FORMAT格式化日期格式
else
$sql="selectid,username,sex,qq,email,info,ip,DATE_FORMAT(submit_time,'%Y年%m月%d日%T'),revert,flagfromlowhereflag='1'orderbyiddesclimit$offset,$pagesize";
$result=mysql_query($sql);
$num=mysql_num_rows($result);?>if($num>0){
while($row=mysql_fetch_array($result))
{
}
else
echo“没有留言！”；<?php
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if($page==1&&$pages>1)
{
echo"首页&nbsp;|&nbsp;";
echo"上一页&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$next."\">下一页</a>&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$last."\">尾页</a>&nbsp;|&nbsp;";
}
elseif($page>=1&&$page!=$pages&&$num>0)
{
echo"<ahref=\"index.php?page=".$first."\">首页</a>&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$prev."\">上一页</a>&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$next."\">下一页</a>&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$last."\">尾页</a>&nbsp;|&nbsp;";
}elseif($page==$pages&&$page!=1)
{
echo"<ahref=\"index.php?page=".$first."\">首页</a>&nbsp;|&nbsp;";
echo"<ahref=\"index.php?page=".$prev."\">上一页</a>&nbsp;|&nbsp;";
echo"下一页&nbsp;|&nbsp;";
echo"尾页&nbsp;|&nbsp;";
}
elseif($page==$pages)
{
echo"首页&nbsp;|&n