An Interest In:
Web News this Week
- April 18, 2024
- April 17, 2024
- April 16, 2024
- April 15, 2024
- April 14, 2024
- April 13, 2024
- April 12, 2024
April 8, 2022 03:02 am GMT
Original Link: https://dev.to/techsolutionstuff/laravel-wherebetween-query-example-24mk
Laravel whereBetween Query Example
In this artical I will show laravel whereBetween query example. As we know SQL provides many diffrent type of method or query to get filtered data from database. So, in this post we will learn laravel orWhereBetween query builder example.
Here we will see example of laravel wherebetween dates example,Here i have added laravel wherebetween with orwherebetween SQL query as well as Laravel query.
Example of whereBetween() condition in laravel
$students = DB::table('Register') ->whereBetween('RollNo', [1, 50]) ->get();
Now I will show you example of whereBetween() query in laravel 8 and how to write whereBetween() condition in laravel. So first we will see SQL query for better understanding.
SQL Query Example
select * from `Register` where `rollno` between ? and ?
Get all records between two dates using wherebetween in laravel
<?phpnamespace 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); }}
You might also like :
Original Link: https://dev.to/techsolutionstuff/laravel-wherebetween-query-example-24mk
Share this article:
Tweet
View Full Article
Dev To
An online community for sharing and discovering great ideas, having debates, and making friendsMore About this Source Visit Dev To