/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 votes356 views1 answer
Laravel get only relationship
PHP Laravel
13 votes322 views6 answers
Laravel migration change column type
PHP Laravel
0 vote390 views1 answer
Route login not defined how to laravel problems fixed
PHP Laravel
0 vote350 views1 answer
Seguridad de las api en laravel
PHP Laravel
1 vote346 views2 answers
Laravel make directory
PHP Laravel
22 votes403 views2 answers
Where status is null sql in laravel
PHP Laravel
14 votes318 views2 answers
Laravel database select
PHP Laravel
0 vote316 views1 answer
Laravel model where set fields laravel
PHP Laravel
0 vote441 views1 answer
Encode in laravel api
PHP Laravel
3 votes362 views1 answer
Laravel back button
PHP Laravel