将PHP多维数组循环插入到mysql中

$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";

// 使用mysqli扩展连接到MySQL数据库
$conn = new mysqli($servername, $username, $password, $dbname);

// 使用PDO扩展连接到MySQL数据库
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

$sql = "INSERT INTO users (name, email) VALUES (?, ?)";

$data = [
    ['John Doe', 'john@example.com'],
    ['Jane Smith', 'jane@example.com'],
    ['Bob Johnson', 'bob@example.com']
];

$stmt = $conn->prepare($sql);

foreach ($data as $row) {
    $stmt->bind_param("ss", $row[0], $row[1]);
    $stmt->execute();
}

$stmt->close();

$conn->close(); // 对于mysqli扩展
unset($conn); // 对于PDO扩展