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

PHP小丑

这篇文章主要介绍了thinkphp5框架前后端分离项目实现分页功能的方法,结合实例形式分析了thinkPHP5前后端分离项目的分页功能常见实现技巧与操作注意事项,需要的朋友可以参考下
本文实例讲述了thinkphp5框架前后端分离项目实现分页功能的方法。分享给大家供大家参考，具体如下：
方法一
利用tp5提供的paginate方法实现自动分页
参数
page第几页，paginate分页方法会自动获取
size  每页数量
代码

/**
* 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方法

$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