留言板如何分页显示,我写的以下代码,让每页显示两条留言,结果是:第一页可以显示,再点下一页还是显示第一页的,也就是说,只能显示第一页中两条留言,无法跳转到下一页。请教各位能不能帮我改一下代码,在此先多谢咯。
<?php
$conn=mysql_connect("localhost","root","zzz");
mysql_select_db("guest_book");
mysql_query("set names gb2312");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit ".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
}
if($pageNumber>1)
{
echo "<a href=index.php?pageNumber" .($pageNumber-1). ">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber<$totalCount/$pageSize)
{
echo "<a href=index.php?$pageNumber" .($pageNumber+1). ">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>
<?php
$conn=mysql_connect("localhost","root","zzz");
mysql_select_db("guest_book");
mysql_query("set names gb2312");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit ".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
}
if($pageNumber>1)
{
echo "<a href=index.php?pageNumber" .($pageNumber-1). ">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber<$totalCount/$pageSize)
{
echo "<a href=index.php?$pageNumber" .($pageNumber+1). ">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>
<?php
$conn=mysql_connect("localhost","root","zzz");
mysql_select_db("guest_book");
mysql_query("set names gb2312");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit ".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
} if($pageNumber > 1)
{
//应该是 "pageNumber="
echo "<a href=index.php?pageNumber=" .($pageNumber-1). ">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber < $totalCount/$pageSize)
{
// 应该是"pageNumber="
echo "<a href=index.php?pageNumber=" .($pageNumber+1). ">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>
下面是我的代码:<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8"/>
<title>留言本</title>
</head>
<body>
<div align="right"><a href="admin_login.htm" target="_blank" >
<font size="+1" face="隶书" >留言板管理 </font></a>
</div>
<div align="center"><font face="黑体"><h2>PHP学习交流留言板 </h2></font>
</div>
<?php
$conn=mysql_connect("localhost","root","123456");
mysql_select_db("guest_book");
mysql_query("set names utf8");
$pageSize=2;
$pageNumber=$_GET['pageNumber'];
if($pageNumber==null)
$pageNumber=1;
$rs=mysql_fetch_row(mysql_query("select count(*) from contents"));
$totalCount=$rs[0];
$exec="select * from contents limit ".(($pageNumber-1)*$pageSize).",2";
$result=mysql_query($exec);
while($rs=mysql_fetch_object($result))
{
echo "<table><tr><td>姓名:".$rs->name."</td></tr>";//显示姓名
echo "<tr><td>留言:".$rs->conten."</tr></td></table><br/>";//显示留言
echo
"…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………";
echo "<br/>";
} if($pageNumber > 1)
{
//应该是 "pageNumber="
echo "<a href=index.php?pageNumber=" .($pageNumber-1). ">前一页 </a>";
}
else
{
echo "前一页 ";
}
if($pageNumber < $totalCount/$pageSize)
{
// 应该是"pageNumber="
echo "<a href=index.php?pageNumber=" .($pageNumber+1). ">后一页</a>";
}
else
{
echo "后一页";
}
mysql_close();
?>
<div align="CENTER"><a href="message_post.html" target="_blank" >
<font size="+2" face="隶书" ><p> 我要留言 </font></a>
</div>
</body>
</html>