PHP实现分页的一个示例

【 tulaoshi.com - PHP 】

<?php
if(!$whichpage)
{  
$notepage=1;
}
else
{
$notepage=$whichpage;
}
$noterecs=0;
$pagesize=10;
$bbsconn=mysql_connect("localhost","root");
mysql_select_db("rainwindy",$bbsconn);
$bbsresult=mysql_query("select * from bbs order by id desc",$bbsconn);
$rsnum=mysql_num_rows($bbsresult);
$pagecount=ceil($rsnum/$pagesize);
mysql_data_seek($bbsresult,($notepage-1)*10);
?
<div align=right

<table border="0" width="730" cellspacing="0" cellpadding="0"
    <tr
      <td width="41" height="30" bgcolor="#C0C0C0" bordercolor="#0000FF" valign="middle" align="center"编号</td
      <td width="100" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center"用户名</td
      <td width="100" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center"发表人</td
      <td width="311" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center"文章标题</td
      <td width="239" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center"发表时间</td
   </tr
<?php
while(($bbsrow=mysql_fetch_array($bbsresult)) && ($noterecs<=9))
{

?
<tr
      <td width="41" height="30" bgcolor="#FFFFCC" valign="middle" align="center"<?php echo $bbsrow["id"] ?</td
      <td width="100" height="30" bgcolor="#FFFFCC" valign="middle" align="center"<?php echo $bbsrow["usr"] ?</td
      <td width="100" height="30" bgcolor="#FFFFCC" valign="middle" align="center"<?php echo $bbsrow["name"] ?</td
      <td width="311" height="30" bgcolor="#FFFFCC" valign="middle" align="center"<a href="bbsdisp.php?whichnote=<?php echo $bbsrow["id"] ?" target="disp"<?php echo $bbsrow["title"] ?</a</td
      <td width="239" height="30" bgcolor="#FFFFCC" valign="middle" align="center"<?php echo $bbsrow["bbstime"] ?</td
       
</tr
<?php
$noterecs=$noterecs+1;
}
?
</table

</div
<br
<br
<center
<?php
$pad=0;
for($counter=1;$counter<=$pagecount;$counter++)
{
if($counter=10)
{  
$pad="";
}

echo("<font size=+1 color=red<a href='bbsbl.php?whichpage=$counter'".$pad.$counter."</a</font&nbsp;&nbsp;");
}
?