- <?php
- require_once("db.inc.php");
- error_reporting(0);
- $db = new DB();
- # get total records count;
- $rs = $db->q("select count(*) from users");
- $count = $rs[0][0];
- # set how many records display on each page
- $pagesize = 10;
- # get page count
- $pagecount = ceil($count / $pagesize);
- # get current page number and query from DB according to current page
- $page = isset($_GET['page']) ? intval($_GET['page']) : 1 ;
- $offset = ($page - 1) * $pagesize;
- $query = "select * from users limit $offset, $pagesize";
- $res = $db->q($query);
- $rows = $res;
- ?>
基本思路是用sql中的limit定量输出,查询完了之后,用foreach打印出来即可。
转载于:https://blog.51cto.com/orzee/633834