/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 vote112 views3 answers
Laravel Eloquent sum of multiplied columns
PHP Laravel
0 vote109 views1 answer
Import class route laravel
PHP Laravel
1 vote135 views1 answer
Laravel get last get request
PHP Laravel
1 vote110 views2 answers
Laravel request all except
PHP Laravel
0 vote123 views1 answer
Laravel post index method
PHP Laravel
2 votes119 views2 answers
Bootstrap pagination laravel
PHP Laravel
2 votes129 views2 answers
Target class [AppHttpControllersRegisterController] does not exist. laravel 8
PHP Laravel
1 vote114 views2 answers
Get unique values in laravel
PHP Laravel
0 vote114 views1 answer
Laravel collection has
PHP Laravel
8 votes122 views1 answer
If any error in blade laravel
PHP Laravel