/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

48 votes252 views5 answers
Laravel clear route cache
PHP Laravel
22 votes186 views6 answers
Php artisan make:auth laravel 8
PHP Laravel
1 vote178 views1 answer
Laravel query get big table records
PHP Laravel
0 vote203 views1 answer
Show all laravel valet folders
PHP Laravel
0 vote135 views1 answer
How convert the string to int in laravel function event
PHP Laravel
0 vote190 views1 answer
Laravel range query
PHP Laravel
2 votes205 views3 answers
How to change the colum type in migration laravel
PHP Laravel
1 vote179 views2 answers
Laravel view with data in blade
PHP Laravel
0 vote210 views1 answer
Laravel package for getID3()
PHP Laravel
0 vote186 views1 answer
How to read laravel query string with dash
PHP Laravel