AjaxPage实现分页

<?php $nowPage = isset($_POST['page']) ? $_POST['page'] : 1; $link = @mysql_connect('localhost','root','123456'); mysql_select_db('ajaxpage',$link); mysql_query('set names utf8'); $sql = 'select count(*) as sum from food'; $res = mysql_query($sql); //数据库中的总的数据数 $total_num = mysql_fetch_assoc($res)['sum']; //定义一页显示的个数 $page_num = 4; //计算偏移量 $offset = ($nowPage - 1) * $page_num; //计算总的页数 $pageSum = ceil($total_num/$page_num); $sql = "select * from food limit $offset,$page_num"; $res = mysql_query($sql); $arr = array(); while ($row = mysql_fetch_assoc($res)) { $arr[] = $row; } if($arr){ $result['total_num'] = $total_num; $result['pageSum'] = $pageSum; $result['result'] = $arr; $result['status'] = 1; }else{ $result['status'] = 0; } // var_dump($result); echo json_encode($result);