1#@!#!123s

��JFIF�� 1#@!#!123s
: / proc / self / root / home / earnlouq / kobilz.co.uk /
Filename : cancle_booking.php
back
<?php
     include('../config/xconfig.php');
     session_start();

     $booking_id = $_POST['booking_id'] ?? null;
     $user_id = $_SESSION['user_id'] ?? null;

     if (!$booking_id || !$user_id) {
         die("Invalid request.");
     }

     $con->begin_transaction();
     try {
         // Fetch booking details
         $stmt = $con->prepare("SELECT booking_date, booking_time FROM bookings WHERE id = ? AND user_id = ?");
         $stmt->bind_param("ii", $booking_id, $user_id);
         $stmt->execute();
         $booking = $stmt->get_result()->fetch_assoc();
         $stmt->close();

         if (!$booking) {
             throw new Exception("Booking not found.");
         }

         // Delete booking
         $stmt = $con->prepare("DELETE FROM bookings WHERE id = ? AND user_id = ?");
         $stmt->bind_param("ii", $booking_id, $user_id);
         $stmt->execute();
         $stmt->close();

         // Decrement booking_count
         $stmt = $con->prepare("UPDATE available_times SET booking_count = booking_count - 1 
             WHERE booking_date = ? AND booking_time = ? AND booking_count > 0");
         $stmt->bind_param("ss", $booking['booking_date'], $booking['booking_time']);
         $stmt->execute();
         $stmt->close();

         $con->commit();
         echo "Booking canceled successfully.";
     } catch (Exception $e) {
         $con->rollback();
         echo "Error: " . $e->getMessage();
     }
     ?>