/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

3 votes243 views1 answer
Print session in laravel
PHP Laravel
0 vote267 views1 answer
Image watermark on image laravel 8
PHP Laravel
0 vote293 views3 answers
Email or phone required in laravel
PHP Laravel
0 vote247 views1 answer
Laravel on cascade set null
PHP Laravel
3 votes241 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
9 votes219 views1 answer
Npm run dev error laravel 8
PHP Laravel
5 votes217 views5 answers
Install laravel 8 with composer
PHP Laravel
6 votes217 views3 answers
How to get parameter from url in laravel blade
PHP Laravel
0 vote222 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
0 vote257 views1 answer
Laravel collection collapse
PHP Laravel