插入批量php mysql，并检查重复和字段的复制值

<?php
// 连接数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";
$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('Bob', 'Johnson', 'bob@example.com')
);

// 检查重复和字段的复制值
$uniqueFields = array('email');  // 需要检查重复的字段
$copyFields = array('firstname', 'lastname');  // 需要复制值的字段

// 构造 SQL 语句
$sql = "INSERT INTO your_table (firstname, lastname, email) VALUES";
$values = array();
foreach ($data as $row) {
    $values[] = "('" . $conn->real_escape_string($row[0]) . "', '" . $conn->real_escape_string($row[1]) . "', '" . $conn->real_escape_string($row[2]) . "')";
}
$sql .= implode(", ", $values);
$sql .= " ON DUPLICATE KEY UPDATE ";
$updates = array();
foreach ($copyFields as $field) {
    $updates[] = $field . " = VALUES(" . $field . ")";
}
$sql .= implode(", ", $updates);

// 执行 SQL 语句
if ($conn->query($sql) === TRUE) {
    echo "批量插入成功";
} else {
    echo "插入数据失败: " . $conn->error;
}

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