ThinkPHP5.0分页查询测试

sql 复习:

SELECT * FROM table LIMIT count;
SELECT * FROM table LIMIT offset, count;

  

 

  
1
  
2
 

测试代码

namespace app\api\controller;

use app\common\model\NewsModel;


class NewsApi
{ public function page(){ $page = input("page", 1); $size = input("size", 20); echo NewsModel::limit($size)->page($page)->buildSql(); }
}


  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
  
12
  
13
  
14
  
15
 

分页测试

/api/page?size=10&page=1
( SELECT * FROM `news` LIMIT 0,10 )

api/newsapi/page?size=10&page=2
( SELECT * FROM `news` LIMIT 10,10 )

api/newsapi/page?size=10&page=3
( SELECT * FROM `news` LIMIT 20,10 )

/api/newsapi/page?size=10&page=10
( SELECT * FROM `news` LIMIT 90,10 )

  

 

  
1
  
2
  
3
  
4
  
5
  
6
  
7
  
8
  
9
  
10
  
11
 

文章来源: pengshiyu.blog.csdn.net，作者：彭世瑜，版权归原作者所有，如需转载，请联系作者。

原文链接：pengshiyu.blog.csdn.net/article/details/102906973