How can PHP be used to insert multiple values into a database from an array?

When inserting multiple values into a database from an array in PHP, you can use a loop to iterate through the array and execute an INSERT query for each value. This allows you to efficiently insert all the values from the array into the database without having to manually write out each INSERT statement. 

// Sample array of values to be inserted into the database
$values = ['value1', 'value2', 'value3'];

// Establish a database connection
$connection = new mysqli('localhost', 'username', 'password', 'database');

// Loop through the array and insert each value into the database
foreach ($values as $value) {
    $query = "INSERT INTO table_name (column_name) VALUES ('$value')";
    $result = $connection->query($query);
    
    if (!$result) {
        echo "Error inserting value: " . $connection->error;
    }
}

// Close the database connection
$connection->close();

Keywords

PHP database array insert values

Related Questions