/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 vote229 views1 answer
Laravel add model to one to many relationship
PHP Laravel
0 vote213 views1 answer
Laravel nova resolveUsing
PHP Laravel
0 vote217 views1 answer
SoapClient Laravel 8
PHP Laravel
0 vote195 views2 answers
Where () laravel Eloquent
PHP Laravel
0 vote223 views1 answer
Logout all users laravel 8
PHP Laravel
7 votes198 views5 answers
Laravel foreach loop index in controller
PHP Laravel
0 vote211 views7 answers
Laravel eloquent tricks
PHP Laravel
0 vote216 views1 answer
Laravel collection reverse
PHP Laravel
0 vote209 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
0 vote245 views3 answers
Laravel Eloquent sum of multiplied columns
PHP Laravel