数组导入mysql数据库

<?php
// 连接到MySQL数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败：" . $conn->connect_error);
}

// 定义要插入的数组
$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com'),
    array('Mike', 'Johnson', 'mike@example.com')
);

// 遍历数组并将数据插入到数据库中
foreach ($data as $row) {
    $sql = "INSERT INTO users (first_name, last_name, email) VALUES ('{$row[0]}', '{$row[1]}', '{$row[2]}')";
    if ($conn->query($sql) === TRUE) {
        echo "数据插入成功！";
    } else {
        echo "数据插入失败：" . $conn->error;
    }
}

// 关闭数据库连接
$conn->close();
?>