public function getList($pid = 0, $pageSize = 10) { if ($pid) { $where['pid'] = $pid; } $where['tid'] = 1; $count = $this->where($where)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, $pageSize); $show = $Page->show(); // 分页显示输出 $showPage = $Page->showPage(); // 分页显示输出 $list = $this->where($where)->order('time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); foreach ($list as $k => &$v) { //处理留言数据 //父级留言 if ($v['nid']) { $v['nodeList'] = $this->where('id=' . $v['nid'])->field('name,address,comment')->find(); } } $rs['showPage'] = $showPage; $rs['count'] = $count; $rs['list'] = $list; $rs['page'] = $show; return $rs; }
public function getList($where, $page_size = 10) { $count = $this->where($where)->order('time desc')->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, $page_size); $show = $Page->show(); // 分页显示输出 $showPage = $Page->showPage(); // 分页显示输出 $list = $this->where($where)->field('ey_moods.*,ey_users.img,ey_users.user as name')->limit($Page->firstRow . ',' . $Page->listRows)->join('ey_users ON ey_moods.uid=ey_users.id')->order('time desc')->select(); $rs['count'] = $count; $rs['showPage'] = $showPage; $rs['list'] = $list; $rs['page'] = $show; return $rs; }
public function getList($where = null, $pageSize = 10) { $count = $this->where($where)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, $pageSize); $show = $Page->show(); // 分页显示输出 $showPage = $Page->showPage(); // 分页显示输出 $list = $this->where($where)->order('time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $rs['showPage'] = $showPage; $rs['count'] = $count; $rs['list'] = $list; $rs['page'] = $show; return $rs; }
public function getList($where = null, $page_size = 5) { //传入条件,显示条数 $count = $this->where($where)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, $page_size); $show = $Page->show(); // 分页显示输出 $showPage = $Page->showPage(); // 分页显示输出 $list = $this->where($where)->join("ey_categorys ON ey_contents.cid=ey_categorys.id")->join('ey_tags ON ey_contents.tid=ey_tags.id')->join('ey_users ON ey_contents.uid=ey_users.id')->field('ey_contents.*,ey_categorys.name as cate,ey_tags.name as tag,ey_users.user as name')->order('time desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $rs['list'] = $list; //集合 $rs['page'] = $show; //分页 $rs['showPage'] = $showPage; //分页 $rs['count'] = $count; //总数 return $rs; }