/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 vote145 views2 answers
Laravel - Resize image size using Laravel image class
PHP Laravel
6 votes140 views2 answers
Laravel findorfail
PHP Laravel
0 vote146 views1 answer
How to perform form inpot in laravel 8 and export database
PHP Laravel
6 votes136 views2 answers
Laravel check if request has value
PHP Laravel
1 vote166 views1 answer
Autoload file in laravel
PHP Laravel
0 vote131 views1 answer
Php laravel rount price to 99
PHP Laravel
8 votes132 views4 answers
Join multiple tables in laravel eloquent
PHP Laravel
0 vote133 views3 answers
Laravel 7 pagination with search filter
PHP Laravel
0 vote135 views1 answer
Laravel Code To Rename file on server in the storage folder
PHP Laravel
8 votes132 views3 answers
Force delete soft delete laravel
PHP Laravel