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);
}

// 查询数据
$sql = "SELECT * FROM emails";
$result = $conn->query($sql);

// 数据处理
$emailArray = array();
while ($row = $result->fetch_assoc()) {
    $email = $row['email'];
    $name = $row['name'];
    $address = $row['address'];

    // 合并数据
    if (array_key_exists($email, $emailArray)) {
        $emailArray[$email]['name'] .= ', ' . $name;
        $emailArray[$email]['address'] .= ', ' . $address;
    } else {
        $emailArray[$email] = array('name' => $name, 'address' => $address);
    }
}

// 删除重复数据
foreach ($emailArray as $email => $data) {
    $name = $data['name'];
    $address = $data['address'];

    // 保留其他相关值
    // ...

    // 更新数据库
    $sql = "UPDATE emails SET name='$name', address='$address' WHERE email='$email'";
    $conn->query($sql);
}

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