/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 votes305 views1 answer
Create migration, controller, model and seeder laravel
PHP Laravel
0 vote320 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
0 vote370 views2 answers
Laravel check if string is url
PHP Laravel
1 vote300 views2 answers
Laravel model fillable vs guarded
PHP Laravel
0 vote333 views1 answer
Laravel Exclude URI from csrf token verification
PHP Laravel
11 votes324 views2 answers
Command laravel for php artisan make :auth
PHP Laravel
0 vote327 views2 answers
Pass guzzle client data to view laravel
PHP Laravel
19 votes335 views5 answers
Php artisan auth in laravel 8
PHP Laravel
16 votes302 views6 answers
Laravel group routes
PHP Laravel
7 votes351 views3 answers
Get table name from model laravel
PHP Laravel