首先一个分页类,如下(摘自网络)可拷贝直接使用
在需要分页的php文件中
- include_once ("Pagination.php");
- $pageSize = 10;
- $pageTotal = $db->get_var("select count(*) from tb");
- $sub_pages = 10;
- if (is_array($_GET) && count($_GET) > 0) {
- if (isset ($_GET["p"])) {
- $pageCurrent = $_GET["p"];
- }
- } else {
- $pageCurrent = 1;
- }
- $goodses = $db->get_results("SELECT g.id,* FROM tb as g INNER JOIN (select id from tb order by updatetime desc limit " . ($pageCurrent -1) * $pageSize . ",10 )as g1 ON g.id=g1.id");
显示分页数据
- <?php $subPages = new Pagination($pageSize, $pageTotal, $pageCurrent, $sub_pages, "index.php?p=", 2);?>
效果图:
PHP 完美分页
原文:http://www.cnblogs.com/xiaohua1/p/7527154.html