/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

12 votes156 views1 answer
Laravel model without timestamps
PHP Laravel
2 votes161 views2 answers
Laravel list of models
PHP Laravel
0 vote146 views1 answer
Textarea laravel migration
PHP Laravel
0 vote191 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
3 votes157 views3 answers
Laravel csrf-token in view
PHP Laravel
0 vote143 views1 answer
Get where different laravel
PHP Laravel
1 vote141 views1 answer
Laravel descending order paginate eloquent
PHP Laravel
0 vote138 views2 answers
Laravel logout all users
PHP Laravel
0 vote175 views1 answer
How to create module in laravel
PHP Laravel
1 vote158 views1 answer
Stack once laravel
PHP Laravel