/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

2 votes175 views3 answers
Laravel get file size uploaded
PHP Laravel
28 votes182 views5 answers
Migrate specific table laravel
PHP Laravel
0 vote166 views1 answer
Check if any field update laravel
PHP Laravel
0 vote176 views5 answers
Laravel tricks and tips
PHP Laravel
0 vote176 views1 answer
Combine 2 columns search query laravel
PHP Laravel
1 vote182 views1 answer
Laravel form action with parameter
PHP Laravel
1 vote156 views1 answer
Create resources laravel
PHP Laravel
8 votes180 views6 answers
Session in laravel
PHP Laravel
4 votes379 views6 answers
Laravel jwt
PHP Laravel
4 votes207 views5 answers
Laravel with and where
PHP Laravel