PHP数组去重并且吧一个字段的值相加

最新推荐文章于 2021-03-20 06:35:47 发布

蔺儿响叮当

最新推荐文章于 2021-03-20 06:35:47 发布

阅读量517

点赞数

分类专栏： php mysql

本文链接：https://blog.csdn.net/linxinyugg/article/details/107631957

版权

php 同时被 2 个专栏收录

14 篇文章 0 订阅

订阅专栏

mysql

3 篇文章 0 订阅

订阅专栏

这是一个二维数组要把它去重并且相加

[0] => array(4) {
  ["id"] => int(1)
  ["bid"] => int(1)
  ["sales"] => string(2) "15"
  ["price"] => string(4) "5975"
}
[1] => array(4) {
  ["id"] => int(2)
  ["bid"] => int(1)
  ["sales"] => string(1) "2"
  ["price"] => string(3) "659"
}
[2] => array(2) {
  ["id"] => int(3)
  ["bid"] => int(1)
}
[3] => array(2) {
  ["id"] => int(4)
  ["bid"] => int(1)
}
[4] => array(4) {
  ["id"] => int(5)
  ["bid"] => int(1)
  ["sales"] => string(1) "1"
  ["price"] => string(3) "256"
}

我要根据bid把sales累加和price累加,人后去掉重复的bid只保留一个,方法:

$new = array();
foreach ($store_i1 as $k=>$v){
    if(isset($new[$v['bid']])){
        $new[$v['bid']]['sales'] += $v['sales'];
        $new[$v['bid']]['price'] += $v['price'];
    }else{
        $new[$v['bid']]['sales'] = $v['sales'];
        $new[$v['bid']]['price'] = $v['price'];
    }

}

结果：

[1] => array(2) {
  ["sales"] => int(18)
  ["price"] => int(6890)
}
[3] => array(2) {
  ["sales"] => int(0)
  ["price"] => int(0)
}
[2] => array(2) {
  ["sales"] => string(3) "0"
  ["price"] => string(5) "0"
}