/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 vote199 views1 answer
Laravel validate form data unique array
PHP Laravel
1 vote175 views2 answers
Time left laravel seconds
PHP Laravel
0 vote183 views2 answers
Default language laravel
PHP Laravel
0 vote223 views1 answer
Defining constant in config laravel
PHP Laravel
3 votes194 views4 answers
Input if not null laravel
PHP Laravel
0 vote194 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
2 votes193 views1 answer
Laravel upload image to public folder
PHP Laravel
4 votes216 views2 answers
Validate year laravel
PHP Laravel
3 votes198 views1 answer
How validate array in laravel in request
PHP Laravel
52 votes251 views6 answers
Join in laravel eloquent
PHP Laravel