cancel_order.php

<?php
require_once "conn.php";
session_start();

if (!isset($_SESSION["customer_id"])) {
    echo "<script>alert('Please login');";
    echo "window.location.href='index.php';</script>";
    exit; // Stop further execution
} else {
    if (isset($_GET['order_id'])) {
        $oid = $_GET['order_id'];
        // echo $oid;

        $stmt = $conn->prepare("SELECT * FROM orders WHERE OID =?");
        $stmt->bind_param("i", $oid);
        $stmt->execute();
        $result = $stmt->get_result();

        if ($result->num_rows > 0) {
            while ($row = $result->fetch_assoc()) {
                $order_status = $row['order_status'];
            }
        }
        if ($order_status === 'confirmed') {
            $order_status = 'cancelled';
            $delivery_status = 'Not deliverable';
            $cancel_time = time();
            $stmt1 = $conn->prepare("UPDATE orders SET order_status=?,delivery_status=?, delivery_time=? WHERE OID=?");
            $stmt1->bind_param("sssi", $order_status, $delivery_status, $cancel_time, $oid);
            $stmt1->execute();
            require_once "cancel_order.html";
        } else {
            echo "<script>alert('order already cancelled');";
            echo "window.history.back();</script>";
        }
    }
}