| 代碼如下 |
複製代碼 |
function getpage ($talbe,$choose,$url){ global $page,$db,$sortname; $query=$db->query("select * from $talbe $choose"); $total=$db->num_rows($query); $totalpage=ceil($total/25); $nextpage=$page+1; $uppage=$page-1; if($nextpage>$totalpage)$nextpage=$totalpage; if($uppage<1)$uppage=1; $showpage="共有<b><font color='#FF0000'>$total</font></b>條記錄,共<b><font color='#FF0000'>$totalpage</font></b>頁,當前為第<b><font color='#FF0000'>$page</font></b>頁 <b><font color='#FF0000'>◇</font></b><a href='?$url&page=$uppage&sortname=$sortname'>上一頁</a><b><font color='#FF0000'>◇</font></b><a href='?$url&page=$nextpage&sortname=$sortname'>下一頁</a><font color='#FF0000'><b>◇"; return $showpage; } function reto($msg,$url=''){ global $comeurl; if(!$url)$url=$comeurl; return "<table width='100%' cellspacing='1' cellpadding='3' bgcolor='#CCCCCC'> <tr bgcolor='#FFFFFF'> <td> <div align='center'><font size='+6'><b><font size='5'><a href='$url'><font color='#993300'>$msg</font></a></font></b></font></div> </td> </tr> </table>"; } |
通過上頁的代碼我們可以看出php分頁原創很簡單,只要get[page]頁面,當前頁,然後再用$page*$pagesize以開始,後以$pagesize為結束就OK了。mysql語句為 $sql ="Select * from t limit $page*$pagesize,$pagesize";
本站原創教程,轉載註明來源www.111cn.net