php - 如何使用php合并数据

Question

目前我的 MySQL 数据存储如下

product             | total
------------------------------------------
puma,adidas         | 100.00,125.00     
puma                | 80.00
reebok,adidas,puma  | 70.00,100.00,125.00
adidas,umbro        | 125.00,56.00      

如何在php中像这样组合，分解，合并和总计？

puma     485.00
adidas   350.00
reebook  70.00
umbro    56.00

Answer 1

我不知道你的结果集是什么样子，但逻辑应该是一样的:

$combined = array();
foreach ($results as $result) {
    $productsArr = split(",", $result['product']);
    $totalsArr = split(",", $result['total']);

    // we'll assume both arrays are always the same size
    $prodCount = count($productsArr);
    for($i = 0; $i < $prodCount; $i++) {
        $combined[$productsArr[$i]] += (float)$totalsArr[$i];
    }
}
print_r($combined);