一段經(jīng)典php mysql分頁(yè)程序代碼
學(xué)習(xí)既是從基礎(chǔ)的學(xué)起，也是從經(jīng)典的例子中學(xué)起。以下百分網(wǎng)小編整理的一段經(jīng)典php mysql分頁(yè)程序代碼，歡迎練習(xí)！
$conn=mysql_connect($mysql_host,$mysql_user,$mysql_password) or die('連接服務(wù)器出錯(cuò)');mysql_select_db($mysql_db) or die("選擇數(shù)據(jù)庫(kù)教程出錯(cuò)");mysql_query("set names 'gbk'");function table($t)
{
global $mysql_table_prefix;
return $mysql_table_prefix.$t;
}
$sql="select * from ".table('keywords')." where 1=1 ";$sql2="select count(*) from ".table('keywords')." where 1=1 ";$py=trim($_request['py']);if($act=="search" and !empty($_post['s1'])){$s1=trim($_post['s1']);/pic/div>
$sql .=" and (k1='$s1' or k2='$s1') ";
$sql2 .=" and (k1='$s1' or k2='$s1') ";
}
elseif(!empty($py))
{
$sql .=" and pinyin='$py' ";
$sql2.=" and pinyin='$py' ";
}
$sql .=" order by pinyin ";
$rscount=mysql_query($sql2);
$rscount=@mysql_fetch_array($rscount);
$rscount=$rscount[0];/pic/div>
$page=trim($_get['page']);/pic/div>
$pagesize=30;/pic/div>
$pagecount=ceil($rscount/$pagesize);/pic/div>
{
$page=1;
$pageurl.=" 首頁(yè) 上一頁(yè)";
}else
{
$pageurl .=" <a href='?page=1&py=".$py."'>首頁(yè)</a> <a href='?py=".$py."&page=".($page-1)."'>上一頁(yè)</a>";}
if($page>=$pagecount)
{
$page=$pagecount;
$pageurl .=" 下一頁(yè) 尾頁(yè)";
}else
{
$pageurl .=" <a href='?py=".$py."&page=".($page+1)."'>下一頁(yè)</a> <a href='?py=".$py."&page=".$pagecount."'>尾頁(yè)</a>";}
$start_rs=($page-1)*$pagesize;/pic/div>
$end_rs=$page*$pagesize;/pic/div>
$sql .=" limit {$start_rs},{$end_rs} ";
$res=mysql_query($sql);
?>
【一段經(jīng)典php mysql分頁(yè)程序代碼】相關(guān)文章：
php分頁(yè)類代碼08-05
PHP 和 MYSQL11-26
PHP簡(jiǎn)單的分頁(yè)過(guò)程與原理11-21
學(xué)習(xí)php分頁(yè)代碼實(shí)例12-06
PHP常用MySql操作10-11
php查詢mysql的實(shí)例07-27
php操作mysql步驟10-13
PHP與MYSql連接與查詢11-30
- 相關(guān)推薦