if ($status == "success") {

    $name = $_POST["firstname"] ?? '';
    $email = $_POST["email"] ?? '';
    $phone = $_POST["phone"] ?? '';
    $destination = $_POST["udf1"] ?? '';
    $travel_date = $_POST["udf2"] ?? '';
    $address = $_POST["udf3"] ?? '';

    $stmt = $conn->prepare("INSERT INTO bookings (txnid,name,email,phone,destination,travel_date,address,amount,payment_status) VALUES (?,?,?,?,?,?,?,?,?)");

    $payment_status = "success";

    $stmt->bind_param("sssssssss",
        $txnid,
        $name,
        $email,
        $phone,
        $destination,
        $travel_date,
        $address,
        $amount,
        $payment_status
    );

    $stmt->execute();

    echo "<h2>Payment Successful ✅</h2>";
    echo "Transaction ID: " . $txnid;
}