/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 vote181 views1 answer
Find the next 7 date data in laravel eloquent
PHP Laravel
1 vote145 views3 answers
Print query statement in laravel
PHP Laravel
1 vote154 views4 answers
Create json laravel
PHP Laravel
1 vote96 views1 answer
Laravel data types
PHP Laravel
1 vote170 views1 answer
Date casting from datetime to d-m-Y laravel
PHP Laravel
0 vote144 views4 answers
Error": "Trying to get property 'id' of non-object" in laravel
PHP Laravel
5 votes152 views2 answers
Laravel chmod
PHP Laravel
2 votes154 views1 answer
Proper permission webserver laravel
PHP Laravel
0 vote147 views1 answer
Check for headers laravel
PHP Laravel
2 votes145 views1 answer
Add id to route name in laravel blade
PHP Laravel