In PHP content management, how do I store results in a database?

This example demonstrates how to collect input from a form and store it in a MySQL database using PHP.

Name: Submit

connect_error) { die("Connection failed: " . $conn->connect_error); } // Prepare and bind $stmt = $conn->prepare("INSERT INTO users (name) VALUES (?)"); $stmt->bind_param("s", $name); // "s" indicates the type is string // Set parameters and execute $name = $_POST['name']; $stmt->execute(); echo "New record created successfully"; $stmt->close(); $conn->close(); } ?>