官方：
1 $User = M('User'); // 实例化User对象
2 // 进行分页数据查询 注意page方法的参数的前面部分是当前的页数使用 $_GET[p]获取
3 $list = $User->where('status=1')->order('create_time')->page($_GET['p'].',25')->select();
4 $this->assign('list',$list);// 赋值数据集
5 $count = $User->where('status=1')->count();// 查询满足要求的总记录数
6 $Page = new \Think\Page($count,25);// 实例化分页类 传入总记录数和每页显示的记录数
7 $show = $Page->show();// 分页显示输出
8 $this->assign('page',$show);// 赋值分页输出
9 $this->display(); // 输出模板改良版：
1 $condition = array();
2
3 $count = M('Member')->where($condition)->count();
4 $page = new \Think\AdminPage($count,$this->num);
5 $page_list = $page->show();
6
7 $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();
8 //提取数据
9 foreach($member_list as $k => &$v){
10 $v['member_avatar'] = getMemberAvatar($v['member_id'],$v['member_edition']);//头像
11 $v['member_sex'] = $v['member_sex'] != 1 ? $v['member_sex'] != 2 ? '不公开' : '女' : '男';
12 $v['add_time'] = date('Y-m-d H:i',$v['add_time']);
13 }
14
15 $this->assign('member_list',$member_list);
16 $this->assign('page_list',$page_list);
17 $this->display();
模糊搜索：
1 $where = array();
2 $search = I('get.search');//搜索关键字
3 if(!empty($search)){
4 $where['pay_name'] = array('like','%'. $search . '%');
5 $this->assign('search',$search);//注意了，这里是相当于缓存，放在type=text上
6 }
7
8 $count = M('Order')->where($where)->count();
9 $page = new \Think\Page($count,$this->num);
10 $show = $page->show();//输出分页
11
12 $data = M('order')->where($where)->limit($page->firstRow . ',' . $page->listRows)->select();
13 $this->assign('show',$show);
14 $this->assign('data',$data);
15 $this->display();
模板：
1 <form action="" method="get">
2 <div class="col-md-11">
3 <div class="input-group">
4 <input type="text" placeholder="请输入用户名称" value="{$search}" name="search" class="input-sm form-control"> <span class="input-group-btn">
5 <button type="submit" class="btn btn-sm btn-primary"> 搜索</button> </span>
6 </div>
7 </div>
8 </form>
注意，一定要用get，post不行！！！
