add(new DateInterval('P' . $i . 'D'));
$available_slots = [];
for ($time = 9; $time < 17; $time++) {
$booking_check_res = $db->query("SELECT * FROM bookings WHERE date_of_booking = '" . $date->format('Y-m-d') . "' AND time_start = '" . $time . ":00' AND time_end = '" . ($time + 1) . ":00' AND (status != 3)");
if ($booking_check_res->num_rows == 0) {
$available_slots[] = $time;
}
}
// Check for 6 consecutive available slots
$consecutive = 1;
$has_six = false;
for ($j = 1; $j < count($available_slots); $j++) {
if ($available_slots[$j] == $available_slots[$j - 1] + 1) {
$consecutive++;
if ($consecutive >= 6) {
$has_six = true;
break;
}
} else {
$consecutive = 1;
}
}
if ($has_six) {
?>