/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

32 votes227 views2 answers
Add column migration laravel 8
PHP Laravel
1 vote202 views1 answer
Laravel storage check file exists
PHP Laravel
1 vote193 views1 answer
Paystack gateway integration laravel
PHP Laravel
0 vote194 views1 answer
Laravel project htaccess redirect to public path
PHP Laravel
1 vote208 views2 answers
Public laravel htaccess
PHP Laravel
7 votes204 views6 answers
Sort laravel eloquent
PHP Laravel
0 vote241 views1 answer
Laravel rule unique where
PHP Laravel
2 votes210 views2 answers
How to do laravel in sidebar active menu dynamic blade
PHP Laravel
16 votes195 views3 answers
Laravel request validate
PHP Laravel
1 vote227 views1 answer
How convert the date and time to integer in laravel
PHP Laravel