下面的代码 上网COPY来的
第一页显示全部信息
每二页少5条
每三页再少5条
我想让它每页都是显示5条信息 请帮忙修改一下
<?
$conn = new com("adodb.connection");
$conn->open("provider=microsoft.jet.oledb.4.0;data source=".realpath("db.mdb"));
$rs=new com("adodb.recordset");$sql="select * from [txt]";
$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 $rs->Fields(0)->value."<br/>";
  $mypagesize–;
  $rs->movenext;
  }
 }
?><a href="?page=1">首页</a>
<a href="?page=<? if($page>1){echo $page-1;}else{echo 1;}?>">上页</a>
第<? echo $page;?>/<? echo $rs->pagecount;?>页
<a href="?page=<? if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>">下页</a>
<a href="?page=<? echo $rs->pagecount;?>">尾页</a><? $rs->Close(); $rs=null; $conn->Close(); $conn=null; ?> 

解决方案 »

  1.   

    搞出来了<?
    $conn = new com("adodb.connection");
    $conn->open("provider=microsoft.jet.oledb.4.0;data source=".realpath("db.mdb"));
    $rs=new com("adodb.recordset");$sql="select * from [txt]";
    $rs->open($sql,$conn,1,3);
    $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;   
    while(!$rs->eof && $mypagesize>0){ 
    echo $rs->Fields(0)->value."<br/>";
    $rs->movenext; $mypagesize--;
    }

    ?><a href="?page=1">首页</a>
    <a href="?page=<? if($page>1){echo $page-1;}else{echo 1;}?>">上页</a>
    第<? echo $page;?>/<? echo $rs->pagecount;?>页
    <a href="?page=<? if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>">下页</a>
    <a href="?page=<? echo $rs->pagecount;?>">尾页</a><? $rs->Close(); $rs=null; $conn->Close(); $conn=null; ?>