PHP/CakePHP中循环数据去重与项目统计教程

<?php
// 假设 $projects 数组包含从数据库或其他来源获取的项目数据
// 例如：
// $projects = [
//     ['Project' => ['country_id' => 1, 'country_name' => 'USA', 'project_name' => 'Project A']],
//     ['Project' => ['country_id' => 2, 'country_name' => 'Canada', 'project_name' => 'Project B']],
//     ['Project' => ['country_id' => 1, 'country_name' => 'USA', 'project_name' => 'Project C']],
//     ['Project' => ['country_id' => 3, 'country_name' => 'Mexico', 'project_name' => 'Project D']],
//     ['Project' => ['country_id' => 2, 'country_name' => 'Canada', 'project_name' => 'Project E']],
// ];

$country_aggregated_data = [];

foreach ($projects as $project) {
    $country_id = $project['Project']['country_id'];
    // 尝试获取国家名称。如果数据中没有country_name字段，可以设置为默认值或通过其他方式获取。
    $country_name = isset($project['Project']['country_name']) ? $project['Project']['country_name'] : '未知国家';

    // 如果该国家ID尚未被记录，则初始化其计数和名称
    if (!isset($country_aggregated_data[$country_id])) {
        $country_aggregated_data[$country_id] = [
            'count' => 0,
            'name' => $country_name // 存储国家名称，确保每个国家ID只存储一次
        ];
    }
    // 增加该国家的项目计数
    $country_aggregated_data[$country_id]['count']++;
}

// 此时，$country_aggregated_data 数组结构可能如下：
// [
//     1 => ['count' => 2, 'name' => 'USA'],
//     2 => ['count' => 2, 'name' => 'Canada'],
//     3 => ['count' => 1, 'name' => 'Mexico'],
// ]
?>

<table>
    <thead>
        <tr>
            <th>国家 ID</th>
            <th>国家名称</th>
            <th>项目数量</th>
        </tr>
    </thead>
    <tbody>
    <?php 
    // 遍历聚合后的数据
    foreach ($country_aggregated_data as $country_id => $data): 
    ?>
        <tr>
            <td style="width: 30%"><?php echo $country_id; ?></td>
            <td style="width: 30%"><?php echo htmlspecialchars($data['name']); ?></td>
            <td style="width: 30%"><?php echo $data['count']; ?></td>
        </tr>
    <?php 
    endforeach; 
    ?>
    </tbody>
</table>

<?php
// 假设 $projects 数组是您从CakePHP或其他地方获取的项目列表
// 示例数据（实际应用中此数据可能来自数据库查询结果）
$projects = [
    ['Project' => ['country_id' => 1, 'country_name' => '美国', 'project_title' => '纽约市项目']],
    ['Project' => ['country_id' => 2, 'country_name' => '加拿大', 'project_title' => '多伦多基础设施']],
    ['Project' => ['country_id' => 1, 'country_name' => '美国', 'project_title' => '加州科技园区']],
    ['Project' => ['country_id' => 3, 'country_name' => '墨西哥', 'project_title' => '坎昆旅游开发']],
    ['Project' => ['country_id' => 2, 'country_name' => '加拿大', 'project_title' => '温哥华住宅']],
    ['Project' => ['country_id' => 1, 'country_name' => '美国', 'project_title' => '德州能源项目']],
];

// 步骤一：数据聚合
$country_aggregated_data = [];

foreach ($projects as $project) {
    $country_id = $project['Project']['country_id'];
    $country_name = isset($project['Project']['country_name']) ? $project['Project']['country_name'] : '未知国家';

    if (!isset($country_aggregated_data[$country_id])) {
        $country_aggregated_data[$country_id] = [
            'count' => 0,
            'name' => $country_name
        ];
    }
    $country_aggregated_data[$country_id]['count']++;
}
?>

<table>
    <thead>
        <tr>
            <th>国家 ID</th>
            <th>国家名称</th>
            <th>项目数量</th>
        </tr>
    </thead>
    <tbody>
    <?php 
    // 步骤二：去重展示
    foreach ($country_aggregated_data as $country_id => $data): 
    ?>
        <tr>
            <td style="width: 30%"><?php echo $country_id; ?></td>
            <td style="width: 30%"><?php echo htmlspecialchars($data['name']); ?></td>
            <td style="width: 30%"><?php echo $data['count']; ?></td>
        </tr>
    <?php 
    endforeach; 
    ?>
    </tbody>
</table>