PHP实现分页的一个示例

  • A+
所属分类：PHP编程
  1. <?php
  2. if(!$whichpage)
  3. {
  4. $notepage=1;
  5. }
  6. else
  7. {
  8. $notepage=$whichpage;
  9. }
  10. $noterecs=0;
  11. $pagesize=10;
  12. $bbsconn=mysql_connect("localhost","root");
  13. mysql_select_db("rainwindy",$bbsconn);
  14. $bbsresult=mysql_query("select * from bbs order by id desc",$bbsconn);
  15. $rsnum=mysql_num_rows($bbsresult);
  16. $pagecount=ceil($rsnum/$pagesize);
  17. mysql_data_seek($bbsresult,($notepage-1)*10);
  18. ?>
  19. <div align=right>
  21. <table border="0" width="730" cellspacing="0" cellpadding="0">
  22.     <tr>
  23.       <td width="41" height="30" bgcolor="#C0C0C0" bordercolor="#0000FF" valign="middle" align="center">编号</td>
  24.       <td width="100" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center">用户名</td>
  25.       <td width="100" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center">发表人</td>
  26.       <td width="311" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center">文章标题</td>
  27.       <td width="239" height="30" bordercolor="#0000FF" bgcolor="#C0C0C0" valign="middle" align="center">发表时间</td>
  28.    </tr>
  29. <?php
  30. while(($bbsrow=mysql_fetch_array($bbsresult)) && ($noterecs<=9))
  31. {
  33. ?>
  34. <tr>
  35.       <td width="41" height="30" bgcolor="#FFFFCC" valign="middle" align="center"><?php echo $bbsrow["id"] ?></td>
  36.       <td width="100" height="30" bgcolor="#FFFFCC" valign="middle" align="center"><?php echo $bbsrow["usr"] ?></td>
  37.       <td width="100" height="30" bgcolor="#FFFFCC" valign="middle" align="center"><?php echo $bbsrow["name"] ?></td>
  38.       <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>
  39.       <td width="239" height="30" bgcolor="#FFFFCC" valign="middle" align="center"><?php echo $bbsrow["bbstime"] ?></td>
  41. </tr>
  42. <?php
  43. $noterecs=$noterecs+1;
  44. }
  45. ?>
  46. </table>
  48. </div>
  49. <br>
  50. <br>
  51. <center>
  52. <?php
  53. $pad=0;
  54. for($counter=1;$counter<=$pagecount;$counter++)
  55. {
  56. if($counter>=10)
  57. {
  58. $pad="";
  59. }
  61. echo("<font size=+1 color=red><a href='bbsbl.php?whichpage=$counter'>".$pad.$counter."</a></font>  ");
  62. }
  63. ?>
1 2 3