laravel中或者OR的用法

举例说明:

$articles = DB::table('articles')->join('category','articles.cateid','=','category.id')
->where('cateid',$_POST['articlecolumn'])
->orWhere('parentid',$_POST['articlecolumn'])  //重点,与上一句where构成或者(OR)关系!
->where('title','like','%'.$_POST['searchname'].'%')
->whereBetween('articles.updated_at', [$_POST['logmin'], $_POST['logmax']])
->select('articles.*','category.name')
->get()->toArray();

posted @ 2017-07-07 09:51  mayer326  阅读(3501)  评论(0)    收藏  举报