php+access分页显示代码-实例教程（TC711）

Tc711Com提示: php access分页代码, 专门写的实例教程,亲测可用.

<?php
$rs=new com("adodb.recordset");
$rs->open("select * from news order by id desc",$conn,1,1);
                                $rs->pagesize=5;
                                $page=trim($_GET['page']);

                                if($page=="" || is_numeric(intval($page))<=0){
                                $page=1;
                                }else if(intval($page)>$rs->pagecount){

                                $page=$rs->pagecount;}

                                $page=intval($page);

                                if(!$rs->eof||$rs->bof){
                                        $rs->absolutepage=$page;
                                        $mypagesize=$rs->pagesize;
                                        $i=$rs->recordCount()-($page-1)*$rs->pagesize;

while (!$rs->eof && $mypagesize>0 && $i>=$rs->recordCount()-1-$rs->pagesize*$page)
{
?>
      <tr >
        <td height="34" align="center" ><?php echo $rs->fields("id")?></td>
        <td align="left">  <a href="?id=<?php echo $rs->fields("id")?>"><?php echo $rs->fields("title")?></a></td>
      </tr>
<?php $rs->movenext();
$mypagesize--;
$i--; }
#出自: www.tc711.com   转发请保留出处.
}?>
    </table><br />
    <div align='center'>
<a href="?page=1">首页</a> <a href="?page=<? if($page>1){echo $page-1;}else{echo 1;}?>">上页</a> <a href="?page=<? if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>">下页</a> <a href="?page=<? echo $rs->pagecount;?>">尾页</a>  共<? echo $rs->recordCount(); ?>篇文章，分<? echo $rs->pagecount;?>页显示，现在是第<? echo $page;?>页
<br /><br />
</div>
出自: 绵阳网站建设www.tc711.com   转发请保留出处.

更多的php+access分页显示代码-实例教程（TC711）请到论坛查看: http://BBS.TC711.COM

【双击滚屏】【评论】【收藏】【打印】【关闭】来源：互联网日期：2012-12-24