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 vote363 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote353 views2 answers
Save big data with laravel
PHP
0 vote356 views1 answer
Doctrine orm refresh
PHP
0 vote385 views1 answer
Php remove notice session already been started
PHP
0 vote338 views1 answer
How to remove updated_at or use only created_at laravel eloquent ORM
PHP
3 votes381 views2 answers
Laravel model exists id
PHP Laravel
4 votes353 views2 answers
Delete all rows in table laravel
PHP
0 vote424 views2 answers
From user id to user role wordpress
PHP Wordpress
0 vote355 views1 answer
Gate::before not working laravel 8
PHP Laravel
0 vote397 views1 answer
Codeigniter remote queries very slow
PHP CodeIgniter