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.

Ajay Malhotra
the authorAjay Malhotra
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 2, Angular 6, Angular 7, Angular 8, Angular 9, Angular 10 Nodejs, laravel, Codeigniter, Shopify, Squarespace, Jquery, Google Map Api, Vuejs, Reactjs, Bigcommerce etc.

Leave a Reply

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