PDO::ERRMODE_EXCEPTION] ); // Create table if not exists $pdo->exec("CREATE TABLE IF NOT EXISTS contact_inquiries ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(255) NOT NULL, company VARCHAR(255), phone VARCHAR(50), subject VARCHAR(255), inquiry TEXT NOT NULL, ip_address VARCHAR(45), user_agent TEXT, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP )"); // Insert inquiry $stmt = $pdo->prepare("INSERT INTO contact_inquiries (name, email, company, phone, subject, inquiry, ip_address, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"); $stmt->execute([ $name, $email, $company, $phone, $subject, $inquiry, $_SERVER['REMOTE_ADDR'] ?? '', $_SERVER['HTTP_USER_AGENT'] ?? '' ]); // --- PHP mail() notification (primary) --- $notifyTo = 'hello@vcb-ai.online'; $mailSubject = '[VCB Contact] ' . ($subject ?: 'General Inquiry') . ' β€” from ' . $name; $mailBody = "New contact form submission\r\n"; $mailBody .= "===========================\r\n"; $mailBody .= "Name: $name\r\n"; $mailBody .= "Email: $email\r\n"; $mailBody .= "Company: " . ($company ?: 'Not provided') . "\r\n"; $mailBody .= "Phone: " . ($phone ?: 'Not provided') . "\r\n"; $mailBody .= "Subject: " . ($subject ?: 'Not provided') . "\r\n\r\n"; $mailBody .= "Message:\r\n$inquiry\r\n\r\n"; $mailBody .= "IP: " . ($_SERVER['REMOTE_ADDR'] ?? 'unknown') . "\r\n"; $mailHeaders = "From: noreply@vcb-ai.online\r\n"; $mailHeaders .= "Reply-To: $email\r\n"; $mailHeaders .= "X-Mailer: PHP/" . phpversion(); @mail($notifyTo, $mailSubject, $mailBody, $mailHeaders); $configStmt = $pdo->prepare("SELECT key_name, key_value FROM config_keys WHERE is_active = 1"); $configStmt->execute(); $config = []; while ($row = $configStmt->fetch(PDO::FETCH_ASSOC)) { $config[$row['key_name']] = $row['key_value']; } if (!empty($config['emailjs_service_id'])) { $emailData = [ 'service_id' => $config['emailjs_service_id'], 'template_id' => $config['emailjs_template_id'], 'user_id' => $config['emailjs_public_key'], 'accessToken' => $config['emailjs_private_key'], 'template_params' => [ 'name' => $name, 'email' => $config['admin_email'], 'from_name' => $name, 'from_email' => $email, 'company' => $company ?: 'Not provided', 'phone' => $phone ?: 'Not provided', 'subject' => $subject ?: 'Contact Form', 'message' => $inquiry, 'form_type' => 'Contact Inquiry', 'reply_to' => $email ] ]; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://api.emailjs.com/api/v1.0/email/send'); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($emailData)); curl_setopt($ch, CURLOPT_HTTPHEADER, ['Content-Type: application/json']); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_TIMEOUT, 10); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0); $emailResult = curl_exec($ch); $emailError = curl_error($ch); curl_close($ch); if ($emailError) { error_log('EmailJS Error: ' . $emailError); } } $message = 'Thank you for reaching out! We\'ll get back to you within 24 hours.'; $messageType = 'success'; // Clear form $name = $email = $company = $phone = $subject = $inquiry = ''; } catch (PDOException $e) { $message = 'Sorry, there was an error processing your request. Please try again later.'; $messageType = 'error'; error_log('DB Error: ' . $e->getMessage()); } } } ?> Contact Us | VCB-AI
VCB Logo arrow_back Home
mail

Get in Touch

Have a question about our AI solutions? We'd love to hear from you.

Or reach us directly:

mail info@vcb-ai.online
verified POPIA Compliant
schedule 24hr Response
location_on Based in SA