Multidimensional Array Sum Column [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed last year.

Improve this question

I have a multidimensional array with a race type column and a boats column (which has the total number of boats for each race type). This is how I am getting the array values:

$boats = $wpdb->get_results("
        select rt.race_type
              ,sum(tr.boat_count) boats
          from registrations tr
         group by rt.race_type;
");

The array works perfectly fine. But now I am trying to get the total number of boats for all race types (without using a loop). After some research, I have tried the code below, but it doesn't seem to be working:

$totalboats = array_sum(array_column($boats,'boats'));

When I run the following command:

echo $totalboats;

The result of that is 0, which is clearly wrong.

Any ideas? I am running PHP 5.6.29.

================== EDIT 01 ==================

As requested, here is the var_dump of $boats:

array(2) {
    [0]=>
        object(stdClass)#672 (2) {
            ["race_type"]=> string(12) "Elite 8-Hour"
            ["boats"]=> string(1) "2"
        }
    [1]=>
        object(stdClass)#673 (2) {
            ["race_type"]=> string(12) "Sport 4-Hour"
            ["boats"]=> string(1) "2"
        }
}

It should be sum(tr.boat_count) AS boats, not sum(tr.boat_count) boats. — arkascha
– arkascha, Commented Mar 23, 2017 at 13:23
Per the documentation on $wpdb->get_results - it appears this method may actually hydrate into objects as opposed to a multidimensional array. codex.wordpress.org/Class_Reference/wpdb — thinice
– thinice, Commented Mar 23, 2017 at 13:26
try this. first call array_column() funtion and store in to a variable and then call array_sum() function, without calling one function inside another function. — ashanrupasinghe
– ashanrupasinghe, Commented Mar 23, 2017 at 13:34

Community · Accepted Answer · 2017-05-23 12:17:23Z

2

The problem is that your $boats sub-elements are objects and not arrays. array_column doesn't work with objects in PHP5 (it does in PHP7, though).

You could use a workaround using array_map, as shown in this answer to a previous question :

$totalboats = array_sum(
    array_column(
        array_map(
            function($o){
                return (array)$o;
            },
            $boats),
       'boats')
    );
echo $totalboats; // echoes "4"

edited May 23, 2017 at 12:17

CommunityBot

11 silver badge

answered Mar 23, 2017 at 13:49

roberto06

3,8641 gold badge20 silver badges30 bronze badges

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

2 Comments

thinice Over a year ago

At this level of complexity, you might as well use a foreach() and dispense with the type casting and array_map()

roberto06 Over a year ago

Agreed. Still, the original question stated without using a loop, so I took it as a challenge ;)

Priyank · Accepted Answer · 2017-03-23 13:53:28Z

0

If your variable is array and not object you can use this

$array = [
  0 => [
     'race_type' => 'Elite 8-Hour',
     'boats' => '2',
    ],
  1 => [
     'race_type' => 'Sport 4-Hour',
     'boats' => '2',
    ]
];



$toSum = array_sum(array_column($array, 'boats'));

echo "<pre>";print_r($toSum);die;

answered Mar 23, 2017 at 13:53

Priyank

1,3481 gold badge16 silver badges27 bronze badges

1 Comment

roberto06 Over a year ago

You mean he can use exactly what he's already using ? Shocking.

Collectives™ on Stack Overflow

Multidimensional Array Sum Column [closed]

2 Answers 2

2 Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Linked

Related