thinkphp--分页

官方：

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不行！！！

转载于:https://www.cnblogs.com/laijinquan/p/7418701.html