thinkphp--分页

官方：

$User = M('User'); // 实例化User对象
// 进行分页数据查询 注意page方法的参数的前面部分是当前的页数使用 $_GET[p]获取
$list = $User->where('status=1')->order('create_time')->page($_GET['p'].',25')->select();
$this->assign('list',$list);// 赋值数据集
$count      = $User->where('status=1')->count();// 查询满足要求的总记录数
$Page       = new \Think\Page($count,25);// 实例化分页类 传入总记录数和每页显示的记录数
$show       = $Page->show();// 分页显示输出
$this->assign('page',$show);// 赋值分页输出
$this->display(); // 输出模板

 改良版：

        $condition = array();
        
        $count = M('Member')->where($condition)->count();
        $page = new \Think\AdminPage($count,$this->num);
        $page_list = $page->show();
        
        $member_list = M('Member')->field('member_id,member_name,member_sex,add_time,member_edition')->where($condition)->limit($page->firstRow . ',' . $page->listRows)->order('add_time desc')->select();
        //提取数据
        foreach($member_list as $k => &$v){
            $v['member_avatar'] = getMemberAvatar($v['member_id'],$v['member_edition']);//头像
            $v['member_sex'] = $v['member_sex'] != 1 ? $v['member_sex'] != 2 ? '不公开' : '女' : '男';
            $v['add_time'] = date('Y-m-d H:i',$v['add_time']);
        }
        
        $this->assign('member_list',$member_list);
        $this->assign('page_list',$page_list);
        $this->display();

模糊搜索：

        $where = array();
        $search = I('get.search');//搜索关键字
        if(!empty($search)){
            $where['pay_name'] = array('like','%'. $search . '%');
            $this->assign('search',$search);//注意了，这里是相当于缓存，放在type=text上
        }
        
        $count = M('Order')->where($where)->count();
        $page = new \Think\Page($count,$this->num);
        $show = $page->show();//输出分页
        
        $data = M('order')->where($where)->limit($page->firstRow . ',' . $page->listRows)->select();
        $this->assign('show',$show);
        $this->assign('data',$data);
        $this->display();

 模板：

                                <form action="" method="get">
                                    <div class="col-md-11">
                                        <div class="input-group">
                                                <input type="text" placeholder="请输入用户名称" value="{$search}" name="search" class="input-sm form-control"> <span class="input-group-btn">
                                                <button type="submit" class="btn btn-sm btn-primary"> 搜索</button> </span>
                                        </div>
                                    </div>
                                </form>

注意，一定要用get，post不行！！！