Level 50
$departments = Departments::whereIn('id', [1,2,3,4,5,6,7]);
https://laravel.com/docs/master/collections#method-wherein
Happy coding!
2 likes
Jul 24, 2019
6
Level 1
Multiple Find Query in single database connection
$departments = [];
foreach ([1, 2, 3, 4, 5, 6, 7] as $department) {
array_push($departments, Department::find($department));
}
return $departments;
How can I make all these multiple query on a single database connection for better performance?
Level 104
Remember to execute the query @aurawindsurfing ;)
$departments = Departments::whereIn('id', [1,2,3,4,5,6,7])->get();
1 like
Level 50
@tykus I had get in there, then looked at docs and removed it 😮 😀
Level 2
find function is able to receive an array in the $id argument:
$departments = Department::find([1, 2, 3, 4, 5, 6, 7])
Level 1
Thanks loads.
$departments = Departments::whereIn('id', [1,2,3,4,5,6,7])->get();
Level 50
@kima find uses behind scenes whereIn 😀
If $key is an array of keys, find will return all models which match the $keys using whereIn()
Please or to participate in this conversation.