where(array("pid"=>$pid))->count();// 查询满足要求的总记录数 $Page = new \Think\Page($count,9);// 实例化分页类 传入总记录数和每页显示的记录数(25) $show = $Page->show();// 分页显示输出 $list = M('retail_news') ->where(array("pid"=>$pid)) ->order("id desc") ->limit($Page->firstRow.','.$Page->listRows) ->select(); $this->assign('list',$list);// 赋值数据集 $this->assign('page',$show);// 赋值分页输出 $newest = M('retail_news')->where(array("pid"=>$pid))->order("id desc")->limit('5')->select(); $newtime = time(); $this->assign('newtime',$newtime); $this->assign('newset',$newest); $data['pid'] = $pid; $data['status'] = '1'; $data['type'] = '3'; $banner = M('retail_tempbanner')->where($data)->find(); $this->assign('banner',$banner); $logo = session('main_user'); $this->assign('webinfo',$logo); $this->display($name['templatename']."/news"); } } //新闻详情 public function newsdetails(){ $name = self::$TEMPLATE; if($name['templatename']) { $id = I('get.id'); $list = M('retail_news')->where("id=".$id)->find(); $w['pid'] = session('main_user')['id']; $w['status'] = 1; $w['id'] = array('gt',$id); //上一条 $gt = M('retail_news')->where($w)->find(); $w['id'] = array('lt',$id); //下一条 $lt = M('retail_news')->where($w)->order('id desc')->find(); $this->assign('gt',$gt); $this->assign('lt',$lt); $list['content'] = htmlspecialchars_decode($list['content']); $list['time'] = date('Y-m-d',$list['time']); $this->assign("list",$list); $logo = session('main_user'); $this->assign('webinfo', $logo); $this->display($name['templatename'] . "/newsdetails"); } } }