PHP paging principle simple paging code summary

//Determine how many items are displayed on each page
//count(*) Query the total number of items
//Calculate the total number of pages ceil()
//Judge $_GET and assign the current page number
//mysql query limit (current page number-1)*number of items per page, number of items per page
//If the total number of items is not empty, loop mysql_fetch_array()
//$_SERVER['PHP_SELF']
 //Previous page?page=Current page-1
//Next page?page=Current 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'];?>< ;td width="193" height="22">Nickname: }//php paging startswhile($contents=mysql_fetch_array($result));$per = $page-1;$next= $page+1;echo "Total".$ Total." comments, ".$perpagenum." messages per page, total ".$page."/".$Totalpage." pages. ";if($page!=1){ echo "Homepage"."Previous page";}if($page!=$Totalpage){ echo "Next page";echo "Last page";}?>}?>










Posted in: