Laravel-9 Tutorial – Laravel 9 Eloquent whereBetween() Query Example

The whereBetween method in laravel verifies that a column’s value is between two values. This tutorial walks you through an easy example of laravel eloquent wherebetween query.

How to use whereBetween in laravel application? Well, thats what we are going to answer in this tutorial.

This example will show you how to perform wherebetween queries with laravel eloquent wherebetween dates. We will fetch data by executing a query for two values in the database.

Without further ado let’s check out whereBetween() eloquent query in Laravel.

   
namespace AppHttpControllers;
    
use IlluminateHttpRequest;
use AppStudent;
  
class StudentController extends Controller
{
    
    
    public function index()
    {
        $students = Student::select("*")
                        ->whereBetween('points', [1, 150])
                        ->get();
  
        print_r($students);
    }
}

Laravel whereBetween method are handy when you require to get records in between two provided dates for the given timestamp column.

   
namespace AppHttpControllers;
    
use IlluminateHttpRequest;
use CarbonCarbon;
use AppStudent;
  
class StudentController extends Controller
{
    
    
    public function index()
    {
        $startDate = Carbon::now()->subDays(30);
        $endDate = Carbon::now();
  
        $students = User::select("*")
                        ->whereBetween('created_at', [$startDate, $endDate])
                        ->get();
  
        print_r($students);
    }
}

By using carbon its more comfortable to work with dates in Laravel,
Carbon offers unbound easiness.

We have completed this tutorial, i hope you liked it.