Edit File - submit_form.php

<?php
include "../admin/includes/db.php";

// Collect POST data
$subject = $_POST['your-subject'] ?? '';
$company = $_POST['company'] ?? '';
$name = $_POST['your-name'] ?? '';
$country = $_POST['countries'] ?? '';
$email = $_POST['your-email'] ?? '';
$mobile = $_POST['tel-759'] ?? '';
$whatsapp = $_POST['Facebook'] ?? '';
$products = isset($_POST['like']) ? implode(", ", $_POST['like']) : '';
$message = $_POST['neirong'] ?? '';
$ip = $_SERVER['REMOTE_ADDR'];

// Insert into DB
$sql = "INSERT INTO contact_form 
  (subject, company, name, country, email, mobile, whatsapp, products, message, ip) 
  VALUES 
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";

$stmt = $conn->prepare($sql);
$stmt->bind_param("ssssssssss", $subject, $company, $name, $country, $email, $mobile, $whatsapp, $products, $message, $ip);

if ($stmt->execute()) {
  echo "<script>
    alert('Thank you! Your message has been submitted successfully.');
    window.location.href = 'index.html';
  </script>";
} else {
  echo "Error: " . $stmt->error;
}

$stmt->close();
$conn->close();
?>

Kembali