关于搜索功能的实现原理（laravel框架）

这里的搜索功能主要基于表单get提交实现的

选择分类:	全部 @foreach($category as $c) {{$c->class_name}} @endforeach	文章标题:

php部分逻辑

public function article_list(){
//echo ‘zoule’;exit; 测试表单是否走进方法中 大家随意写
$shownum=1;if(arra{y}_{k}e{y}_{e}xists{(}^{\prime }clas{s}^{\prime },$_GET)||array_key_exists(‘keywords’,KaTeX parse error: Expected '}', got 'EOF' at end of input: …1'; if(_GET[‘class’]){
//Article模型 leftJoin表连接 查询根据俩个表里的这些字段来执行
$postdata=Article::leftJoin{(}^{\prime }categor{y}^{\prime },function($join) {
KaTeX parse error: Expected 'EOF', got '}' at position 60: …id'); }̲)->select(['art…_GET[‘class’])->orderBy(‘release_time’,‘desc’)->paginate(KaTeX parse error: Expected 'EOF', got '}' at position 17: …hownum); }̲elseif(_GET[‘keywords’]){
$postdata=Article::leftJoin{(}^{\prime }categor{y}^{\prime },function($join) {
KaTeX parse error: Expected 'EOF', got '}' at position 60: …id'); }̲)->select(['art…_GET[‘keywords’])->orderBy(‘release_time’,‘desc’)->paginate($shownum);

  }else{
     $postdata = Article::leftJoin('category', function($join) {
        $join->on('article.class_id', '=', 'category.id');
     })->select(['article.id','category.class_name','article.status','article.title_editing','article.update_time'])->orderBy('release_time','desc')->paginate($shownum);
  }

}else{
//echo ‘2222’;
$postdata=Article::leftJoin{(}^{\prime }categor{y}^{\prime },function($join) {
KaTeX parse error: Expected 'EOF', got '}' at position 57: …ry.id'); }̲)->select(['art…shownum);
}
//分类id不是父id
$category=DB::table{(}^{\prime }categor{y}^{\prime })->where{(}^{\prime }paren{t}_i{d}^{\prime }{,}^{\prime }!{=}^{\prime }{,}^{\prime }{0}^{\prime })->get();//渲染页面传递参数returnview{(}^{\prime }backend.articl{e}_{l}is{t}^{\prime },{[}^{\prime }postdat{a}^{\prime }=>$postdata,‘shownum’=>$shownum{,}^{\prime }categor{y}^{\prime }=>$category]);
}
http://mam.yisuping.com