/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 vote158 views1 answer
Laravel display the date the participation was created
PHP Laravel
0 vote164 views1 answer
Laravel eloquent where value less then 5 and greter then 0
PHP Laravel
0 vote146 views1 answer
Laravel throw 503
PHP Laravel
0 vote163 views1 answer
Laravel collection pop
PHP Laravel
7 votes142 views2 answers
Laravel seeder with relationships
PHP Laravel
6 votes145 views1 answer
PDOException::("SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes") laravel 8
PHP Laravel
1 vote149 views1 answer
Copy env example to .env in laravel
PHP Laravel
7 votes138 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
0 vote140 views4 answers
How i can send by database table in laravel full calendar
PHP Laravel
5 votes134 views2 answers
Current loggedin user laravel
PHP Laravel