/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

1 vote210 views2 answers
Laravel gmail
PHP Laravel
0 vote156 views1 answer
Laravel migration first or model first
PHP Laravel
1 vote207 views1 answer
Laravel 8 plural singular
PHP Laravel
6 votes204 views4 answers
Laravel force delete
PHP Laravel
0 vote204 views1 answer
Laravel eloquent select one column
PHP Laravel
0 vote213 views3 answers
Laravel migration softdelete
PHP Laravel
0 vote193 views1 answer
If session is empty laravel
PHP Laravel
1 vote209 views1 answer
Laravel server sent events
PHP Laravel
12 votes216 views6 answers
Set session data in laravel
PHP Laravel
7 votes215 views2 answers
Laravel field types from database field type
PHP Laravel