/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 vote298 views1 answer
Verta sample jalali laravel problem return object
PHP Laravel
2 votes308 views1 answer
Laravel string key
PHP Laravel
13 votes317 views5 answers
Laravel add item to array
PHP Laravel
0 vote284 views1 answer
Laravel Http client throw exception if request is not successful
PHP Laravel
1 vote340 views1 answer
Edit data using model in laravel 8
PHP Laravel
5 votes272 views2 answers
Laravel eloquent get first
PHP Laravel
-1 vote333 views6 answers
How to install bootstrap in laravel 8
PHP Laravel
1 vote424 views1 answer
Laravel mongodb delete
PHP Laravel
0 vote313 views1 answer
Laravel count by date
PHP Laravel
8 votes311 views3 answers
Route parameter type laravel
PHP Laravel