/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 votes221 views3 answers
Laravel auth 6
PHP Laravel
9 votes205 views3 answers
Laravel where closure
PHP Laravel
6 votes225 views1 answer
Join 2 tables laravel
PHP Laravel
3 votes222 views1 answer
Laravel loop through collection
PHP Laravel
4 votes222 views2 answers
Laravel reduce
PHP Laravel
2 votes211 views2 answers
Laravel include config
PHP Laravel
0 vote209 views1 answer
Markdown mail html rendering laravel
PHP Laravel
0 vote256 views1 answer
Laravel nova field required
PHP Laravel
8 votes224 views1 answer
Laravel show routes artisan
PHP Laravel
0 vote228 views1 answer
Check the existing image in s3 laravel
PHP Laravel