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.
$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.
select * from `Register` where `rollno` between ? and ?
<?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);
}
}
In this article, we will see a laravel 9 flash message example. Here, we will learn how to create or implement flash mes...
Dec-27-2022
In this article, we will see how to hide and show columns in datatable in jquery. This example shows how you can ma...
Jun-07-2022
In this article, we will see laravel 10 send bulk mail using a queue. Here, we will learn about how to send bulk ma...
Mar-13-2023
In this article, we will see how to deploy laravel on heroku with database. Heroku is a cloud platform as...
Feb-12-2021