/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 vote166 views1 answer
Laravel new line in session flash message
PHP Laravel
0 vote172 views1 answer
Form validation nullable laravel
PHP Laravel
4 votes111 views1 answer
Laravel schedule command every 8 hours laravel
PHP Laravel
0 vote153 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
44 votes244 views2 answers
Laravel version command
PHP Laravel
26 votes184 views6 answers
Drop foreign key laravel
PHP Laravel
1 vote157 views1 answer
How change the languge of fie manager in laravel
PHP Laravel
1 vote177 views3 answers
Laravel invoice toturial
PHP Laravel
10 votes163 views4 answers
In random order laravel
PHP Laravel
4 votes157 views2 answers
Laravel carbon get month name español
PHP Laravel