get sum of php multidiamentional array

Question

I am looking to store sum of all keys inside an array here is my example code

<?php

// Sample data
$category = (object) ['category_name' => '32459*1500*lab*1,32460*400*lab*1,32461*600*lab*1'];
// process
$category_sale_data = explode(',', $category->category_name);
foreach ($category_sale_data as $key => $value) {
    
                list($sale_key, $sale_value) = explode('*', $value);
                $category->sale_data[$sale_key][] = $sale_value;
                //$category->sale_data_sum[$sale_key][] += $sale_value;
}
// display
print_r($category);

getting this output working example -> https://3v4l.org/NAKfb#v7.0.0

Here is expected to get //$category->sale_data_sum[$sale_key][] += $sale_value;

I am expected output like this

stdClass Object
(
    [category_name] => 32459*1500*lab*1,32460*400*lab*1,32461*600*lab*1
    [sale_data] => Array
        (
            [32459] => Array
                (
                    [0] => 1500
                )

            [32460] => Array
                (
                    [0] => 400
                )

            [32461] => Array
                (
                    [0] => 600
                )

        )
    [sale_data_sum] => 2500

)

Edouard · Accepted Answer · 2022-01-22 17:50:54Z

2

Simply do this:

$category->sale_data_sum = 0; // initiate key
foreach ($category_sale_data as $key => $value) {
    list($sale_key, $sale_value) = explode('*', $value);
    $category->sale_data[$sale_key][] = $sale_value;
    $category->sale_data_sum += $sale_value; // add each sale value
}

edited Jan 22, 2022 at 17:50

answered Jan 22, 2022 at 17:38

Edouard

4034 silver badges16 bronze badges

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

1 Comment

uzthegeek Over a year ago

work 100% very quick and short solution awesome thumbs up !

lukas.j · Accepted Answer · 2022-01-22 17:42:39Z

1

$category = [ 'category_name' => '32459*1500*lab*1,32460*400*lab*1,32461*600*lab*1' ];

// category_name
$result['category_name'] = $category['category_name'];

// sale_data
$splitted = preg_split('/[*,]/', $category['category_name']);
for($i = 0; $i < count($splitted); $i += 4) {
  $result['sale_data'][$splitted[$i]] = $splitted[$i + 1];
}

// sale_data_sum
$result['sale_data_sum'] = array_sum($result['sale_data']);

print_r($result);

answered Jan 22, 2022 at 17:42

lukas.j

7,2442 gold badges9 silver badges30 bronze badges

Comments

WiatroBosy · Accepted Answer · 2022-01-22 17:31:25Z

Try this

<?php

    // Sample data
    $category = (object) ['category_name' => '32459*1500*lab*1,32460*400*lab*1,32461*600*lab*1'];
    // process
    $category_sale_data = explode(',', $category->category_name);
    foreach ($category_sale_data as $key => $value) {
        
                    list($sale_key, $sale_value) = explode('*', $value);
                    $category->sale_data[$sale_key][] = $sale_value;
                    //$category->sale_data_sum[$sale_key][] += $sale_value;
    }
    
    function sum($carry, $item)
    {
        $carry += array_values($item)[0];
        return $carry;
    }
    
    $a = array_reduce(array_values($category->sale_data), "sum"); 
    
    var_dump($a);

Or

<?php

// Sample data
$category = (object) ['category_name' => '32459*1500*lab*1,32460*400*lab*1,32461*600*lab*1'];
// process
$category_sale_data = explode(',', $category->category_name);
$category->sale_data_sum = null;
foreach ($category_sale_data as $key => $value) {
    
                list($sale_key, $sale_value) = explode('*', $value);
                $category->sale_data[$sale_key][] = $sale_value;
                $category->sale_data_sum += $sale_value;
}
// display
print_r($category);

Collectives™ on Stack Overflow

get sum of php multidiamentional array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related