php - Display all data which are between these dates

one text

Solution:

Try the query as below.

$start_date = Carbon::parse($newstartdate)->format('Y-m-d H:i:s');
$end_date = Carbon::parse($newenddate)->format('Y-m-d H:i:s');

$bookinks = \DB::table('facility_booking')->where([['book_date_start','<=',$start_date],['book_date_end','>=',$end_date]])
              ->orwhereBetween('book_date_start',array($start_date,$end_date))
             ->orWhereBetween('book_date_end',array($start_date,$end_date))->get();