How can PHP developers efficiently iterate through form data arrays to insert multiple records into a database table?

When inserting multiple records into a database table from form data arrays in PHP, developers can efficiently iterate through the arrays using a loop structure like foreach. Within the loop, developers can construct and execute SQL INSERT statements for each record to be inserted into the database table. 

// Assuming $formData is an array of arrays containing form data
foreach ($formData as $data) {
    // Construct an SQL INSERT statement using the form data
    $sql = "INSERT INTO table_name (column1, column2, column3) VALUES ('" . $data['value1'] . "', '" . $data['value2'] . "', '" . $data['value3'] . "')";
    
    // Execute the SQL INSERT statement
    $result = mysqli_query($connection, $sql);
    
    // Check for errors or handle the result as needed
    if (!$result) {
        echo "Error inserting record: " . mysqli_error($connection);
    }
}

Keywords

PHP form data arrays iteration database table multiple records

Related Questions