SQL数据库未存储用户输入问题求助：注册表单数据无法写入

Hey there! Let's walk through why your user data isn't showing up in the users table in phpMyAdmin. This is a super common snag, so we'll break down the most likely fixes step by step.

1. First, Verify Your Database Connection is Working #

If your PHP script can't connect to the registration database at all, nothing will save. Double-check your connection code—here's a standard example for XAMPP:

$conn = mysqli_connect("localhost", "root", "", "registration");

// Add this to check for connection errors immediately
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

Make sure:

• MySQL is running in your XAMPP Control Panel (confirm both Apache and MySQL modules are started)
• Your username is root (XAMPP's default) and password is empty (unless you intentionally changed it)
• The database name registration is spelled exactly as you created it in phpMyAdmin

2. Check Your Form & POST Data Handling #

• Ensure your HTML form uses method="POST" (not GET) and the action attribute points to the correct PHP script that handles the insertion.
• Confirm you're correctly grabbing form values: if your input has name="full_name", you need to use $_POST['full_name'] (no typos between input names and your PHP variables!).
• Add a check to only run the insert logic when the form is actually submitted:

if (isset($_POST['submit'])) {
    // Your insert code goes here
}

3. Fix Your SQL Insert Statement #

Most often, the issue is a syntax error in your INSERT query. Let's cover the common mistakes:

• Missing quotes around string values: MySQL requires string fields (like name, email) to be wrapped in single quotes.
• Typos in field/table names: Make sure column names in your query match exactly what's in your users table (e.g., if your table uses user_email instead of email, your query will fail silently).
• Use MySQL error reporting to see the exact issue: Add this right after running your query to get a clear error message:

$sql = "INSERT INTO users (name, username, email, password) VALUES ('$name', '$username', '$email', '$password')";

if (mysqli_query($conn, $sql)) {
    header("Location: login.php");
    exit(); // Always add exit() after header redirect to stop script execution
} else {
    echo "Error inserting data: " . mysqli_error($conn); // This will tell you exactly what's broken
}

Pro tip: Use prepared statements instead of directly inserting user input—it's safer and avoids syntax issues from special characters:

$stmt = $conn->prepare("INSERT INTO users (name, username, email, password) VALUES (?, ?, ?, ?)");
$stmt->bind_param("ssss", $name, $username, $email, $password);
$stmt->execute();

4. Check for Redirect Issues #

If you're redirecting to the login page with header("Location: login.php"), make sure you add exit() immediately after. Without it, the script might continue running and hit an error that prevents the insert from completing.

5. Enable PHP Error Reporting #

Sometimes PHP errors (like undefined variables) are silently failing your script. Add these lines at the top of your PHP file to see all errors:

error_reporting(E_ALL);
ini_set('display_errors', 1);

Once you work through these steps, you'll almost certainly find the root cause. If you share your actual form and PHP code, we can narrow it down even further!

内容的提问来源于stack exchange，提问作者user9435526