Hey there! Let's figure out why your PHP insertion code isn't working and fix it up. Here's a step-by-step breakdown of what to check and adjust:

1. First, Get the Exact MySQL Error Message #

Right now, your code only tells you the insertion failed—but not why. That's the biggest roadblock. Update your error handling to show the actual MySQL error, which will point you straight to the issue:

} else {
    $_SESSION['message'] = "User could not be added to the database! Error: " . $mysqli->error;
}

Also, make sure you're checking if the database connection itself worked (you might have missed this):

$mysqli = new MySQLi('127.0.0.1','root','','accounts');
// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

2. Check for Table Relationship (Foreign Key) Issues #

If your menubar table has foreign key links to other tables, inserting data might fail if you're not providing valid values for those foreign key fields. For example:

• If menubar has a user_id foreign key tied to a users table, you need to include that user_id in your INSERT statement, and the value must exist in the users table.
• Double-check your menubar table schema to confirm all required fields (including foreign keys) are being populated in your SQL query.

3. Fix HTML Form Structure Errors #

Looking at your HTML, there are unclosed and extra <tr> tags that could cause DOM issues (even if browsers tolerate it, it's best to fix):

• The first <tr> isn't closed properly before starting a new one
• There are extra </tr> tags at the end of the form

Here's the corrected form structure snippet:

<table align="center">
    <form method="post" action="" enctype="multipart/form-data" autocomplete="off">
        <tr>
            <td> Enter Menu Bar: </td>
            <td>
                <input type="text" placeholder="Personal Information" name="option1" required/>
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="text" placeholder="Career Aspirations" name="option2" required />
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="text" placeholder="Educational Background" name="option3" required />
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="text" placeholder="Skills" name="option4" required />
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="text" placeholder="Language Proficiency" name="option5" required />
            </td>
        </tr>
        <tr>
            <td></td>
            <td>
                <input type="text" placeholder="Job Preference" name="option6" required />
            </td>
        </tr>
        <tr>
            <td align="center">
                <input type="submit" name="login" value="register" class="btn-login"/>
            </td>
        </tr>
    </form>
</table>

4. Switch to Prepared Statements (Avoid SQL Injection & Syntax Errors) #

Your current code directly inserts user input into the SQL query, which is risky (SQL injection) and can break if any input has a single quote ('). Use prepared statements instead—they fix both issues:

if($_SERVER["REQUEST_METHOD"] == "POST") {
    $option1 = $_POST['option1'];
    $option2 = $_POST['option2'];
    $option3 = $_POST['option3'];
    $option4 = $_POST['option4'];
    $option5 = $_POST['option5'];
    $option6 = $_POST['option6'];

    // Prepare the SQL statement
    $stmt = $mysqli->prepare("INSERT INTO menubar(option1,option2,option3,option4,option5,option6) VALUES (?, ?, ?, ?, ?, ?)");
    // Bind parameters (ssssss means 6 string values)
    $stmt->bind_param("ssssss", $option1, $option2, $option3, $option4, $option5, $option6);

    if($stmt->execute()) {
        $_SESSION['message'] ='Registration successful! Added to the database!';
        header("location:confirmnormal.php");
        exit(); // Always exit after a header redirect
    } else {
        $_SESSION['message'] = "User could not be added to the database! Error: " . $stmt->error;
    }
    $stmt->close();
}

Next Steps #

1. Add the error logging code first—this will tell you exactly what's wrong (e.g., "column 'user_id' cannot be null" or "foreign key constraint fails").
2. Verify your menubar table schema matches the fields you're inserting.
3. Test the form again with the corrected code.

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