/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 vote142 views1 answer
Laravel check model column was changed
PHP Laravel
0 vote145 views2 answers
All() in laravel
PHP Laravel
14 votes171 views6 answers
Laravel create model and migration
PHP Laravel
1 vote168 views2 answers
Get the value without setter method laravel
PHP Laravel
2 votes164 views1 answer
Return back in blade laravel
PHP Laravel
4 votes159 views4 answers
Laravel check if table has column
PHP Laravel
9 votes176 views4 answers
Laravel soft delete example
PHP Laravel
0 vote200 views1 answer
Laravel weekly data
PHP Laravel
1 vote153 views1 answer
Laravel where column different
PHP Laravel
0 vote176 views1 answer
Laravel signed Route custom domain
PHP Laravel