PHP中常用的分页类总结剖析.docx
- 文档编号:3036692
- 上传时间:2022-11-17
- 格式:DOCX
- 页数:10
- 大小:18.68KB
PHP中常用的分页类总结剖析.docx
《PHP中常用的分页类总结剖析.docx》由会员分享,可在线阅读,更多相关《PHP中常用的分页类总结剖析.docx(10页珍藏版)》请在冰豆网上搜索。
PHP中常用的分页类总结剖析
PHP中常用的分页类总结
分页是目前在显示大量结果时所采用的最好的方式。
有了下面这些代码的帮助,开发人员可以在多个页面中显示大量的数据。
在互联网上,分页是一般用于搜索结果或是浏览全部信息
php基本分页
代码如下
复制代码
php
//databaseconnectioninfo
$conn=mysql_connect('localhost','dbusername','dbpass')ortrigger_error("SQL",E_USER_ERROR);
$db=mysql_select_db('dbname',$conn)ortrigger_error("SQL",E_USER_ERROR);
//findouthowmanyrowsareinthetable
$sql="SELECTCOUNT(*)FROMnumbers";
$result=mysql_query($sql,$conn)ortrigger_error("SQL",E_USER_ERROR);
$r=mysql_fetch_row($result);
$numrows=$r[0];
//numberofrowstoshowperpage
$rowsperpage=10;
//findouttotalpages
$totalpages=ceil($numrows/$rowsperpage);
//getthecurrentpageorsetadefault
if(isset($_GET['currentpage'])&&is_numeric($_GET['currentpage'])){
//castvarasint
$currentpage=(int)$_GET['currentpage'];
}else{
//defaultpagenum
$currentpage=1;
}//endif
//ifcurrentpageisgreaterthantotalpages...
if($currentpage>$totalpages){
//setcurrentpagetolastpage
$currentpage=$totalpages;
}//endif
//ifcurrentpageislessthanfirstpage...
if($currentpage<1){
//setcurrentpagetofirstpage
$currentpage=1;
}//endif
//theoffsetofthelist,basedoncurrentpage
$offset=($currentpage-1)*$rowsperpage;
//gettheinfofromthedb
$sql="SELECTid,numberFROMnumbersLIMIT$offset,$rowsperpage";
$result=mysql_query($sql,$conn)ortrigger_error("SQL",E_USER_ERROR);
//whiletherearerowstobefetched...
while($list=mysql_fetch_assoc($result)){
//echodata
echo$list['id'].":
".$list['number']."
";
}//endwhile
/******buildthepaginationlinks******/
//rangeofnumlinkstoshow
$range=3;
//ifnotonpage1,don'tshowbacklinks
if($currentpage>1){
//show< echo" currentpage=1'><<"; //getpreviouspagenum $prevpage=$currentpage-1; //show echo" currentpage=$prevpage'><"; }//endif //looptoshowlinkstorangeofpagesaroundcurrentpage for($x=($currentpage-$range);$x<(($currentpage+$range)+1);$x++){ //ifit'savalidpagenumber... if(($x>0)&&($x<=$totalpages)){ //ifwe'reoncurrentpage... if($x==$currentpage){ //'highlight'itbutdon'tmakealink echo"[$x]"; //ifnotcurrentpage... }else{ //makeitalink echo" currentpage=$x'>$x"; }//endelse }//endif }//endfor //ifnotonlastpage,showforwardandlastpagelinks if($currentpage! =$totalpages){ //getnextpage $nextpage=$currentpage+1; //echoforwardlinkfornextpage echo" currentpage=$nextpage'>>"; //echoforwardlinkforlastpage echo" currentpage=$totalpages'>>>"; }//endif /******endbuildpaginationlinks******/ ? > 先看一个常用的php分页类 代码如下 复制代码 php /* PlacecodetoconnecttoyourDBhere. */ include('config.php'); //includeyourcodetoconnecttoDB. $tbl_name=""; //yourtablename //Howmanyadjacentpagesshouldbeshownoneachside? $adjacents=3; /* Firstgettotalnumberofrowsindatatable. IfyouhaveaWHEREclauseinyourquery,makesureyoumirrorithere. */ $query="SELECTCOUNT(*)asnumFROM$tbl_name"; $total_pages=mysql_fetch_array(mysql_query($query)); $total_pages=$total_pages[num]; /*Setupvarsforquery.*/ $targetpage="filename.php"; //yourfilename (thenameofthisfile) $limit=2; //howmanyitemstoshowperpage $page=$_GET['page']; if($page) $start=($page-1)*$limit; //firstitemtodisplayonthispage else $start=0; //ifnopagevarisgiven,setstartto0 /*Getdata.*/ $sql="SELECTcolumn_nameFROM$tbl_nameLIMIT$start,$limit"; $result=mysql_query($sql); /*Setuppagevarsfordisplay.*/ if($page==0)$page=1; //ifnopagevarisgiven,defaultto1. $prev=$page-1; //previouspageispage-1 $next=$page+1; //nextpageispage+1 $lastpage=ceil($total_pages/$limit); //lastpageis=totalpages/itemsperpage,roundedup. $lpm1=$lastpage-1; //lastpageminus1 /* Nowweapplyourrulesanddrawthepaginationobject. We'reactuallysavingthecodetoavariableincasewewanttodrawitmorethanonce. */ $pagination=""; if($lastpage>1) { $pagination.=" //previousbutton if($page>1) $pagination.=" page=$prev">�previous"; else $pagination.=" //pages if($lastpage<7+($adjacents*2)) //notenoughpagestobotherbreakingitup { for($counter=1;$count
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- PHP 常用 分页 总结 剖析