1#@!#!123s

��JFIF�� 1#@!#!123s

: / home / earnlouq / kobilz.co.uk /

Filename : sync-available-times.php

back

<?php
     include('../config/xconfig.php');

     // Reset booking_count to 0
     $stmt = $con->prepare("UPDATE available_times SET booking_count = 0");
     $stmt->execute();
     $stmt->close();

     // Recalculate booking_count from bookings
     $stmt = $con->prepare("SELECT booking_date, booking_time, COUNT(*) as booking_count 
         FROM bookings 
         GROUP BY booking_date, booking_time");
     $stmt->execute();
     $result = $stmt->get_result();

     $update_stmt = $con->prepare("UPDATE available_times 
         SET booking_count = ? 
         WHERE booking_date = ? AND booking_time = ?");
     while ($row = $result->fetch_assoc()) {
         $date = $row['booking_date'];
         $time = $row['booking_time'];
         $count = $row['booking_count'];
         $update_stmt->bind_param("iss", $count, $date, $time);
         $update_stmt->execute();
     }
     $stmt->close();
     $update_stmt->close();

     echo "Available times synced with bookings.";
     ?>