Finding data by ID or IDs is commonly used. Here we search or query the primary key of the model and get data. In this tutorial, we will see some methods to get data by multiple IDs.
To get a database record from Laravel Eloquent by ID or Multiple IDs, we can use of Model find() or findMany() method. However, most developers only know one usage to get one single record while it can be used to return multiple records.
Getting Data of IDs Using find() Method
Generally, we use the find() method to get a single record by ID. But here we can use the find() method to get data by passing an array of IDs. Let's see an example to use the find method to get data by IDs.
// To get a single record $user = User::find(1); // To get data by multiple IDs $users = User::find([1,2,3,4,5]);
Here, we have used the find method to get data by single ID as well as multiple IDs.
Getting Data of IDs Using findMany() method
The findMany() method is used to get data by multiple IDs. Here we will pass an array as a parameter and it will check it against the model and return data.
The findMany() method uses the whereIn() method in the background where we pass an array of IDs and in the background, it will convert into whereIn() condition to get data.
$IDs = [1,2,4,6]; $users = User::findMany($IDs);
In this article, we have seen two methods to get data using multiple IDs. I prefer the findMany() method because it is more explicit. The findMany() method use whereIn() method while if we pass the array in find() method then it will call findMany() method in the background.