In this tutorial you will learn about the Laravel 8 Eloquent whereBetween() Between Database Query Example and its application with practical example.
In this laravel whereBetween eloquent tutorial, I’ll show you how use whereBetween method in laravel queries. In this tutorial you will learn to use whereBetween function with laravel queries. You will also learn to use whereBetween in laravel query builder and laravel model. With whereBetween we can fetch data between provided range from table in laravel.
Laravel whereBetween
The laravel whereBetween clause is used to query data between provided range for specific column criteria. Suppose you want to know How many users have registered between two dates range. You can query this data using whereBetween eloquent methods.
Laravel whereBetween with provided range
In this example we will fetch the records with specified column value is in provided range.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use App\Student; class StudentController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $students = Student::select("*") ->whereBetween('points', [1, 150]) ->get(); print_r($students); } } |
Laravel whereBetween with start date and end date
In this example we will use Laravel whereBetween method to get records in between two provided dates.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 |
<?php namespace App\Http\Controllers; use Illuminate\Http\Request; use Carbon\Carbon; use App\Student; class StudentController extends Controller { /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index() { $startDate = Carbon::now()->subDays(30); $endDate = Carbon::now(); $students = User::select("*") ->whereBetween('created_at', [$startDate, $endDate]) ->get(); print_r($students); } } |
