/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 vote172 views1 answer
Laravel store blob image into database
PHP Laravel
0 vote185 views1 answer
Laravel import data from csv
PHP Laravel
0 vote358 views2 answers
Laravel orm tutorial
PHP Laravel
0 vote171 views1 answer
Create fake users on click laravel
PHP Laravel
1 vote170 views1 answer
Laravel add (s) at the end of text based on how many data
PHP Laravel
1 vote164 views1 answer
Laravel old value or default
PHP Laravel
2 votes166 views1 answer
Create migration, controller, model and seeder laravel
PHP Laravel
1 vote161 views1 answer
Autoload file laravel
PHP Laravel
1 vote216 views2 answers
Laravel api too many requests
PHP Laravel
2 votes178 views3 answers
Laravel migration drop foreign keys
PHP Laravel