How can PHP scripts be optimized to handle reservation data and prevent double bookings within a specified time frame?

To optimize PHP scripts for handling reservation data and preventing double bookings within a specified time frame, you can implement a database query to check for existing reservations within the desired time frame before allowing a new reservation to be added. This can be achieved by querying the database for overlapping reservations and only allowing a new reservation if no conflicts are found. 

// Assuming $start_datetime and $end_datetime are the start and end times of the new reservation
// Check if there are any overlapping reservations in the database
$query = "SELECT * FROM reservations WHERE ((start_datetime <= '$start_datetime' AND end_datetime >= '$start_datetime') OR (start_datetime <= '$end_datetime' AND end_datetime >= '$end_datetime'))";
$result = mysqli_query($conn, $query);

if(mysqli_num_rows($result) > 0) {
    // Handle double booking error
    echo "Double booking detected. Please choose a different time slot.";
} else {
    // Proceed with adding the new reservation to the database
    $insert_query = "INSERT INTO reservations (start_datetime, end_datetime) VALUES ('$start_datetime', '$end_datetime')";
    mysqli_query($conn, $insert_query);
    echo "Reservation successfully added!";
}

Keywords

PHP optimization reservation data double bookings time frame

Related Questions