当前位置：首页> PHP中常用的分页类总结

PHP中常用的分页类总结

时间：2023-01-19 03:27:27 下载该word文档

PHP中常用的分页类总结
分页是目前在显示大量结果时所采用的最好的方式。有了下面这些代码的帮助，开发人员可以在多个页面中显示大量的数据。在互联网上，分页是一般用于搜索结果或是浏览全部信息php基本分页代码如下
//databaseconnectioninfo$conn=mysql_connect('localhost','dbusername','dbpass'ortrigger_error("SQL",E_USER_ERROR;$db=mysql_select_db('dbname',$connortrigger_error("SQL",E_USER_ERROR;//findouthowmanyrowsareinthetable$sql="SELECTCOUNT(*FROMnumbers";$result=mysql_query($sql,$connortrigger_error("SQL",E_USER_ERROR;$r=mysql_fetch_row($result;$numrows=$r[0];//numberofrowstoshowperpage$rowsperpage=10;//findouttotalpages$totalpages=ceil($numrows/$rowsperpage;//getthecurrentpageorsetadefaultif(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,$connortrigger_error("SQL",E_USER_ERROR;//whiletherearerowstobefetched...while($list=mysql_fetch_assoc($result{//echodataecho$list['id'].":".$list['number']."
";}//endwhile/******buildthepaginationlinks******///rangeofnumlinkstoshow$range=3;

阅读全文