如何对所有出价相同的imp求和

Question

这里我想对所有[imp]求和，其中[ibid]相同。。使用php并将该值存储在变量中，如$cpc="sum of all cpc"和$cpm="sum ofall cpm"。。。有人能指导我怎么做吗我是新来的

$data=
Array
(
[0] => Array
(
[bid] => CPC
[imp] => 5566
)
[1] => Array
(
[bid] => CPC
[imp] => 9
)
[2] => Array
(
[bid] => CPM
[imp] => 442664
)
[3] => Array
(
[bid] => CPM
[imp] => 202321
)
[4] => Array
(
[bid] => CPM
[imp] => 16009
)

)

Answer 1

您可以使array与结果相关联

但每次您都需要检查此bid是否存在如果它存在，您将add，否则将其值设置为0

$res = [];
foreach($data as $row){
if(!isset($res[$row['bid']]))
$res[$row['bid']] = 0;
$res[$row['bid']] += $row['imp'];
}
print_r($res);

结果就像这个

Array ( [CPM] => 15 [CPC] => 45 )