starinfolab/codecraft-conductor-wizard
0
1```php2<?php3// Database connection4$db = new mysqli('localhost', 'root', '', 'portfolio_db');5if ($db->connect_error) {6 die("Connection failed: " . $db->connect_error);7}8 9// Process form submission10if ($_SERVER['REQUEST_METHOD'] == 'POST') {11 $name = $db->real_escape_string($_POST['name']);12 $email = $db->real_escape_string($_POST['email']);13 $message = $db->real_escape_string($_POST['message']);14 15 $sql = "INSERT INTO contact_submissions (name, email, message, created_at) 16 VALUES ('$name', '$email', '$message', NOW())";17 18 if ($db->query($sql) === TRUE) {19 header('Location: index.html?contact=success#contact');20 } else {21 header('Location: index.html?contact=error#contact');22 }23 exit;24}25```