PHP实现MySQL分页查询功能优化与实践

调用例子&＃xff1a;

$fenzhan_prize_order_db &＃61; pc_base::load_model(&＃39;fenzhan_prize_order_model&＃39;);

$page &＃61; max(intval($_REQUEST[&＃39;page&＃39;]), 1);
      $pagesize &＃61; isset($_REQUEST[&＃39;pagesize&＃39;]) ? $_REQUEST[&＃39;pagesize&＃39;] : 10;
      $mydb &＃61;pc_base::load_model(&＃39;mymodel&＃39;);
      $sql &＃61; "SELECT* FROM {$fenzhan_prize_order_db->get_tablename()} wherebiaoshi&＃61;&＃39;" .$this->fenzhan[biaoshi]."&＃39;order by inputtime desc";
      $mpages &＃61; $mydb->query_listinfo($sql,$page,$pagesize);

$mpages &＃61;$mydb->query_listinfo($sql,$page,$pagesize);

$msg &＃61;array();
$msg[&＃39;returncode&＃39;]&＃61; "0";
$msg[&＃39;msg&＃39;]&＃61; "文章";
$msg[&＃39;comment&＃39;]&＃61; $mpages;
echo JSON($msg);

分页方法&＃xff1a;

public function query_listinfo(&$sql &＃61; &＃39;&＃39;, $page &＃61; 1, $pagesize&＃61; 20, $setpages &＃61; 10,$array &＃61; array()) {
    //取得记录总数$rs&＃xff0c;计算总页数用
    $array&＃61;$this->query_by_sql("SELECT count(1) as total FROM ( $sql) as a");
    $total&＃61;$array[0][&＃39;total&＃39;];
    //计算总页数
    $pages&＃61;intval(intval($total)/$pagesize);
    if ($total%$pagesize) {
        $pages&＃43;&＃43;;
    }
    //设置页数
    if (isset($page)){
        $page&＃61;intval($page);
    }
    else{
        //设置为第一页
        $page&＃61;1;
    }
    //计算记录偏移量
    $offset&＃61;$pagesize*($page - 1);
    //读取指定记录数
    $infos&＃61; $this->query_by_sql("$sql limit $offset,$pagesize");
    $mpages &＃61;new mpages();
    $mpages->page&＃61;$page;
    $mpages->total&＃61;$total;
    $mpages->pagesize&＃61;15;
    $mpages->data&＃61;$infos;
    return $mpages;
}