距开课0天0时0分-10753561秒
年年年年年2019-03-06 11:43:58 0 5 624
[PHP讨论组]源自课程章节:文件上传与列表与分页显示举报回复话题 ↕
为什么老师直接写可以使用,我测试就全部显示了,分页条件直接无视了,打印sql显示没有分页条件
4
0
分享
尾生 2019-03-29 09:17:464楼
那个代码换一下位置就可以了:
public function index(){ //分类信息显示 $cateId=Request::param('cate_id'); //如果存在这个分类 if (isset($cateId)){ $res=ArtCate::get($cateId); $this->view->assign('cateName',$res->name); $artList=Db::name('zh_article') ->where('status',1) ->where('cate_id',$cateId) ->order('create_time','desc')->paginate(3); $this->view->assign('artList',$artList); } else{ $artList=Db::name('zh_article') ->where('status',1) ->order('create_time','desc')->paginate(3); $this->view->assign('cateName','全部文章'); } $this->view->assign('artList',$artList); return $this->fetch();}
赞 +0添加回复
尾生 2019-03-27 22:46:523楼
抱歉,应该是这样的:
if (isset($cateId)){ $artList=Db::table('zh_article') ->where('status',1) ->where('cate_id',$cateId) ->order('create_time','desc')->paginate(3);}$artList=Db::table('zh_article') ->where('status',1) ->where('cate_id',$cateId) ->order('create_time','desc')->paginate(3);$this->view->assign('artList',$artList); return $this->fetch();
尾生 2019-03-27 22:44:212楼
if (isset($cateId)){ $artList=Db::table('zh_article') ->where('status',1) ->where('cate_id',$cateId) ->order('create_time','desc')->paginate(3);}$artList=Db::table('zh_article') ->where('status',1) ->order('create_time','desc')->paginate(3);$this->view->assign('artList',$artList); return $this->fetch();
这样子可以出来
永~不~低~头 2019-03-24 14:22:371楼
同问
尾生 2019-03-29 09:17:464楼
那个代码换一下位置就可以了:
public function index()
{
//分类信息显示
$cateId=Request::param('cate_id');
//如果存在这个分类
if (isset($cateId)){
$res=ArtCate::get($cateId);
$this->view->assign('cateName',$res->name);
$artList=Db::name('zh_article')
->where('status',1)
->where('cate_id',$cateId)
->order('create_time','desc')->paginate(3);
$this->view->assign('artList',$artList);
}
else{
$artList=Db::name('zh_article')
->where('status',1)
->order('create_time','desc')->paginate(3);
$this->view->assign('cateName','全部文章');
}
$this->view->assign('artList',$artList);
return $this->fetch();
}
赞 +0添加回复
尾生 2019-03-27 22:46:523楼
抱歉,应该是这样的:
if (isset($cateId))
{
$artList=Db::table('zh_article')
->where('status',1)
->where('cate_id',$cateId)
->order('create_time','desc')->paginate(3);
}
$artList=Db::table('zh_article')
->where('status',1)
->where('cate_id',$cateId)
->order('create_time','desc')->paginate(3);
$this->view->assign('artList',$artList);
return $this->fetch();
赞 +0添加回复
尾生 2019-03-27 22:44:212楼
if (isset($cateId))
{
$artList=Db::table('zh_article')
->where('status',1)
->where('cate_id',$cateId)
->order('create_time','desc')->paginate(3);
}
$artList=Db::table('zh_article')
->where('status',1)
->order('create_time','desc')->paginate(3);
$this->view->assign('artList',$artList);
return $this->fetch();
这样子可以出来
赞 +0添加回复
永~不~低~头 2019-03-24 14:22:371楼
同问
赞 +0添加回复