📁 File Manager
Editing:
/home/wvl7mof7402e/www/wingstourandtravels.com/process_inquiry.php
<?php // ====================================================== // CENTRAL ENQUIRY FORM PROCESSOR // ====================================================== require_once __DIR__ . '/db_config.php'; // Form submit hua hai ya nahi check karein if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['submit_inquiry'])) { // Inputs ko sanitize karein (SQL Injection aur XSS protection) $pkg_title = mysqli_real_escape_string($conn, trim($_POST['package'] ?? 'Chardham Helicopter Package')); $name = mysqli_real_escape_string($conn, trim($_POST['name'] ?? '')); $email = mysqli_real_escape_string($conn, trim($_POST['email'] ?? '')); $phone = mysqli_real_escape_string($conn, trim($_POST['phone'] ?? '')); $passengers = intval($_POST['passengers'] ?? 1); $travel_date = mysqli_real_escape_string($conn, trim($_POST['travel_date'] ?? '')); $message = mysqli_real_escape_string($conn, trim($_POST['message'] ?? '')); // Validation Check: Mandatory fields khali na hon if (empty($name) || empty($email) || empty($phone) || empty($travel_date)) { echo "<script> alert('Please fill all required fields.'); window.history.back(); </script>"; exit(); } // Database me Insertion (enquiries table) $stmt = $conn->prepare("INSERT INTO enquiries (package, name, email, phone, passengers, travel_date, message) VALUES (?, ?, ?, ?, ?, ?, ?)"); $stmt->bind_param("ssssiss", $pkg_title, $name, $email, $phone, $passengers, $travel_date, $message); if ($stmt->execute()) { $stmt->close(); $conn->close(); // WhatsApp Redirection Logic $whatsapp_number = "917428465992"; // Apna WhatsApp Number Yahan Update Karein $text = "*New Enquiry Received!*\n\n"; $text .= "*Package:* " . $pkg_title . "\n"; $text .= "*Name:* " . $name . "\n"; $text .= "*Email:* " . $email . "\n"; $text .= "*Phone:* " . $phone . "\n"; $text .= "*Passengers:* " . $passengers . "\n"; $text .= "*Travel Date:* " . $travel_date . "\n"; $text .= "*Message:* " . $message; $encoded_text = urlencode($text); $whatsapp_url = "https://api.whatsapp.com/send?phone=" . $whatsapp_number . "&text=" . $encoded_text; // Fast Header Redirection header("Location: " . $whatsapp_url); exit(); } else { $stmt->close(); $conn->close(); echo "<script> alert('Database Error: Unable to save your enquiry. Please try again.'); window.history.back(); </script>"; exit(); } } else { // Agar koi direct is URL par aane ki koshish kare toh Home Page par bhejein header("Location: index.php"); exit(); } ?>
Save
Cancel