php簡單分頁原理與分頁程式碼範例

/*******分页原理*********/
//每页显示记录条数
$page_size = 3;
$sql = "select * from message";
$result = mysql_query($sql);
//总记录条数
$num = mysql_num_rows($result);
//总页面数量的计算
if($num<=$page_size) { $page_count =1; }
if($num%$page_size) { $page_count = intval($num/$page_size) 1 ;}
if($num%$page_size==0)  { $page_count = $num/$page_size ;}

if( isset($_GET['page']) ){
    $page = intval($_GET['page']);
}
else{
    $page = 1;
}

$sql_page= "select * from message limit ".($page-1)*$page_size.",$page_size";
$do = mysql_query($sql_page);
while( $re = mysql_fetch_object($do)){
      echo '随便写点什么都行';
}

if($page<>1){
    echo '首页';
    echo '上一页';
}

if($page<>$page_count){
    echo '';
    echo '下一页';
    echo '最后一夜';
    echo '

复制代码