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 vote170 views1 answer
Php event listener
PHP
4 votes210 views5 answers
Laravel get first record
PHP
23 votes200 views4 answers
Laravel change foreign key name
PHP Laravel
0 vote177 views1 answer
Php if time is greater than
PHP
0 vote198 views4 answers
Laravel old value for select option
PHP Laravel
3 votes212 views2 answers
Php camelcase to snake case
PHP
6 votes191 views4 answers
Laravel create project command
PHP
2 votes172 views1 answer
Order by in codeigniter
PHP CodeIgniter
0 vote186 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP
12 votes185 views3 answers
How to log object laravel logger
PHP