prepare("INSERT INTO phpmailer (name, email, phone, inquiry_type, message, created_at) VALUES (?, ?, ?, ?, ?, NOW())");
$stmt->bind_param("sssss", $name, $email, $phone, $inquiry_type, $message);
if (!$stmt->execute()) {
throw new Exception("Database insert failed: " . $stmt->error);
}
$stmt->close();
// Send email using PHPMailer
require 'phpmailer/PHPMailer.php';
require 'phpmailer/SMTP.php';
require 'phpmailer/Exception.php';
$mail = new PHPMailer\PHPMailer\PHPMailer(true);
// SMTP Configuration
$mail->isSMTP();
$mail->Host = $smtp_host;
$mail->SMTPAuth = true;
$mail->Username = $smtp_user;
$mail->Password = $smtp_pass;
$mail->SMTPSecure = PHPMailer\PHPMailer\PHPMailer::ENCRYPTION_STARTTLS;
$mail->Port = $smtp_port;
// Email content
$mail->setFrom($smtp_user, 'Contact Form System');
$mail->addAddress($owner_email);
$mail->addReplyTo($email, $name);
$mail->isHTML(true);
$mail->Subject = "New Contact Form Submission: $inquiry_type";
$mail->Body = "
🏷️ Inquiry Type
$inquiry_type
💬 Message
" . nl2br($message) . "
";
$mail->AltBody = "New contact form submission from $name ($email)\n\nPhone: $phone\nInquiry Type: $inquiry_type\n\nMessage:\n$message";
$mail->send();
// Success message
$_SESSION['message'] = '✅ Thank you! Your message has been sent successfully. We will contact you soon.';
$_SESSION['msg_type'] = 'success';
// Regenerate CAPTCHA
$_SESSION['captcha'] = rand(1000, 9999);
} catch (Exception $e) {
$_SESSION['message'] = '❌ Error: ' . $e->getMessage();
$_SESSION['msg_type'] = 'error';
}
$conn->close();
header('Location: index.php');
exit();
?>