快速掌握PHP文章分页技巧_PHP教程

<ol class="dp-xml"><li class="alt"><span><span class="tag"><</span><span> ?php  </span></span></li><li><span>// 建立数据库连接  </span></li><li class="alt"><span>$</span><span class="attribute">link</span><span> = </span><span class="attribute-value">mysql_connect</span><span>("localhost", <br />"mysql_user", "mysql_password")   </span></li><li><span>or die("Could not connect: " . mysql_error());   </span></li><li class="alt"><span>// 获取当前页数  </span></li><li><span>if( isset($_GET['page']) ){  </span></li><li class="alt"><span>$</span><span class="attribute">page</span><span> = </span><span class="attribute-value">intval</span><span>( $_GET['page'] );  </span></li><li><span>}  </span></li><li class="alt"><span>else{  </span></li><li><span>$</span><span class="attribute">page</span><span> = </span><span class="attribute-value">1</span><span>;  </span></li><li class="alt"><span>}   </span></li><li><span>// 每页数量  </span></li><li class="alt"><span>$</span><span class="attribute">PageSize</span><span> = </span><span class="attribute-value">10</span><span>;   </span></li><li><span>// 获取总数据量  </span></li><li class="alt"><span>$</span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"select count(*) as amount from table"</span><span>;  </span></li><li><span>$</span><span class="attribute">result</span><span> = </span><span class="attribute-value">mysql_query</span><span>($sql);  </span></li><li class="alt"><span>$</span><span class="attribute">row</span><span> = </span><span class="attribute-value">mysql_fetch_row</span><span>($result);  </span></li><li><span>$</span><span class="attribute">amount</span><span> = $row['amount'];   </span></li><li class="alt"><span>// 记算总共有多少页  </span></li><li><span>if( $amount ){  </span></li><li class="alt"><span>if( $amount </span><span class="tag"><</span><span> $page_size ){ $</span><span class="attribute">page_count</span><span> = </span><span class="attribute-value">1</span><span>; } </span></li><li class="alt"><span>//如果总数据量小于$PageSize，那么只有一页  </span></li><li><span>if( $amount % $page_size ){ </span></li><li><span>//取总数据量除以每页数的余数  </span></li><li class="alt"><span>$</span><span class="attribute">page_count</span><span> = (int)($amount / $page_size) + 1; </span></li><li class="alt"><span>//如果有余数，则页数等于总数据量除以每页数的结<br />果取整再加一  </span></li><li><span>}else{  </span></li><li class="alt"><span>$</span><span class="attribute">page_count</span><span> = $amount / $page_size; </span></li><li class="alt"><span>//如果没有余数，则页数等于总数据量除以每页数的结果  </span></li><li><span>}  </span></li><li class="alt"><span>}  </span></li><li><span>else{  </span></li><li class="alt"><span>$</span><span class="attribute">page_count</span><span> = </span><span class="attribute-value">0</span><span>;  </span></li><li><span>}  </span></li><li class="alt"><span> </span></li><li><span>// 翻页链接  </span></li><li class="alt"><span>$</span><span class="attribute">page_string</span><span> = </span><span class="attribute-value">''</span><span>;  </span></li><li><span>if( $</span><span class="attribute">page</span><span> == 1 ){  </span></li><li class="alt"><span>$page_string </span><span class="attribute">.</span><span>= </span><span class="attribute-value">'第一页|上一页|'</span><span>;  </span></li><li><span>}  </span></li><li class="alt"><span>else{  </span></li><li><span>$page_string </span><span class="attribute">.</span><span>= </span><span class="attribute-value">'<a href=?page=1>第一页</a><br />|<a href=?page='</span><span>.($page-1).'</span><span class="tag">></span><span>上一页</span><span class="tag"></</span><span class="tag-name">a</span><span class="tag">></span><span>|';  </span></li><li class="alt"><span>}   </span></li><li><span>if( ($</span><span class="attribute">page</span><span> == $page_count) || ($</span><span class="attribute">page_count</span><span> == 0) ){  </span></li><li class="alt"><span>$page_string </span><span class="attribute">.</span><span>= </span><span class="attribute-value">'下一页|尾页'</span><span>;  </span></li><li><span>}  </span></li><li class="alt"><span>else{  </span></li><li><span>$page_string </span><span class="attribute">.</span><span>= </span><span class="attribute-value">'<a href=?page='</span><span>.($page+1).'</span><span class="tag">><br /></span><span>下一页</span><span class="tag"></</span><span class="tag-name">a</span><span class="tag">></span><span>|</span><span class="tag"><</span><span class="tag-name">a</span><span> </span><span class="attribute">href</span><span>=?</span><span class="attribute">page</span><span>=</span><span class="attribute-value">'.$page_count.'</span><span class="tag">></span><span>尾页</span><span class="tag"></</span><span class="tag-name">a</span><span class="tag">></span><span>';  </span></li><li class="alt"><span>}  </span></li><li><span>// 获取数据，以二维数组格式返回结果  </span></li><li class="alt"><span>if( $amount ){  </span></li><li><span>$</span><span class="attribute">sql</span><span> = </span><span class="attribute-value">"select * from table order by id desc <br />limit "</span><span>. ($page-1)*$page_size .", $page_size";  </span></li><li class="alt"><span>$</span><span class="attribute">result</span><span> = </span><span class="attribute-value">mysql_query</span><span>($sql);  </span></li><li><span> </span></li><li class="alt"><span>while ( $</span><span class="attribute">row</span><span> = </span><span class="attribute-value">mysql_fetch_row</span><span>($result) ){  </span></li><li><span>$rowset[] = $row;  </span></li><li class="alt"><span>}  </span></li><li><span>}else{  </span></li><li class="alt"><span>$</span><span class="attribute">rowset</span><span> = </span><span class="attribute-value">array</span><span>();  </span></li><li><span>}  </span></li><li class="alt"><span>// 没有包含显示结果的代码，那不在讨论范围，<br />只要用foreach就可以很简单的用得到的二维数组来显示结果  </span></li><li><span class="tag">?></span><span> </span></li></ol>