http://blog.csdn.net/gxdvip/article/details/45671567
//1. 定义一些分页变量
$page=isset($_GET[“page”])?$_GET[‘page’]:1; //当前页号
$pageSize=15; //页大小
$maxRows; //最大数据条
$maxPages; //最大页数
//2. 获取最大数据条数
@$sql = "select count(*) from placedb {$where}";
//$sql = "select * from jmfulian order by addtime desc";;
$res = mysqli_query($link,$sql);
// 错略的使用mysqli替换
/* if (!function_exists('mysql_result')) {
function mysql_result($result, $number, $field=0) {
mysqli_data_seek($result, $number);
$row = mysqli_fetch_array($result);
return $row[$field];
}*/
function mysql_result($res, $number, $field=0) {
mysqli_data_seek($res, $number);
$row = mysqli_fetch_array($res);
return $row[$field];
}
//$maxRows = mysql_result($res,0,0); //定位从结果集中获取总数据条数这个值。
//$maxRows = mysqli_query($link, "SELECT COUNT(*) FROM placedb");
$maxRows = mysql_result($res, 0);
echo $maxRows;
//3. 计算出共计最大页数
$maxPages = ceil($maxRows/$pageSize); //采用进一求整法算出最大页数