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>  ");

  }

  ?>