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

13 votes220 views6 answers
Wordpress get user by id
PHP
0 vote293 views1 answer
Laravel nova create user
PHP Laravel
0 vote226 views1 answer
How to write orderby in join query with where clause in codeigniter
PHP
2 votes224 views1 answer
Blade button confim
PHP
0 vote213 views1 answer
Laravel routes return view in web.php
PHP
0 vote222 views1 answer
Iterate over assets container statamic
PHP
0 vote215 views1 answer
Bad request on localhost but it work on 127.0.0.1 address
PHP
-1 vote220 views1 answer
Laravel migration table bigint
PHP
0 vote225 views1 answer
Alter mysql 8 user root phpmyadmin first install
PHP
6 votes223 views5 answers
Timestamp php
PHP