thinkphp5框架前后端分离项目实现分页功能的方法分析

本文实例讲述了thinkphp5框架前后端分离项目实现分页功能的方法。分享给大家供大家参考，具体如下：

方法一

利用tp5提供的paginate方法实现自动分页

参数

page第几页，paginate分页方法会自动获取

size  每页数量

代码

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

/** * Notes:消费记录 * Date: 2019/6/25 * Time: 15:43 * @param Request $request * @return \think\response\Json */ public function getMyConsumeLog(Request $request ) {      global $_W ;      $size = $request ->param( 'size' , 6);      $list = $this ->model->getListByMid( $_W [ 'user' ][ 'id' ], $size );      return json([ 'data' => $list , 'error' => 0, 'message' => 'success' ]); } public function getListByMid( $mid , $size = 10){      $res = $this        ->alias( 'c' )        ->field( 'c.*,b.book_name,b.book_flash,s.section_title' )        ->leftJoin( 'booksection s' , 'c.chapter_id = s.id' )        ->leftJoin( 'book b' , 's.book_id = b.id' )        ->where( 'c.mid' , $mid )        ->order( 'c.id desc' )        ->paginate( $size );      return $res ; }

返回数据

{
    "data": {
        "total": 1,
        "per_page": 1,
        "current_page": 1,
        "last_page": 1,
        "data": [
            {
                "id": 105,
                "mid": 55,
                "book_id": 31,
                "chapter_id": 46046,
                "score": 27,
                "create_time": 1561447448,
                "book_name": "桃运村支书",
                "book_flash": "https://cdnxiaoshuo.t.com/FiO6TM0N4kpzKB7tqrDko64ZS4H4",
                "section_title": "第29章 康庄大道"
            }
        ]
    },
    "error": 0,
    "message": "success"
}

方法二

利用limit方法

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

$curr_page = $request ->param( 'page' , 1);      $size = $request ->param( 'size' , 6); $list = $consume_model ->getListByWhere( $curr_page , $size , $where );      $num = $consume_model ->getListByWhereCount( $where );      return json([ 'data' => $list , 'num' => $num , 'error' => 0, 'message' => 'success' ]); public function getListByWhere( $curr_page , $limit = 10, $where = null){      $res = $this        ->alias( 'c' )        ->field( 'c.*,b.book_name,s.section_title' )        ->leftJoin( 'booksection s' , 'c.chapter_id = s.id' )        ->leftJoin( 'book b' , 's.book_id = b.id' )        ->where( $where )        ->order( 'c.id desc' )        ->limit( $limit *( $curr_page - 1), $limit )        ->select()        ->toArray();      return $res ; } public function getListByWhereCount( $where = null){      $count = $this        ->alias( 'c' )        ->where( $where )        -> count ();      return $count ; }

返回值

{
    "data": [
        {
            "id": 2,
            "mid": 4,
            "book_id": 4,
            "chapter_id": 22,
            "score": 30,
            "create_time": 0,
            "book_name": "复仇者联盟I",
            "section_title": "第11章  你是睡"
        },
        {
            "id": 1,
            "mid": 4,
            "book_id": 29,
            "chapter_id": 34,
            "score": 20,
            "create_time": 1598999,
            "book_name": "复仇者联盟II",
            "section_title": "第11章  你是睡"
        }
    ],
    "num": 2,
    "total_coin": 50,
    "error": 0,
    "message": "success"
}

希望本文所述对大家基于ThinkPHP框架的PHP程序设计有所帮助。

原文链接：https://blog.csdn.net/flysnownet/article/details/93624845