php access数据库分页显示（实例代码）

<?php
$conn = new com(”adodb.connection”);
//设置数据库连接驱动
$connstr=”provider=microsoft.jet.oledb.4.0;data source=”.realpath(”db1.mdb”);
$conn->open($connstr);//调用com类的open()方法来执行上述连接驱动
$rs=new com(”adodb.recordset”);
$sql=”select * from article”;
$rs->open($sql,$conn,1,3);
$rs->pagesize=5;
if((trim(intval($_GET['page']))==”")||(intval($_GET['page'])>$rs->pagecount)||(intval($_GET['page'])<=0)){

$page=1;
}else{
   $page=intval($_GET['page']);
    }
if($rs->eof||$rs->bof){
   echo “没有号码！”;
   }else{
   
    $rs->absolutepage=$page;
    $mypagesize=$rs->pagesize;   
    while(!$rs->eof && $mypagesize>0){    
     echo iconv(’gb2312′,’utf-8′,$rs->fields['title'].”<br/>”);
     $mypagesize–;
     $rs->movenext;
     }
    }
  
//if($page>=2)
?>
共<?php echo $rs->pagecount;?>页 第<?php echo $page;?>页 <a href=”?page=1″>首页</a> <a href=”?page=<?php if($page>1){echo $page-1;}else{echo 1;}?>”>上页</a>
<?php $i=$page;
for($i;$i<=$page+4;$i++){
if($i<=$rs->pagecount){
echo “<a href=?page=”.$i.”>[".$i."]</a>”;
}

}?>
<a href=”?page=<?php if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>”>下页</a> <a href=”?page=<?php echo $rs->pagecount;?>”>尾页</a>
<?php
$rs->Close();          //关闭记录集对象和数据库连接对象
$conn->Close();
$endtime=time();
?>