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 Record And Play Audio In JavaScript
How To Record And Play Audio I...

In this article, we will see how to record and play audio in javascript. Here, we will learn about how to record au...

Read More

Feb-20-2023

How To Install PHP CURL Extension In Ubuntu
How To Install PHP CURL Extens...

In this article, we will focus on the process of installing the PHP cURL extension in Ubuntu. The PHP cURL extension pro...

Read More

Jul-21-2023

Laravel 9 Cron Job Task Scheduling Tutorial
Laravel 9 Cron Job Task Schedu...

In this article, we will see laravel 9 cron job task scheduling tutorial, many times we require to run some piece o...

Read More

Mar-17-2022

Laravel 8 Form Class Not Found
Laravel 8 Form Class Not Found

In this small post, we will solve the laravel 8 form class not found error, many time we have received errors like the l...

Read More

Mar-12-2021