3.分页查询
<p><strong>1.通过limit函数实现分页查询</strong></p>
<pre><code class="language-php">$page = input("page",1);//传入参数,第几页
$page_size = input("page_size",10);//传入参数,一页多少条数据
$start = ($page-1)*$page_size;//计算每一页开始的编号
$where['wx_gender'] = 1;
Db::name('member')->where($where)->limit($start,$page_size)->select();</code></pre>
<p>以上运行结果相当于以下语句</p>
<pre><code>select * from cmf_member where wx_gender=1 limit 0,10</code></pre>