Categories

Saturday, November 9, 2024
#919814419350 therichposts@gmail.com
Laravel

Laravel query with or condition between multiple dates check

Laravel 7.2 routing with route group auth guard check with prefix

Laravel query with or condition between multiple dates check

Hello to all, welcome to therichpost.com. In this post, I will tell you, Laravel query with or condition between multiple dates check. Like I always say that laravel is the best Mvc php framework.

Here is the working and tested query for laravel or conditions between multiple dates:
$bookingChk = DB::table('users')
->select('id')
->where('staff_id', "=", $req->staffdetail)
->whereBetween('joinDateTime', [$startDateTime, $endDateTime])
->orWhereBetween('endDateTime', [$startDateTime, $endDateTime])
->get();

 if you have any query related this post then please do ask.

therichpost
the authortherichpost
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am freelance full stack developer. I love coding. I know WordPress, Core php, Angularjs, Angular 19, MedusaJs, Next.js, Bootstrap 5, Nodejs, Laravel, Codeigniter, Shopify, Squarespace, jQuery, Google Map Api, Vuejs, Reactjs, Big commerce etc.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.