一段经典php mysql分页程序代码
学习既是从基础的学起,也是从经典的例子中学起。以下本站小编整理的一段经典php mysql分页程序代码,欢迎练习! $conn=mysql_connect($mysql_host,$mysql_user,$mysql_password) or die('连接服务器出错');mysql_select_db($mysql_db) or die("选择数据库教程出错");mysql_query("set names 'gbk'");function table($t) { global $mysql_table_prefix; return $mysql_table_prefix.$t; } $sql="select * from "e('keywords')." where 1=1 ";$sql2="select count(*) from "e('keywords')." where 1=1 ";$py=trim($_request['py']);if($act=="search" and !empty($_post['s1'])){$s1=trim($_post['s1']);//获取搜索字 $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];//获取总记录数 $page=trim($_get['page']);//当前页数 $pagesize=30;//每页记录数 $pagecount=ceil($rscount/$pagesize);//获取总页数$pageurl="";if($page<=1) { $page=1; $pageurl.=" 首页 上一页"; }else { $pageurl .=" <a href='?page=1&py=".$py."'>首页</a> <a href='?py=".$py."&page=".($page-1)."'>上一页</a>";} if($page>=$pagecount) { $page=$pagecount; $pageurl .=" 下一页 尾页"; }else { $pageurl .=" <a href='?py=".$py."&page=".($page+1)."'>下一页</a> <a href='?py=".$py."&page=".$pagecount."'>尾页</a>";} $start_rs=($page-1)*$pagesize;//开始 $end_rs=$page*$pagesize;//结束 $sql .=" limit {$start_rs},{$end_rs} "; $res=mysql_query($sql); ?>