How insert to mysql many rows using php?

 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
28
29
30

// Connection to MySQL database
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Array of rows to be inserted
$rows = array(
    array('John', 'Doe', 25),
    array('Jane', 'Smith', 30),
    // Add more rows as needed
);

// Prepare and execute the SQL insert statement
$sql = 'INSERT INTO your_table_name (first_name, last_name, age) VALUES (?, ?, ?)';
$stmt = $conn->prepare($sql);

foreach ($rows as $row) {
    $stmt->bind_param('ssi', $row[0], $row[1], $row[2]);
    $stmt->execute();
}

// Close the prepared statement and database connection
$stmt->close();
$conn->close();