Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save kevsersrca/e6f738956cb585bb685d35485ea86672 to your computer and use it in GitHub Desktop.
Save kevsersrca/e6f738956cb585bb685d35485ea86672 to your computer and use it in GitHub Desktop.
filter
Post::whereHas('tags', function ($query) use ($t) {
$query->where('tag_id','=', $t);
})->whereHas('languages', function ( $query ) use ( $l ){
$query->where('language_id', '=',$l);
})->orWhere(function ($q) use ($search) {
$q->where('title', 'LIKE', '%' . $search . '%')
->orWhere('explanation','LIKE','%'.$search.'%')
->orWhere('usage','LIKE','%'.$search.'%')
->orWhere('codeexample','LIKE','%'.$search.'%')
->orderBy('id','desc');
})->get();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment