query("CREATE DATABASE IF NOT EXISTS $db");
$conn->select_db($db);
// Create table if not exists
$conn->query("CREATE TABLE IF NOT EXISTS contact_requests (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100),
phone VARCHAR(20),
subject VARCHAR(150),
message TEXT,
type ENUM('contact','ad_request'),
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)");
$message_status = "";
// ================= FORM SUBMIT =================
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$name = $_POST['name'];
$email = $_POST['email'];
$phone = $_POST['phone'];
$subject = $_POST['subject'];
$message = $_POST['message'];
$type = $_POST['type'];
$stmt = $conn->prepare("INSERT INTO contact_requests (name, email, phone, subject, message, type) VALUES (?, ?, ?, ?, ?, ?)");
$stmt->bind_param("ssssss", $name, $email, $phone, $subject, $message, $type);
if ($stmt->execute()) {
$message_status = "✅ Submitted successfully!";
} else {
$message_status = "❌ Error: " . $stmt->error;
}
$stmt->close();
}
?>
DFC Contact & Cause Submission
Contact / Submit Your Cause