php - sql语句放入数组导致重复

Question

这是我第一次使用这个网站。我需要一些帮助。当我运行这段代码并获得输出时，我得到了重复的数据行。因此，例如，根据他参加事件的年数，某个成员可能会出现在名单上 3 到 4 次。我需要以某种方式将任何类似的数据组合成一行，如果这有意义的话？所以 John Doe 不应该在他离开的这么多年里只出现一次 7 次。

$query_mem = "SELECT m.id, m.prefix, m.first_name, m.middle_name, m.last_name, m.suffix, m.member_class, m.jurisdiction_associated,
event.year,
m_event.attend 
FROM members AS m, event AS event, members_event AS m_event $where
AND m.member_class IN (1,3)
AND m.id = m_event.codigo_usuario AND m_event.type_event = event.codigo_inscricao
ORDER BY event.year, m.jurisdiction_associated, m.last_name, m.first_name";
$retorno_mem = $conexao->query($query_mem);
if(($conexao->errorCode() == '0') && ($retorno_mem->rowCount() > 0))
{
    while($registros_mem = $retorno_mem->fetch(PDO::FETCH_ASSOC))
    {
        $prefix=$fname=$mname=$lname=$suffix=$address_1=$address_2=$city=$state=$zip=$country=$org=$campaign=NULL;

        $member_id          = ($registros_mem["id"]);
        $prefix             = ($registros_mem["prefix"]);
        $fname              = ($registros_mem["first_name"]);
        $mname              = ($registros_mem["middle_name"]);
        $lname              = ($registros_mem["last_name"]);
        $suffix             = ($registros_mem["suffix"]);
        $class              = getMemberClassName($conexao,$registros_mem["member_class"]);
        $jurisdiction   = getJurisdictionName($conexao,$registros_mem["jurisdiction_associated"]."000");
        $year                   = ($registros_mem["year"]);
        $attendance         = getMemberAttendanceName($conexao,$registros_mem["attend"]);


        $data1[] = array(
        ''.utf8_encode((int)$member_id).'',
        ''.utf8_encode($prefix).'',
        ''.utf8_encode($fname).'',
        ''.utf8_encode($mname).'',
        ''.utf8_encode($lname).'',
        ''.utf8_encode($suffix).'',
        ''.utf8_encode($class).'',
        ''.utf8_encode($jurisdiction).'',
        ''.utf8_encode($year).'',
        ''.utf8_encode($attendance).'',
                );
    }
}

Answer 1

您可以使用成员的 ID 作为数组键来查看他是否已经去过，如果已经去过，只需将其添加到 year 字段即可。像这样:

while($registros_mem = $retorno_mem->fetch(PDO::FETCH_ASSOC))
{
    if ( ! array_key_exists( $registros_mem['id'], $data1)
    {
        // We need to make year an array so it can hold multiple years.
        $registros_mem['year'] = [$registros_mem['year']];
        $data1[$registros_mem['id']] = $registros_mem;
    } else {
        $data1[$registros_mem['id']]['year'][] = $registros_mem['year'];
    }
}