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
How To Integrate Stripe Payment Gateway In Laravel 9
How To Integrate Stripe Paymen...

In this article, we will see how to integrate the stripe payment gateway in laravel 9. stripe payment gateway is in...

Read More

Apr-10-2022

How to Image Upload with Preview in Angular 17
How to Image Upload with Previ...

In this article, we'll see how to image upload with a preview in angular 17. Here, we'll learn about the an...

Read More

Apr-01-2024

How to Handle Exception in PHP with Example
How to Handle Exception in PHP...

Hey there, Ever found yourself scratching your head over unexpected errors in your PHP code? Fret not, because today, we...

Read More

Dec-15-2023

How To Integrate Swagger In laravel 10
How To Integrate Swagger In la...

In the dynamic realm of modern web development, ensuring that APIs are well-documented, easy to comprehend, and seamless...

Read More

Aug-18-2023