将发布的PHP数组插入MYSQL

<?php
// 连接到MYSQL数据库
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

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

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 要插入的PHP数组
$data = array(
    array('John', 'Doe', 'john@example.com'),
    array('Jane', 'Smith', 'jane@example.com'),
    array('Bob', 'Johnson', 'bob@example.com')
);

// 创建INSERT语句
$sql = "INSERT INTO users (first_name, last_name, email) VALUES (?, ?, ?)";

// 准备并执行INSERT语句
$stmt = $conn->prepare($sql);
$stmt->bind_param("sss", $first_name, $last_name, $email);

foreach ($data as $row) {
    $first_name = $row[0];
    $last_name = $row[1];
    $email = $row[2];
    $stmt->execute();
}

$stmt->close();
$conn->close();
?>