/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 vote304 views1 answer
Db connection postgres laravel
PHP Laravel
0 vote299 views1 answer
Laravel 8 created at format
PHP Laravel
0 vote222 views1 answer
Defining constant in config laravel
PHP Laravel
0 vote238 views1 answer
Laravel Dropzone Attachment Required is not working as expected
PHP Laravel
1 vote226 views2 answers
Laravel query builder sum
PHP Laravel
2 votes229 views5 answers
Laravel installation in windows
PHP Laravel
2 votes199 views2 answers
Get message validator failed laravel
PHP Laravel
0 vote155 views1 answer
Get random post laravel
PHP Laravel
9 votes211 views6 answers
Get raw query laravel
PHP Laravel
0 vote217 views1 answer
Pusher in laravel array_merge(): Argument #2 is not an array
PHP Laravel