/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

5 votes342 views5 answers
Laravel file permissions
PHP Laravel
0 vote328 views1 answer
Laravel count without pagination
PHP Laravel
2 votes307 views2 answers
Laravel forcefill
PHP Laravel
8 votes254 views1 answer
Laravel storage not found
PHP Laravel
0 vote280 views1 answer
Laravel This package is not auto-updated. Please set up the GitHub Hook for Packagist so that it gets updated whenever you push!
PHP Laravel
2 votes334 views6 answers
Get last id in laravel
PHP Laravel
14 votes296 views5 answers
Laravel model tablename
PHP Laravel
0 vote321 views1 answer
Delay queue laravel
PHP Laravel
3 votes292 views3 answers
Where with and and or in a laravel
PHP Laravel
1 vote296 views2 answers
How many users can a cron handle in laravel in single run
PHP Laravel