/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

0 vote363 views1 answer
Laravel count data wise
PHP Laravel
1 vote370 views1 answer
How to store an image in laravel directly from url
PHP Laravel
2 votes320 views1 answer
Laravel delete route
PHP Laravel
0 vote303 views1 answer
Laravel migrate patth
PHP Laravel
0 vote379 views1 answer
Laravel return view in web.php
PHP Laravel
1 vote368 views1 answer
Laravel read file from tmp
PHP Laravel
1 vote371 views1 answer
Laravel validation required_if one parameter exist
PHP Laravel
1 vote386 views1 answer
Clear bootstrap cache laravel
PHP Laravel
0 vote404 views1 answer
Redirect to intent url after login laravel
PHP Laravel
1 vote351 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel