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 vote116 views1 answer
Afosto/yaac error parsing certificate request
PHP
6 votes115 views3 answers
Remove .php from url
PHP
0 vote122 views1 answer
Php const scope
PHP
0 vote88 views1 answer
Pdo example
PHP
0 vote359 views1 answer
Best Performance monitoring tools for php
PHP
14 votes206 views6 answers
Wordpress get user by id
PHP Wordpress
-1 vote128 views2 answers
Php rtrim
PHP
14 votes105 views6 answers
Laravel debug
PHP
0 vote134 views1 answer
Laravel $browser->keys alt click
PHP Laravel
14 votes103 views3 answers
Get extension from filename php
PHP