ThinkPHP5.0分页查询测试

sql 复习:

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

测试代码

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();
    }
}

分页测试

/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 )