prepare("SELECT * FROM vehicles WHERE id = ?"); $stmt->execute([$id]); $vehicle = $stmt->fetch(PDO::FETCH_ASSOC); if (!$vehicle) { header('Location: admin_vehicles.php?error=notfound'); exit; } $name = $vehicle['name']; $type = $vehicle['type']; $capacity = $vehicle['capacity']; $price_per_day = $vehicle['price_per_day']; $is_available = $vehicle['is_available']; } catch (PDOException $e) { $errors[] = "Database error: " . $e->getMessage(); } if ($_SERVER['REQUEST_METHOD'] === 'POST') { $name = trim($_POST['name'] ?? ''); $type = trim($_POST['type'] ?? ''); $capacity = trim($_POST['capacity'] ?? ''); $price_per_day = trim($_POST['price_per_day'] ?? ''); $is_available = isset($_POST['is_available']) ? 1 : 0; if (empty($name)) { $errors[] = 'Vehicle name is required.'; } if (empty($type)) { $errors[] = 'Vehicle type is required.'; } if (!filter_var($capacity, FILTER_VALIDATE_INT, ["options" => ["min_range" => 1]])) { $errors[] = 'Capacity must be a positive number.'; } if (!filter_var($price_per_day, FILTER_VALIDATE_INT, ["options" => ["min_range" => 0]])) { $errors[] = 'Price must be a non-negative number.'; } if (empty($errors)) { try { $sql = "UPDATE vehicles SET name = ?, type = ?, capacity = ?, price_per_day = ?, is_available = ? WHERE id = ?"; $stmt = $pdo->prepare($sql); $stmt->execute([$name, $type, $capacity, $price_per_day, $is_available, $id]); header("Location: admin_vehicles.php?success=2"); exit; } catch (PDOException $e) { $errors[] = "Database error: " . $e->getMessage(); } } } require_once 'includes/admin_sidebar.php'; ?>

Edit Vehicle

Update the details for the vehicle below.

Edit Vehicle

Vehicle Details