How can an array be effectively used to store multiple values for insertion into a database table in a PHP script?

When inserting multiple values into a database table in a PHP script, an array can be effectively used to store these values before inserting them into the table. By looping through the array and executing the insertion query for each value, all values can be inserted efficiently. This approach helps in reducing the number of queries executed and improves the performance of the script. 

// Sample array of values to be inserted into the database table
$values = [
    ['John', 'Doe', 'john.doe@example.com'],
    ['Jane', 'Smith', 'jane.smith@example.com'],
    ['Alice', 'Johnson', 'alice.johnson@example.com']
];

// Connect to the database
$pdo = new PDO('mysql:host=localhost;dbname=mydatabase', 'username', 'password');

// Prepare the insertion query
$stmt = $pdo->prepare("INSERT INTO users (first_name, last_name, email) VALUES (?, ?, ?)");

// Loop through the array and execute the insertion query for each set of values
foreach ($values as $row) {
    $stmt->execute($row);
}

Keywords

array database table insertion PHP script multiple values

Related Questions