/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 vote166 views1 answer
Integer nullable laravel
PHP Laravel
2 votes174 views2 answers
Laravel blade auth check
PHP Laravel
0 vote161 views1 answer
Laravel validation mimes always fails
PHP Laravel
0 vote152 views1 answer
Laravel controller data update
PHP Laravel
-1 vote274 views1 answer
Laravel seo
PHP Laravel
14 votes132 views6 answers
Laravel migration set default value
PHP Laravel
1 vote167 views2 answers
Pass image path in laravel blade
PHP Laravel
34 votes148 views4 answers
Make:controller in laravel 8
PHP Laravel
0 vote104 views1 answer
Laraverl add collect
PHP Laravel
0 vote164 views1 answer
Laravel delete controller still cached
PHP Laravel