How can a PHP developer loop through an array and perform an insert for each element into a database?

To loop through an array and perform an insert for each element into a database, you can use a foreach loop to iterate over the array and execute an insert query for each element. Within the loop, you can dynamically construct the insert query using the current element's values. 

// Assuming $array is the array containing elements to be inserted into the database

foreach($array as $element) {
    // Construct your insert query using the current element's values
    $insertQuery = "INSERT INTO table_name (column1, column2) VALUES ('".$element['value1']."', '".$element['value2']."')";
    
    // Execute the insert query
    $result = mysqli_query($connection, $insertQuery);

    if(!$result) {
        echo "Error inserting element: " . mysqli_error($connection);
    }
}

Keywords

PHP array loop insert database

Related Questions