/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 vote397 views1 answer
How to update a table based on three columns laravel
PHP Laravel
0 vote367 views3 answers
When you click on the search button, it is moved to the page laravel
PHP Laravel
12 votes350 views5 answers
Drop column migration laravel
PHP Laravel
13 votes343 views3 answers
Laravel string
PHP Laravel
0 vote430 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel
1 vote396 views2 answers
Cart::subtotal in laravel
PHP Laravel
14 votes342 views2 answers
Laravel database select
PHP Laravel
1 vote384 views2 answers
Laravel 8
PHP Laravel
0 vote386 views1 answer
Nuxt auth login with laravel passport
PHP Laravel
2 votes361 views1 answer
Laravel pivot table model
PHP Laravel