thinkphp5框架前后端分离项目实现分页功能的方法分析
发布:smiling 来源: PHP粉丝网 添加日期:2021-12-27 15:17:30 浏览: 评论:0
这篇文章主要介绍了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"
- }
Tags: thinkphp5前后端分离 thinkphp5分页
相关文章
- ·thinkphp5+layui实现的分页样式示例(2021-12-27)
推荐文章
热门文章
最新评论文章
- 写给考虑创业的年轻程序员(10)
- PHP新手上路(一)(7)
- 惹恼程序员的十件事(5)
- PHP邮件发送例子,已测试成功(5)
- 致初学者:PHP比ASP优秀的七个理由(4)
- PHP会被淘汰吗?(4)
- PHP新手上路(四)(4)
- 如何去学习PHP?(2)
- 简单入门级php分页代码(2)
- php中邮箱email 电话等格式的验证(2)