/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

0 vote182 views1 answer
Add auth middleware to route laravel
PHP Laravel
0 vote187 views1 answer
Laravel error reporting code for view
PHP Laravel
5 votes196 views1 answer
Laravel route required parameters
PHP Laravel
2 votes172 views1 answer
Get the current route in laravel
PHP Laravel
3 votes202 views4 answers
Round() laravel
PHP Laravel
14 votes194 views6 answers
Laravel debug
PHP Laravel
0 vote179 views2 answers
Laravel display category post by slug
PHP Laravel
0 vote206 views1 answer
Use backpack and laravel-permission to edit user roles
PHP Laravel
3 votes200 views3 answers
Laravel clear table
PHP Laravel
0 vote187 views1 answer
Laravel collection splice
PHP Laravel