Home Laravel Laravel query with or condition between multiple dates check

Laravel query with or condition between multiple dates check

by therichpost
0 comment
Laravel 7.2 routing with route group auth guard check with prefix

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.

You may also like

Leave a Comment

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