/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 vote306 views2 answers
Laravel get path to storage folder
PHP Laravel
-1 vote263 views1 answer
Laravel merge two arrays helper
PHP Laravel
5 votes260 views2 answers
Get app url in laravel
PHP Laravel
0 vote265 views1 answer
Maintaining serial number in laravel pagination table
PHP Laravel
0 vote239 views1 answer
'laravel'
PHP Laravel
2 votes274 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
-2 votes275 views3 answers
Laravel when condition
PHP Laravel
0 vote283 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
8 votes259 views2 answers
Laravel passport
PHP Laravel
4 votes259 views4 answers
Installing laravel 8
PHP Laravel