douba9425
2018-03-07 18:51
采纳率: 100%
浏览 214
已采纳

PHP根据foreach循环内的值求和数组值

Hi I have an associative array which has common values. I want to sum those values and group based on different values.

My array is like following.

Array
(
    [supercategory] => Food
    [subtotal] => 1152.50
    [discount] => 10.0000
    [orderdiscount] => 10.00
    [itemdiscount] => 0.00
    [Total] => 1142.50
    [Tax] => 80.06
    [taxinclusive] => 0.00
    [taxexclusive] => 80.06
    [gratuity] => 0.00
    [totalsale] => 1222.56
)
Array
(
     [supercategory] => Drinks
    [subtotal] => 1152.50
    [discount] => 10.0000
    [orderdiscount] => 10.00
    [itemdiscount] => 0.00
    [Total] => 1142.50
    [Tax] => 80.06
    [taxinclusive] => 0.00
    [taxexclusive] => 80.06
    [gratuity] => 0.00
    [totalsale] => 1222.56
)
Array
(
     [supercategory] => Food
    [subtotal] => 1152.50
    [discount] => 10.0000
    [orderdiscount] => 10.00
    [itemdiscount] => 0.00
    [Total] => 1142.50
    [Tax] => 80.06
    [taxinclusive] => 0.00
    [taxexclusive] => 80.06
    [gratuity] => 0.00
    [totalsale] => 1222.56
)
Array
(
     [supercategory] => Alcohols
    [subtotal] => 1152.50
    [discount] => 10.0000
    [orderdiscount] => 10.00
    [itemdiscount] => 0.00
    [Total] => 1142.50
    [Tax] => 80.06
    [taxinclusive] => 0.00
    [taxexclusive] => 80.06
    [gratuity] => 0.00
    [totalsale] => 1222.56
)

While traversing this array I want to sum the array values within foreach loop/While based on key supercategory so that I can sum totalsale for all these keys having having same values. Please help me on this.

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • duanlongnao0028 2018-03-07 19:37
    已采纳

    You don't need to worry about previous/next values to group your array.

    Just iterate it and use the column you want to group by as a key in your result array.

    foreach ($your_array as $item) {
        $groups[$item['supercategory']][] = $item;
    }
    

    This will basically add a dimension to your array, where all the items are grouped under their respective supercategory.

    After you have that structure, it's easy to do operations on groups. Here's an example of how to produce the set of sums I think you're trying to get.

    foreach ($groups as $cat => $items) {
        $category_totals[$cat] = array_sum(array_column($items, 'totalsale'));
    }
    
    点赞 评论

相关推荐 更多相似问题