/PHP/Laravel/Laravel eager loading where clause

Laravel eager loading where clause

$query = ""    

if ($request->has('country'){
$query = Post::with("country")->whereHas("country",function($q) use($request){
    $q->where("name","=",$request->country);
})->get()
}else{
    $query = Post::with("country")->get();
}

Source: stackoverflow.com

Similar codes

11 votes321 views2 answers
Select distinct laravel
PHP Laravel
1 vote302 views1 answer
Start server in laravel
PHP Laravel
0 vote336 views2 answers
Show query in laravel
PHP Laravel
3 votes291 views2 answers
Custom 404 page in laravel
PHP Laravel
7 votes317 views1 answer
Laravel eloquent date range
PHP Laravel
6 votes276 views1 answer
Laravel Route::group definition
PHP Laravel
2 votes293 views1 answer
Laravel middleware
PHP Laravel
0 vote332 views1 answer
Laravel use npm package
PHP Laravel
0 vote337 views1 answer
Filter from taggable laravel
PHP Laravel
2 votes314 views1 answer
When image update laravel delete remove image
PHP Laravel