Addition of values in multi-dimensional array

Question

I have the following array:

array:3 [▼
  0 => array:2 [▼
    "modId" => "3"
    "prdWt" => 1500.0
  ]
  1 => array:2 [▼
    "modId" => "8"
    "prdWt" => 50.0
  ]
  2 => array:2 [▼
    "modId" => "8"
    "prdWt" => 10.0
  ]
]

What I am trying to achieve is that, the child array should add up the values of prdWt if the modId is same.

What I want is:

array:2 [▼
  0 => array:2 [▼
    "modId" => "3"
    "prdWt" => 1500.0
  ]
  1 => array:2 [▼
    "modId" => "8"
    "prdWt" => 60.0
  ]
]

Code so far that I have tried:

//$prdModWt is the parent array coming from session
foreach ($prdModWt as $prd) {
    $val = $this->checkKey($prdModWt, 'modId', $prd['modId']);

    var_dump($val);

    $a[] = $this->sum_index($prdModWt, 'prdWt');
}

public function sum_index($arr, $col_name)
{
    $sum = 0;
    foreach ($arr as $item) {
        $sum += $item[$col_name];
    }
    return $sum;
}

public function checkKey($array, $key, $val)
{
    foreach ($array as $item) {
        if (isset($item[$key]) && $item[$key] == $val) {
            return true;
        }
    }
    return false;
}

I know that this is way too simple to achieve, but I am failing in this. So kindly help me out.

P.S. The parent array is dynamic.. Meaning the values are coming from the session only but the values are stored in the session after fetching it from the database.

Narendrasingh Sisodia · Accepted Answer · 2015-12-01 07:31:09Z

1

You can simply achieve that within single loop only like as

$arr = [["modId" => "3",
    "prdWt" => 1500.0
  ],["modId" => "8",
    "prdWt" => 50.0
  ],["modId" => "8",
    "prdWt" => 10.0
  ]
];

$result = [];
foreach($arr as $key => $value){
    $hash = $value['modId'];
    if(isset($result[$hash])){
        $result[$hash]['prdWt'] += $value['prdWt'];
    }else{
        $result[$hash]['modId'] = $value['modId'];
        $result[$hash]['prdWt'] = $value['prdWt'];
    }
}
print_r(array_values($result));

Demo

answered Dec 1, 2015 at 7:31

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Phroggyy · Accepted Answer · 2015-12-01 07:35:36Z

0

Well, an easy way to do this (but ugly, I'll try to come up with something easier) is the following:

$results = [];
foreach($array as $i => $item) {
    if($item['modId'] == $array[$i + 1]['modId']) {
        $results[] = ['modId' => $item['modId'], 'prdWt' => $item['prdWt'] + $array[$i + 1]['prdWt']];
    }
}

You could also easily write a recursive solution I believe

answered Dec 1, 2015 at 7:35

Phroggyy

4334 silver badges10 bronze badges

Collectives™ on Stack Overflow

Addition of values in multi-dimensional array

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related