扫码关注官方订阅号
为什么老师直接写可以使用,我测试就全部显示了,分页条件直接无视了,打印sql显示没有分页条件
那个代码换一下位置就可以了:
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();}
抱歉,应该是这样的:
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();
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();
这样子可以出来
同问
微信扫码关注PHP中文网服务号
QQ扫码加入技术交流群
扫描下载App
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
PHP学习
技术支持
返回顶部
那个代码换一下位置就可以了:
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();
}
抱歉,应该是这样的:
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();
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();
这样子可以出来
同问