PHP simple paging code to learn PHP paging principles

include("conn.php"); //Database link, solve it yourself

$sql="select * from news";
$query=mysql_query($ sql);
$all_num=mysql_num_rows($query); //Total number of items
$page_num=3; //Number of items per page
$page_all_num = ceil($all_num/$page_num); //Total number of pages
$ page=empty($_GET['page'])?1:$_GET['page']; //Current page number
$page=(int)$page; //Safe forced conversion
$limit_st = ($page -1)*$page_num; //Start number
//===php paging code key
$sql="select * from news limit $limit_st, $page_num";
$ query=mysql_query($sql);
 while($row=mysql_fetch_array($query)){
 echo $row['title']." Browse";
}

$px = $page>=$page_all_num ? $page_all_num : $page+1 ;
$ps = $page<=1 ? 1 : $page-1 ;
?>
Homepage |
Previous page |
Next page |
Last page