本文章提供一款php分页代码,这是一款比较简单也常的limit进来分页了,同时他还带有条件查询分页功能,代码如下:
$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 " .table( 'keywords' ). " where 1=1 " ; $sql2 = "select count(*) from " .table( 'keywords' ). " where 1=1 " ; $py =trim( $_request [ 'py' ]); if ( $act == "search" and ! empty empty ( $_post [ 's1' ])) { $s1 =trim( $_post [ 's1' ]); //获取搜索字 $sql .= " and (k1='$s1' or k2='$s1') " ; $sql2 .= " and (k1='$s1' or k2='$s1') " ; } elseif (! empty 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>" ; } //开源代码phpfensi.com $start_rs =( $page -1)* $pagesize ; //开始 $end_rs = $page * $pagesize ; //结束 $sql .= " limit {$start_rs},{$end_rs} " ; $res =mysql_query( $sql );
声明：本文来自网络，不代表【好得很程序员自学网】立场，转载请注明出处：http://haodehen.cn/did27969