if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Connect to database $conn = mysqli_connect('localhost', 'username', 'password', 'database_name'); // Retrieve form data $name = $_POST['name']; $email = $_POST['email']; $message = $_POST['message']; // Prepare SQL query $sql = "INSERT INTO contacts (name, email, message) VALUES ('$name', '$email', '$message')"; // Execute SQL query mysqli_query($conn, $sql); // Close database connection mysqli_close($conn); }
if ($_SERVER['REQUEST_METHOD'] == 'POST') { // Connect to database $conn = new PDO('mysql:host=localhost;dbname=database_name', 'username', 'password'); // Retrieve form data $name = $_POST['name']; $email = $_POST['email']; $message = $_POST['message']; // Prepare SQL query $stmt = $conn->prepare("INSERT INTO contacts (name, email, message) VALUES (:name, :email, :message)"); // Bind parameters $stmt->bindParam(':name', $name); $stmt->bindParam(':email', $email); $stmt->bindParam(':message', $message); // Execute SQL query $stmt->execute(); // Close database connection $conn = null; }In this example, we use PHP self insert code to handle a form submission for a contact form. This code uses PDO to connect to the database and prepares an SQL query with placeholders and bind parameters. Package library: PDO