php查询数据库实现分页并返回json

<?php

$mysql_hostname = "localhost";

$mysql_user = "root";

$mysql_password = "root";

$mysql_database = "8090_dede_dedecmsv57utf8sp1";

$prefix = "";

$bd = mysql_connect($mysql_hostname, $mysql_user, $mysql_password) or die("Opps some thing went wrong");

mysql_query("SET NAMES 'UTF8'",$bd);

mysql_select_db($mysql_database, $bd) or die("Opps some thing went wrong");

$page = isset($_REQUEST['page']) ? $_REQUEST['page'] : 1;        //获取当前页码 没有的话 就是第一页

if(!preg_match('/^\d+$/',$page) || $page < 1) $page = 1;        //如果输入的不是数字  或者小于1 默认第一页

$pageSize = 15;        //每页多少条

$query_pag_num = "SELECT COUNT(*) AS count FROM dede_archives";

$result_pag_num = mysql_query($query_pag_num);

$row = mysql_fetch_array($result_pag_num);

$count = $row['count'];        //返回记录总条数

$no_of_paginations = ceil($count / $pageSize);        //计算出总页数

if($page > $no_of_paginations) $page = $no_of_paginations;        //如果请求页码大于总页数 默认最后一页

$start = ($page - 1) * $pageSize;        //sql查询起始位置

$query_pag_data = "SELECT id,title from dede_archives LIMIT $start, $pageSize";

$result_pag_data = mysql_query($query_pag_data) or die('MySql Error' . mysql_error());

$arrList = array();        //初始化列表数组

while($row = mysql_fetch_array($result_pag_data)){

        array_push($arrList, array("id" => $row['id'],"title" => $row['title']));        //将每条信息push到列表数组中

}

$array = array(

        "count" => $count,        //总条数

        "pageSize" => $pageSize,        //每页条数

        "pageCount" => $no_of_paginations,  //总页数

        "thisPage" => $page,//当前页码

        "list" => $arrList        //列表

);

echo json_encode ($array);        //输出json

?>