/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

1 vote303 views1 answer
Laravel make:listner
PHP Laravel
8 votes355 views3 answers
Laravel 8 check if record exists
PHP Laravel
15 votes312 views6 answers
Laravel migration delete column
PHP Laravel
0 vote330 views1 answer
Laravel env asset_url
PHP Laravel
0 vote340 views1 answer
Laravel app running in console
PHP Laravel
5 votes305 views6 answers
Laravel 8 auth
PHP Laravel
1 vote363 views2 answers
Laravel eloquent join two models
PHP Laravel
-2 votes358 views3 answers
Laravel when condition
PHP Laravel
10 votes302 views2 answers
Laravel list routes
PHP Laravel
0 vote314 views2 answers
Laravel file path
PHP Laravel