数组插入到mysql数据库

<?php
// 连接到MySQL数据库
$conn = mysqli_connect("localhost", "username", "password", "database");

// 检查连接是否成功
if (!$conn) {
    die("连接失败: " . mysqli_connect_error());
}

// 准备数组数据
$data = array("John", "Doe", "john.doe@example.com");

// 准备SQL语句
$sql = "INSERT INTO users (firstname, lastname, email) VALUES (?, ?, ?)";

// 创建预处理语句
$stmt = mysqli_prepare($conn, $sql);

// 绑定参数
mysqli_stmt_bind_param($stmt, "sss", $data[0], $data[1], $data[2]);

// 执行预处理语句
mysqli_stmt_execute($stmt);

// 检查是否插入成功
if (mysqli_stmt_affected_rows($stmt) > 0) {
    echo "数据插入成功";
} else {
    echo "数据插入失败";
}

// 关闭连接
mysqli_stmt_close($stmt);
mysqli_close($conn);
?>