php分頁原理簡單分頁代碼總結

//定每頁顯示多少條 //count(*)查詢總條數 //計算總頁數ceil() //判斷$_GET 並賦值當前頁數 //mysql查詢 limit (當前頁數-1)*每頁條數,每頁條數 //如果總條數不為空白，進行迴圈mysql_fetch_array() //$_SERVER['PHP_SELF'] //上一頁?page=當前頁-1 //下一頁?page=當前頁+1 //edit: bbs.it-home.org include("conn.php"); $perpagenum = 3; $total = mysql_fetch_array(mysql_query("SELECT COUNT(*) FROM message")); $Total = $total[0]; $Totalpage =ceil($Total/$perpagenum); if(!isset($_GET['page'])||!intval($_GET['page'])||$_GET['page']>$Totalpage){ $page = 1; }else{ $page = $_GET['page']; } $start = ($page-1)*$perpagenum; $sql = "SELECT * FROM message ORDER BY id DESC LIMIT $start,$perpagenum"; $result = mysql_query($sql); $contents = mysql_fetch_array($result); ?> if($total){ } do{ $user = $contents['user']; $contact = $contents['contact']; $content = $contents['content']; $date = $contents['date']; ?> //php分頁開始 while($contents=mysql_fetch_array($result)); $per = $page-1; $next= $page+1; echo "共有".$Total."條留言，每頁".$perpagenum."條，共".$page."/".$Totalpage."頁。"; if($page!=1){ echo "首頁". "上一頁"; } if($page!=$Totalpage){ echo "下一頁"; echo "尾頁"; } ?> } ?> 暱稱： 發表於: 複製代碼

