php 实现网页得分业显示
php 分页
if( isset($_GET['page']) ){ $page = intval( $_GET['page'] );}else{ $page = 1;} // 每页数量$PageSize = 10; // 获取总数据量$sql = "select count(*) as amount from news";$result = mysql_query($sql);$row = mysql_fetch_row($result);$amount = $row['amount']; // 记算总共有多少页if( $amount ){ if( $amount < $page_size ){ $page_count = 1; } //如果总数据量小于$PageSize,那么只有一页 if( $amount % $page_size ){ //取总数据量除以每页数的余数 $page_count = (int)($amount / $page_size) + 1; //如果有余数,则页数等于总数据量除以每页数的结果取整再加一 }else{ $page_count = $amount / $page_size; //如果没有余数,则页数等于总数据量除以每页数的结果 }}else{ $page_count = 0;}
// 翻页链接$page_string = '';if( $page == 1 ){ $page_string .= '第一页|上一页|';}else{ $page_string .= '<a href=?page=1>第一页</a>|<a href=?page='.($page-1).'>上一页</a>|';} if( ($page == $page_count) || ($page_count == 0) ){ $page_string .= '下一页|尾页';}else{ $page_string .= '<a href=?page='.($page+1).'>下一页</a>|<a href=?page='.$page_count.'>尾页</a>';}// 获取数据,以二维数组格式返回结果if( $amount ){ $sql = "select * from table order by id desc limit ". ($page-1)*$page_size .", $page_size"; $result = mysql_query($sql); while ( $row = mysql_fetch_row($result) ){ $rowset[] = $row; }}else{ $rowset = array();}