/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 vote185 views1 answer
Get random post laravel
PHP Laravel
0 vote183 views1 answer
Laravel download file from storage with progress bar
PHP Laravel
3 votes229 views2 answers
Allowed memory size of 1610612736 bytes exhausted (tried to allocate 4096 bytes) laravel
PHP Laravel
0 vote223 views1 answer
Laravel project create with version
PHP Laravel
3 votes202 views1 answer
Laravel policy create
PHP Laravel
0 vote256 views1 answer
Laravel view not created using foreign keys
PHP Laravel
2 votes256 views1 answer
Laravel get list of columns in a table
PHP Laravel
0 vote230 views1 answer
Laravel throw 503
PHP Laravel
1 vote217 views1 answer
How to use bootstrap in laravel 8 remove tailwind
PHP Laravel
7 votes235 views1 answer
Laravel not in query
PHP Laravel