读取数据记录的分页代码
<?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)) {
http://www.96pc.com/Bc/PHP/11678.html?> <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> "
; } ?>
大家怎么看啊?
