简介： 现在的分页写得太麻烦，所以我决定用一些容易看懂的方法来做一个。
这个留言簿就是了，直接可以运行的，数据库结构就是：
name:留言姓名 varchar(40) email：电子邮件 varchar(40) guest 留言内容 text,timeis 留言时间 datetime
<?
$data=mysql_connect("kevin","root","");
if($self)
{
$cont=ereg_replace("<","(",$cont);
$cont=ereg_replace(">",")",$cont);
$timeis=date('Y-m-d H:i:s');
$result=mysql_db_query("mysql","Insert into guest(name,email,guest,timeis) values('$who','$mail','$cont','$timeis')");
}
?>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.font { font-family: "宋体"; font-size: 12px; color: #666600}
.bfont { font-family: "宋体"; font-size: 12px; font-weight: bold; color: #666666}
select { font-family: "宋体"; font-size: 12px; background-color: #FFCCCC}
input { font-family: "宋体"; font-size: 12px; background-color: #FFCCCC}
a { color: #333300; text-decoration: none}
a:hover { font-weight: bold; text-decoration: underline; color: #666666}
textarea { background-color: #FFCCCC}
-->
</style>
<script language="JavaScript">
<!--
<!-- Hide from JavaScript-Impaired Browsers
function check()
{if(main.who.value==""||main.mail.value==""||main.cont.value=="")
{alert("输入不完整!");
return false}
}
function jumpto(pages)
{
if(eval(pages)<0)
{alert("输入无效，必须输入数字！");
return false;}
else
this.location="guest.php3?page="+pages;
}
// End Hiding -->
//-->
</script>
</head>
<body bgcolor="#FFFFFF" onLoad="">
<table width="80%" border="0" cellspacing="2" cellpadding="2" align="center" class="font" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
<tr bgcolor="#FFFFFF">
<td class="bfont">
<?
$results=mysql_db_query("mysql","select * from guest order by id desc");
if($results)
{$rows=mysql_num_rows($results);
$pagesize=5;
$pages=$rows/$pagesize+1;
if(isset($page))
{
$page=$page<1?1:$page;
$page=$page>$pages?$pages:$page;
}
else
$page=1;
$firstline=($page-1)*$pagesize;
$firstline=$firstline==$rows?$rows-$rows%$pagesize:$firstline;
$lastline=$page*$pagesize;
$lines=$lastline>$rows?$rows-$lastline:$pagesize;
$lastline=$lastline>$rows?$rows:$lastline;
mysql_free_result($results);
$result=mysql_db_query("mysql","select * from guest order by id desc limit ".$firstline.",".$lines);
while($myrow=mysql_fetch_row($result))
printf("留言人：%s <a href=mailto:%s>电子邮箱：%s</a> 时间:%s<br>%s<hr size=1>", $myrow[1],$myrow[2], $myrow[2], $myrow[4],nl2br($myrow[3]));
printf("共%d条记录，当前页为：第%d页，记录为第%d条到第%d条,<a href=guest.php3?page=%d>上一页</a> <a href=guest.php3?page=%d>下一页</a> ",$rows,$page,$firstline+1,$lastline,$page-1,$page+1);?>
<input type="text" name="pageis" size=5><input type="button" value="去到指定页" onclick="jumpto(pageis.value)">
<?}
else
echo "<p align=center>没有数据记录。</p>";
?>
</td>
</tr>
</table>
</td>
</tr>
</table>
<form name="main" method="post" action="guest.php3">
<table width="60%" border="3" cellspacing="2" cellpadding="2" align="center" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF" class="font" bgcolor="#000000">
<tr bgcolor="#FFFFFF">
<td>
<div align="center">姓名：
<input type="text" name="who" size="20">
�电子邮件：
<input type="text" name="mail" size="20">
<input type="hidden" name="self" value="1">
</div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">留言内容</div>
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td>
<div align="center">
<textarea name="cont" cols="45" rows="4"></textarea>
</div>
</td>
</tr>
</table>
<p align="center">
<input type="hidden" name="self" value="yes">
<input type="submit" name="Submit" value="发送" onClick="return check()">
<input type="reset" name="Submit2" value="重写">
</p>
</form>
<div align="center"><font face="Arial, Sans-Serif" size="1">Copyright ©
2000 Kevin Studio. All rights reserved</font></div>
</div>
</body>
</html>
|