Laravel whereBetween Query Example

Websolutionstuff | Jan-13-2021 | Categories : Laravel PHP

In this article, we will see laravel whereBetween query example. SQL provides many different types of methods or queries to get filtered data from databases. So, in this post, we will learn laravel whereBetween and orWhereBetween query builder examples. In laravel 6, laravel 7, and laravel 8 you can use the whereBetween() and orWhereBetween() functions to get records from a given date range or values.

Here, we will give you the code of laravel whereBetween dates example. In the below code, we have added laravel wherebetween with orwherebetween SQL query as well as Laravel query.

So, let's see the whereBetween query in laravel 7/8 and the whereBetween SQL query example.

Example of whereBetween() condition in laravel

$students = DB::table('Register')
           ->whereBetween('RollNo', [1, 50])
           ->get();

Now I will show you an example of whereBetween() query in laravel 6/7/8 and how to write whereBetween() condition in laravel. So first we will see SQL query for better understanding.

 

SQL OR Example

select * from `Register` where `rollno` between ? and ?

 

get all records between two dates using where between in laravel

<?php
  
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Register;
use Carbon\Carbon;
  
class RegisterController extends Controller
{
    public function index(Request $request)
    {
      $names = Register::whereBetween
               ('created_at',[$request->start_date,$request->$end_date])->get();
  
        dd($names);
    }
}

 

Recommended Post
Featured Post
Top 12 Tips To Improve React JS Performance In 2023
Top 12 Tips To Improve React J...

In the dynamic world of web development, staying ahead of the curve is essential, and in 2023, React JS continues to be...

Read More

Aug-28-2023

How to Convert DateTime to Timestamp in PHP
How to Convert DateTime to Tim...

In PHP, converting DateTime objects to timestamps is a common task, especially when dealing with databases or manipulati...

Read More

Mar-13-2024

Laravel 6/7 CRUD tutorial with example
Laravel 6/7 CRUD tutorial with...

In this example, I will show you how to make simple laravel CRUD(insert, update, delete, or list) operations with e...

Read More

May-08-2020

How To Validate Email Using jQuery
How To Validate Email Using jQ...

In this article, we will see how to validate email using jquery. we will use regular expression(regex) for email va...

Read More

Nov-09-2022