如何用PHP将数组数据插入MySQL？现有插入代码无法运行求助

Let’s walk through the common issues breaking your code and fix it step by step.

1. Make Sure Your Form Sends Arrays #

First, if your HTML form inputs don’t use square brackets ([]), PHP won’t receive them as arrays. Double-check your form fields look like this:

<input type="text" name="fname[]" placeholder="First Name">
<input type="text" name="lname[]" placeholder="Last Name">
<!-- Repeat these for each name entry -->

Without the [], $_POST['fname'] will be a single string instead of an array, which immediately breaks your loop.

2. Validate Input Arrays Before Looping #

You need to confirm both arrays exist, aren’t empty, and have matching lengths to avoid index errors:

// Check for required data
if (!isset($_POST['fname'], $_POST['lname']) || empty($_POST['fname']) || empty($_POST['lname'])) {
    die("Error: Missing name data");
}

$fname = $_POST['fname'];
$lname = $_POST['lname'];

// Ensure first and last name arrays are the same length
if (count($fname) !== count($lname)) {
    die("Error: Mismatched number of first and last names");
}

3. Use Prepared Statements (Fixes Syntax & Security Issues) #

Your original code likely uses unsafe string concatenation for the SQL query—this causes syntax errors (e.g., names with apostrophes like "O'Neil") and exposes you to SQL injection. Switch to mysqli prepared statements:

// Verify your database connection is valid
if (!$con) {
    die("Database connection failed: " . mysqli_connect_error());
}

// Prepare the INSERT statement once (reuse for each entry)
$stmt = mysqli_prepare($con, "INSERT INTO your_table_name (firstname, lastname) VALUES (?, ?)");
if (!$stmt) {
    die("Prepare failed: " . mysqli_error($con));
}

// Bind parameters (s = string type)
mysqli_stmt_bind_param($stmt, "ss", $firstname, $lastname);

// Loop through each name pair
foreach ($fname as $index => $firstname) {
    $lastname = $lname[$index];
    
    // Execute the statement for this entry
    if (!mysqli_stmt_execute($stmt)) {
        echo "Error inserting entry $index: " . mysqli_stmt_error($stmt) . "<br>";
    } else {
        echo "Entry $index inserted successfully<br>";
    }
}

// Clean up resources
mysqli_stmt_close($stmt);
mysqli_close($con);

Replace your_table_name with your actual database table name.

4. Quick Debugging Tips #

• Print the arrays to confirm they’re structured correctly: var_dump($fname, $lname);
• Check for connection errors with mysqli_connect_error()
• Always check for statement execution errors using mysqli_stmt_error($stmt)

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