prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows == 0) {
echo "Lead not found.";
exit;
}
$lead = $result->fetch_assoc();
// Handle Status Update
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_POST['update_status'])) {
$new_status = $_POST['status'];
$update_sql = "UPDATE leads SET status = ? WHERE id = ?";
$update_stmt = $conn->prepare($update_sql);
$update_stmt->bind_param("si", $new_status, $id);
$update_stmt->execute();
header("Location: view_lead.php?id=$id");
exit;
}
?>
View Lead #<?php echo $id; ?> - Trips Taker
Status:
Customer Name:
Phone Number:
Email:
Trip Type:
Origin:
Destination:
Departure Date:
Return Date:
Passengers:
Message:
Submitted On:
Update Status