prepare("SELECT * FROM shipment_details WHERE id = ?"); $stmt->execute([$shipment_id]); $shipment = $stmt->fetch(); if (!$shipment) { header('Location: service_requests.php'); exit; } $service_request_id = $shipment['service_request_id']; if ($_SERVER['REQUEST_METHOD'] === 'POST') { $carrier = trim($_POST['carrier']); $tracking_number = trim($_POST['tracking_number']); $shipment_date = trim($_POST['shipment_date']); if (empty($carrier) || empty($tracking_number) || empty($shipment_date)) { $error_message = "All fields are required."; } else { $stmt_update = $pdo->prepare( "UPDATE shipment_details SET carrier = ?, tracking_number = ?, shipment_date = ? WHERE id = ?" ); $stmt_update->execute([$carrier, $tracking_number, $shipment_date, $shipment_id]); header("Location: service_request_details.php?id=$service_request_id"); exit; } } } catch (PDOException $e) { die("Database error: " . $e->getMessage()); } ?>

Edit Shipment Details