php+mysql写的简单留言本实例代码
2018-09-07 17:45
guestbook.php:
<head>
<metahttp-equiv=Content-Languagec>
<metahttp-equiv=Content-Typec>
<title></title>
<STYLE>A:link{
COLOR:#002878;TEXT-DECORATION:none
}
A:visited{
COLOR:#002878;TEXT-DECORATION:none
}
A:active{
TEXT-DECORATION:none
}
A:hover{
COLOR:#cc1111;TEXT-DECORATION:none
}
P{
COLOR:#002878;FONT-SIZE:9pt
}
TABLE{
COLOR:#002878;FONT-SIZE:9pt
}
LI{
COLOR:#002878;FONT-SIZE:9pt;LINE-HEIGHT:14pt
}
UL{
COLOR:#002878;FONT-SIZE:9pt
}
}
</STYLE>
</head>
<body>
<divalign=center>
<center>
<tableborder=0cellpadding=0cellspacing=0width=574height=312>
</center>
<tr>
<td><palign=center>高三<6>班留言本本</br></td>
</tr>
<tr>
<tdwidth=574height=272valign=top>
<formmethod=POSTaction=ly.php>
<tableborder=0cellpadding=0cellspacing=0width=100%>
<center>
<tr>
<tdwidth=26%align=right>
姓名：</td>
<tdwidth=74%><inputstyle=font-size:9pt;width:186;background-color:#f8f8f8;height:19;border:1pxsolid#9a9999
type=textname=T1size=13></td>
</tr>
<tr>
<tdwidth=26%align=right>
EMAIL：</td>
<tdwidth=74%><inputstyle=font-size:9pt;width:186;background-color:#f8f8f8;height:19;border:1pxsolid#9a9999name=T2size=13></td>
</tr>
<tr>
<tdwidth=26%align=right>
个人主页：</td>
<tdwidth=74%><inputstyle=font-size:9pt;width:186;background-color:#f8f8f8;height:19;border:1pxsolid#9a9999name=T3size=13value=
</tr>
<tr>
<tdwidth=26%align=right>
主题：</td>
<tdwidth=74%><inputstyle=font-size:9pt;width:186;background-color:#f8f8f8;height:19;border:1pxsolid#9a9999name=T4size=13></td>
</tr>
<tr>
<tdwidth=26%align=rightvalign=top>
留言：</td>
<tdwidth=74%><textareastyle=font-size:9pt;width:313;background-color:#f8f8f8;height:177;border:1pxsolid#9a9999rows=10name=S1cols=45></textarea></td>
</tr>
<tr>
<tdwidth=100%align=rightcolspan=2>
</td>
</tr>
</table>
<palign=center>
<inputtype=submitvalue=提交name=B1><inputtype=resetvalue=重写name=B2></p>
</form>
</center>
</td>
</tr>
</table>
<hrsize=1color=#6666FF>
</div>
<divalign=center>
<center>
<tableborder=0cellpadding=0cellspacing=0width=603height=294>
<tr>
<tdwidth=603height=294>
<?
include(connect.rec);
$qh=mysql_query(SELECTCOUNT(*)ASrcntFROMguestbook);
$data=mysql_fetch_array($qh);
$nr=$data[rcnt];
//判断偏移量参数是否传递给了脚本，如果没有就使用默认值0
if(empty($offset))
{
$offset=0;
}
//查询结果（这里是每页20条，但你自己完全可以改变它）
//$result=mysql_query(SELECT*fromguestbookORDERBYtimedescLIMIT$offset,5);
$result=mysql_query(SELECT*fromguestbookLIMIT$offset,5);
//显示返回的5条记录
while($data=mysql_fetch_array($result))
{
printf(姓名:<fontcolor=#000000>%s</font><br>,$data[name]);
printf(EMAIL:<fontcolor=#3366FF>%s</font><br>,$data[mail]);
printf(个人主页:<fontcolor=#3366FF>%s</font><br>,$data[url]);
printf(来自:<fontcolor=#3366FF>%s</font><br>,$data[ip]);
printf(留言时间:<fontcolor=#3366FF>%s</font><br>,$data[time]);
printf(主题:<fontcolor=#3366FF>%s</font><br>,$data[title]);
printf(内容:<fontcolor=#000000>%s</font><br>,$data[ly]);
printf(<hrsize=1color=#6666FF>);
}
//下一步，要写出到其它页面的链接
if($offset)//如果偏移量是0，不显示前一页的链接
{
$preoffset=$offset-5;
print<ahref=$PHP_SELF?offset=$preoffset>前一页</a>n;
}
//计算总共需要的页数
$pages=ceil($nr/5);//$pages变量现在包含所需的页数
for($i=1;$i<=$pages;$i++)
{
$newoffset=5*$i-5;
print<ahref=$PHP_SELF?offset=$newoffset>$i</a>n;
}
//检查是否是最后一页
$next=$offset+5;
if($next<$nr)
{
print<ahref=$PHP_SELF?offset=$next>下一页</a>n;
}
printf(<ahref=javascript:history.back()>返回</a>)
?>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>
ly.php:
<?
include(connect.rec);
$name=$T1;
$mail=$T2;
$url=$T3;
$title=$T4;
$time=date(Y-m-jH:i:s);
$ip=getenv(REMOTE_ADDR);
$ly=$S1;
$result=mysql_query(insertintoguestbook(name,mail,url,ip,time,title,ly)values($name,$mail,$url,$ip,$time,$title,$ly));
if($result==1)
{
echo(留言成功！);
printf(<scriptlanguage=javascript>);
printf(location=guestbook.php);
printf(</script>);
}
else
{
echo(留言失败！);
printf(<ahref=javascript:history.back()>返回</a>);
}
?>