thinkphp5.0.24--分页查询
2020-07-04 本文已影响0人
zlchen
LIMIT
//SELECT * FROM newswhere is_delete=0 limit 0,10; $page为页码，$page_num为每页数量，limit(($page-1)*$page_num,$page_num)
Db::table('news')->where(['is_delete' => 0])->limit(0,10)->select();
PAGE
//SELECT * FROM newsWHERE is_delete=0 limit 0,10; page(页码，每页数量)，第二页时，page(2,10)
Db::table('news')->where(['is_delete' => 0])->page(1,10)->select();
