Edit File - save_timings.php

<?php
include("config.php"); // your DB connection

foreach ($_POST['status'] as $day => $status) {
    $open_time = $_POST['open_time'][$day] ?? null;
    $close_time = $_POST['close_time'][$day] ?? null;

// If status is not 'open', clear times
    if ($status != 'open') {
        $open_time = null;
        $close_time = null;
    }

// Check if row exists
    $stmt = $conn->prepare("SELECT sno FROM store_timing WHERE day = ?");
    $stmt->bind_param("i", $day);
    $stmt->execute();
    $stmt->store_result();

if ($stmt->num_rows > 0) {
        // Update existing
        $stmt = $conn->prepare("UPDATE store_timing SET status=?, open_time=?, close_time=? WHERE day=?");
        $stmt->bind_param("sssi", $status, $open_time, $close_time, $day);
    } else {
        // Insert new
        $stmt = $conn->prepare("INSERT INTO store_timing (day, status, open_time, close_time) VALUES (?, ?, ?, ?)");
        $stmt->bind_param("isss", $day, $status, $open_time, $close_time);
    }
    $stmt->execute();
}

echo "<script>
    alert('Opening hours updated successfully!');
    window.location.href = 'timings.php';
</script>";
?>

Kembali