下面的代码 上网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; ?>
第一页显示全部信息
每二页少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; ?>
$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; ?>