laravel 的 分页以及条件搜索后分页
//后台的数据查询
public function index(Request $request)
{
$tid = empty($request->input("tid"))?0:$request->input("tid");
$content = empty($request->input("content"))?"":$request->input("content");
if($tid==0)
{
$where=">";
}
else
{
$where ="=";
}
$news = DB::table("content")
->join("title", "title.tid", "=", "content.tid")
->where("content.tid",$where,$tid)
->where("content","like","%$content%")
->paginate(5);
//新闻的分类
$title = DB::table("title")->get();
$news->tid=$tid;
$news->content=$content;
//新闻内容
return view("news",["title"=>$title,"news"=>$news]);
}
//前台分页数据渲染
{!! $news->appends(array("tid"=>$news->tid,"content"=>$news->content))->render() !!}声明:该文观点仅代表作者本人,入门客AI创业平台信息发布平台仅提供信息存储空间服务,如有疑问请联系rumenke@qq.com。
- 上一篇: Yii框架下的where条件查询
- 下一篇: Yii 框架 ajax的使用
