add all values with matching key in multidimensional json array

Question

I am working on a php script where I have a json api array that looks something like this --

[body] => stdClass Object
        (
            [api] => stdClass Object
                (
                    [status] => 200
                    [message] => GET stat....
                    [results] => 379
                    [filters] => Array
                        (
                            [0] => gameId
                            [1] => playerId
                        )

                    [statistics] => Array
                        (
                            [0] => stdClass Object
                                (
                                    [gameId] => 17
                                    [totReb] => 7
                                    [assists] => 5
                                    [pFouls] => 4
                                    [steals] => 3
                                    [turnovers] => 2
                                    [blocks] => 0
                                    [plusMinus] => 9
                                    [playerId] => 265
                                )

                            [1] => stdClass Object
                                (
                                    [gameId] => 24
                                    [teamId] => 7
                                    [totReb] => 
                                    [assists] => 
                                    [pFouls] => 
                                    [steals] => 
                                    [turnovers] => 
                                    [blocks] => 
                                    [plusMinus] => 
                                    [playerId] => 265
                                )

And I am trying to get the values for each object to then output the total, so for each [?] => stdClass Object it will get the specified key and total the value.

How can I add all the values from one key?

What is your key? which values you want to add / count as total? can you try explain better what error do you get or what non desire output you get? — dWinder
– dWinder, Commented May 20, 2019 at 21:57
i will be using multiple keys in my script, so for example this key - [steals] => 3 — 730wavy
– 730wavy, Commented May 20, 2019 at 23:20

dWinder · Accepted Answer · 2019-05-21 04:27:28Z

1

First get the array of statistics (the one you want to loop and sum on). Then use array_column to extract only specific key and then array_sum for summing it.

This is pseudo but should give you the idea:

$arr = $obj->body->api->statistics;
$keyToSum = "steals";
$totalSteals = array_sum(array_column($arr, $keyToSum));

Reference: array-column, array-sum

answered May 21, 2019 at 4:27

dWinder

11.7k3 gold badges27 silver badges40 bronze badges

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

Comments

Rahul · Accepted Answer · 2019-05-21 09:12:42Z

0

There is one custom function I have which fetches column data recursively like array_column.

function array_column_recursive(array $haystack, $needle) {
    $found = [];
    array_walk_recursive($haystack, function($value, $key) use (&$found, $needle) {
        if ($key == $needle)
            $found[] = $value;
    });
    return $found;
}
echo array_sum(array_column_recursive($arr, 'steals'));

Source link.

answered May 21, 2019 at 9:12

Rahul

18.6k7 gold badges43 silver badges64 bronze badges

Collectives™ on Stack Overflow

add all values with matching key in multidimensional json 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