/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

12 votes396 views6 answers
Laravel json response
PHP Laravel
0 vote375 views1 answer
File original extensions laravel
PHP Laravel
2 votes357 views3 answers
Laravel get query result as array
PHP Laravel
1 vote411 views1 answer
Where year month laravel
PHP Laravel
14 votes387 views3 answers
How to convert string to int in php laravel
PHP Laravel
0 vote385 views1 answer
Laravel string capitalize in view
PHP Laravel
0 vote395 views2 answers
Show query in laravel
PHP Laravel
44 votes398 views6 answers
How to create controller in laravel
PHP Laravel
8 votes387 views3 answers
Laravel date between
PHP Laravel
0 vote417 views1 answer
Delay queue laravel
PHP Laravel