/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 vote336 views1 answer
Check array is associative laravel
PHP Laravel
5 votes346 views1 answer
Laravel get random row
PHP Laravel
0 vote325 views1 answer
Laravel launch only one dusk test
PHP Laravel
32 votes368 views2 answers
Add column migration laravel 8
PHP Laravel
0 vote329 views2 answers
Laravel debugbar not showing
PHP Laravel
0 vote356 views1 answer
Laravel collection pipe
PHP Laravel
1 vote326 views1 answer
Laravel bindings query
PHP Laravel
2 votes319 views3 answers
Laravel 8 404 status
PHP Laravel
1 vote318 views1 answer
Return response array laravel
PHP Laravel
0 vote334 views1 answer
Delete a single record in laravel 5
PHP Laravel