alert('Please fill in all required fields.'); window.history.back();";
exit;
}
// Insert into database
$sql = "INSERT INTO leads (customer_name, phone_number, email, source, trip_type, origin, destination, departure_date, return_date, passengers, message)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
if ($stmt) {
$stmt->bind_param("sssssssssis", $customer_name, $phone_number, $email, $source, $trip_type, $origin, $destination, $departure_date, $return_date, $passengers, $message);
if ($stmt->execute()) {
echo "";
}
else {
echo "Error: " . $sql . "
" . $conn->error;
}
$stmt->close();
}
else {
echo "Error preparing statement: " . $conn->error;
}
$conn->close();
}
else {
header("Location: index.php");
exit();
}
?>