In this laravel wherein eloquent tutorial, you will learn everything about laravel eloquent whereIn() method to creating a query with model and builder.
In Laravel, the whereIn() method is an eloquent query builder function that allows you to filter query results based on a specified array list of values. This method is particularly useful when you want to retrieve records that match any of the values provided in the array list, which acts like an “OR” condition for multiple values or arrays.
The syntax for using whereIn() is straightforward:
$matchingRecords = Model::whereIn('column_name', $arrayOfValues)->get();
Here, Model represents the Eloquent model you’re querying, 'column_name' is the name of the column you want to compare the values against, and $arrayOfValues is an array containing the values you want to check for.
Here are a few examples to help you understand how to use the whereIn query in Laravel:
Example 1: wherein Query Using Simple SQL Query:
SELECT * FROM users WHERE id IN (10, 15, 18)
In this query, the data will be get from the DB table. Whose ids will be 10, 15, 18.
Example 2: Retrieving Users by IDs using Eloquent Wherein Query
Let’s say you have a users table and you want to retrieve users by their IDs. You have an array of IDs you’re interested in:
$userIds = [1, 3, 5, 7];
$users = User::whereIn('id', $userIds)->get();
This will fetch users whose IDs match any of the values in the $userIds array.
Example 3: Filtering Posts by Categories Using Wherein
Suppose you have a posts table with a category_id column, and you want to retrieve posts from specific categories. You have an array of category IDs you’re targeting:
$categoryIds = [2, 4, 6];
$posts = Post::whereIn('category_id', $categoryIds)->get();
This query will return posts that belong to any of the specified categories.
Example 4: Eloquent Wherein Query Using Laravel Model With Different Column Name
public function index()
{
$data= User::whereIn('name', ['john','dam','smith'])->get();
dd($data);
}
Example 5: Selecting Orders by Status
Assume you have an orders table with an order_status column indicating the status of an order. You want to retrieve orders with certain statuses:
$statuses = ['pending', 'processing'];
$orders = Order::whereIn('order_status', $statuses)->get();
Here, the query will fetch orders with either a “pending” or “processing” status.
Conclusion
Laravel wherein query example tutorial, you have learned how to use laravel wherein() method with eloquent query builder and model.
