php mysql查詢分頁查詢語句_php+mysql資料庫查詢分頁代碼示例

$SQL_TABL="abc"; //表名

$where_name="id > 10";//查詢條件

$perpagenum = 3; //每頁顯示數量

$total = mysql_fetch_array(mysql_query("select count(*) AS count from $SQL_TABL WHERE ("[email protected]$where_name.")"));

$sql_count=$total['count']; //擷取傳回的資料條數

unset($total); //登出變量 $total

//計算出不準确的頁面數$page_all_num_f為整數，$page_all_num_t為準确值(可能為小數)

$page_all_num_f=round($page_all_num_t=$sql_count/$perpagenum,0);

if($page_all_num_f$page_all_num=$page_all_num_f+1;

else

$page_all_num=$page_all_num_f;

if(is_numeric(@$_GET['p']) && @$_GET['p']>1 && @$_GET['p']<=$page_all_num) //擷取GET參數判斷目前頁面

$page_num=$_GET['p'];

else

$page_num=1;

$sql_s_num=($page_num-1)*$perpagenum; //計算開始的資料條數

$sql_p="LIMIT ".$sql_s_num." , ".$perpagenum; //生成資料庫查詢代碼

$result = mysql_query("select * from $SQL_TABL WHERE ("[email protected]$where_name.") ".$sql_p); //查詢資料

while($row=mysql_fetch_array($result)){ //主循環

//輸出内容

}

//分頁按鈕

for($i=1;$i<=$page_all_num;$i++)

{

if(@$_GET[name]!=null) //頁面的其他GET參數

$p_n="name="[email protected]$_GET[name]."&";

else

$p_n=null;

if($page_num==$i) //目前頁面數字的強調

$p_flag="class=\"flag\" ";

else

$p_flag=null;

echo "$i\n";

}

?>