In this laravel whereBetween eloquent tutorial, you will learn how to get data from between two id and dates from MySQL DB in laravel.
Like you have to show in analytics dashboard. How many users have been registered from between two dates. you can use whereBetween eloquent methods for that.
Here we will take some examples of where between eloquent methods, see the following examples:
Example 1: whereBetween query With Ids
Sometimes, you may want to get some records from between database columns, you can use the following query:
$users = User::whereBetween('id', [1, 50])->get();
This laravel eloquent query fetches the users between given id 1 to 50 from users table.
Example 2: Laravel Eloquent wherebetween Dates
If you may want to get all records from database between two dates, you can pass the start date and end date in this query as well as pass the column name.
Consider the following example:
$users = User::whereBetween('created_at', [start_date, end_date])->get();
This laravel eloquent query fetches the rows between given start date to end date from MySQL DB.