How to insert into database with multiple array in php?
How to insert into database with multiple array in php?
1 answer
by
daisha ,
5 months ago
@kadin
To insert data into a database with multiple arrays in PHP, you can follow these steps:
- Establish a database connection using PDO or MySQLi.
- Prepare your SQL INSERT statement with placeholders for the values you want to insert.
- Loop through your arrays and execute the INSERT statement for each set of values.
- Bind the values from the arrays to the placeholders in the INSERT statement.
- Execute the prepared statement.
Here's an example using PDO:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
<?php
// Assuming you have already established a database connection using PDO
// Arrays containing the data to insert
$array1 = array("John", "Doe", "25");
$array2 = array("Jane", "Smith", "30");
// SQL INSERT statement
$sql = "INSERT INTO your_table (first_name, last_name, age) VALUES (?, ?, ?)";
// Prepare the statement
$stmt = $pdo->prepare($sql);
// Loop through the arrays and execute the INSERT statement
foreach ([$array1, $array2] as $array) {
// Bind the values from the array to the placeholders
$stmt->bindValue(1, $array[0]);
$stmt->bindValue(2, $array[1]);
$stmt->bindValue(3, $array[2]);
// Execute the statement
$stmt->execute();
}
// Close the database connection
$pdo = null;
?>
|
Note: This example assumes you have already established a database connection using PDO. You'll need to modify the code accordingly if you're using MySQLi or a different database connection method.