<?php/** * Created by PhpStorm. * User: oiio * Date: 2015/11/4 * Time: 15:10 */require "tools/Tool.class.php";$mysqli = Tool::getlink();//0、取得要显示第几页if($_GET==null){ $nowPage=1; //第一次请求没有传参数，默认 为第一页 根据传的值为null 来进行判断}else{ $nowPage =$_GET['nowPage'];}//1、查询总的房源数$totalRecord = 0;//总的房源数$sql = "SELECT COUNT(*) FROM `district`";$a = $mysqli->query($sql);if ($row = $a->fetch_row()) { $totalRecord = $row[0];}//2、计算总页数$pageSize =2;$totalPages=ceil($totalRecord/$pageSize);//$totalPages 表示总页数 ；ceil（）函数向上取整 凡是有小数部分，都会进1 5.2 =6//3、查询第4、5条 LIMIT 3,2 表示从第3行开始取 取2行$begin=($nowPage-1)* $pageSize;$sql2 = "SELECT * FROM `district` LIMIT $begin ,$pageSize";$a2 = $mysqli->query($sql2);echo "<table>";while ($row2 = $a2->fetch_row()) { echo "<tr> <td>$row2[0]</td> <td>$row2[1]</td></tr>";}echo "</table>";//4、在页面上输出页码for($i=1;$i<= $totalPages;$i++){ echo "<a href='district.php?nowPage=$i'>$i</a>"." ";}$a->free();$a2->free();$mysqli->close();
转载于:https://www.cnblogs.com/cocotian/p/5056473.html
