/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 vote240 views1 answer
Laravel orm latest()
PHP Laravel
0 vote222 views1 answer
Howw to see if a value is posted laravel
PHP Laravel
18 votes208 views1 answer
Schema::default string laravel
PHP Laravel
46 votes252 views6 answers
Laravel make controller with model
PHP Laravel
3 votes174 views1 answer
Laravel throw function
PHP Laravel
14 votes191 views2 answers
Laravel database select
PHP Laravel
0 vote216 views1 answer
Laravel firstorcreate with multiple parameters
PHP Laravel
0 vote193 views1 answer
Laravel database engine innodb
PHP Laravel
0 vote229 views1 answer
How to pass parameters to relationships laravel
PHP Laravel
0 vote205 views1 answer
Distinct laravel not working
PHP Laravel