分页 PHP MySQL 数据库 select
php分页后下面html的内容就不显示了。。
代码在下面
// Page分页函数
require_once("inc/dbconninfo.inc");
$page = $_GET["page"];
function Page($rows,$page_size){
global $page,$select_from,$select_limit,$pagenav;
$page_count = ceil($rows/$page_size);
if($page if($page >= $page_count) $page = $page_count;
$select_limit = $page_size;
$select_from = ($page - 1) * $page_size.',';
$pre_page = ($page == 1)? 1 : $page - 1;
$next_page= ($page == $page_count)? $page_count : $page + 1 ;
$pagenav .= "第 $page/$page_count 页 共 $rows 条记录 ";
$pagenav .= "
首页 ";
$pagenav .= "
前一页 ";
$pagenav .= "
后一页 ";
$pagenav .= "
末页 ";
$pagenav.=" 跳到
\n"; for($i=1;$i if($i==$page) $pagenav.="$i \n"; else $pagenav.="$i \n"; } } // Page分页函数 // 使用示例 if (!$conn= mysql_connect("localhost", "admin" ,"")) die('数据库选择失败!'); if (!mysql_select_db("test", $conn)) die('数据库选择失败!'); mysql_query('set names GBK'); // 用Page函数计算出 $select_from 从哪条记录开始检索、$pagenav 输出分页导航 $rows = mysql_num_rows(mysql_query("select * from product")); Page($rows,8); $sql = "select * from product limit $select_from $select_limit"; $rst = mysql_query($sql); while ($row = mysql_fetch_array($rst)){ echo "$row[id] - $row[name] "; } 就是这条, 有了这条,下面就什么都不显示了。。 echo $pagenav;!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! ?>
Statement: The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn