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 vote33 views1 answer
Send email template via php
PHP
5 votes28 views6 answers
Codeigniter base_url
PHP
4 votes33 views2 answers
Php read file line by line
PHP
1 vote35 views1 answer
Get today date magento 2 object manager
PHP
0 vote32 views1 answer
Php calculate variance
PHP
0 vote33 views1 answer
Create if not exist laravel
PHP
0 vote31 views1 answer
Connecting to database and performing sql queries
PHP
1 vote34 views1 answer
Php decode html special characters
PHP
0 vote32 views1 answer
Laravel inline if else if
PHP Laravel
0 vote25 views1 answer
Echo alphabet links
PHP