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();
Hello to all. Welcome to therichpost.com. Myself Ajay Malhotra and I am full stack developer. I love coding. I know Wordpress, Core php, Angularjs, Angular 2, Angular 6, laravel, Codeigniter, Shopify, Squarespace, Jquery, GoogleMapApi Vuejs, Reactjs, Bigcommerce etc.
All posts byAjay Malhotra