How to sum and count specific keys in a multidimensional array [duplicate]

Question

I have the following collection that contains the arrays below:

  #items: array:2 [▼
    0 => array:13 [▼

      "label" => "00000000-N/A"
      "views" => 980
      "clicks" => 444
      "form_submissions_perc" => "100.0"

    ]
    1 => array:13 [▼

      "label" => "1111-N/A"
      "views" => 323
      "clicks" => 1009
      "form_submissions_perc" => "100.0"

    ]
  ]

I am trying to sum clicks and average views but in my try I get the wrong data:

   $sum = 0;

    foreach ($data as $k => $subArray) {

        foreach ($subArray as $id => $value) {

            $sum += $subArray['views'];
        }

    }

    dd($sum);

This was my try to sum but didnt get the right results

Desired output

   array:2 [

       "views"=> 1303,
       "clicks"=> 1451

    ]

There is no total_income key in those arrays...

Jonnix
– Jonnix

2018-02-09 12:47:09 +00:00
Commented Feb 9, 2018 at 12:47 — Jonnix
– Jonnix, Commented Feb 9, 2018 at 12:47
"views"=> array_sum(array_column($data, 'views')),

splash58
– splash58

2018-02-09 12:52:45 +00:00
Commented Feb 9, 2018 at 12:52 — splash58
– splash58, Commented Feb 9, 2018 at 12:52

JustBaron · Accepted Answer · 2018-02-09 13:15:16Z

6

Use $sum as array and get correct value of multiarray:

$sum = array(
       'clicks' => 0,
       'views' => 0
       );

foreach ($data as $id => $value) {
    $sum['clicks'] += $value['clicks'];
    $sum['views'] += $value['views'];
}

dd($sum);

edited Feb 9, 2018 at 13:15

JustBaron

2,3457 gold badges25 silver badges37 bronze badges

answered Feb 9, 2018 at 12:51

Vladimir

1,40110 silver badges12 bronze badges

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

Comments

samo0ha · Accepted Answer · 2018-02-09 13:06:58Z

1

   foreach ($data as $k => $subArray) {
        $valueSum[] = $subArray['views'];
        $clickSum[] = $subArray['clicks'];
    }
    echo array_sum($valueSum);
    echo array_sum($clickSum);

this is also a clean and easy way .

answered Feb 9, 2018 at 13:06

samo0ha

3,8462 gold badges28 silver badges29 bronze badges

Comments

MH2K9 · Accepted Answer · 2018-02-09 13:02:01Z

0

You can use array_reduce instead

$data = array_reduce($array, function ($old, $new) {
    return [
        "view" => $old["view"] + $new["view"],
        "clicks" => $old["clicks"] + $new["clicks"]
    ];
}, ["view" => 0, "clicks" => 0]);

print '<pre>';
print_r($data);

answered Feb 9, 2018 at 13:02

MH2K9

12.1k7 gold badges34 silver badges49 bronze badges

Comments

localroot · Accepted Answer · 2018-02-09 13:20:28Z

0

$data = [
            [
                "label"                 => "00000000-N/A",
                "views"                 => 980,
                "clicks"                => 444,
                "form_submissions_perc" => "100.0"
            ],
            [
                "label"                 => "1111-N/A",
                "views"                 => 323,
                "clicks"                => 1009,
                "form_submissions_perc" => "100.0"
            ]
        ];

        $result['views']  = array_sum( array_column( $data, 'views' ) );
        $result['clicks'] = array_sum( array_column( $data, 'clicks' ) );

        dd( $result );

This is the easiest way to do your work.

Result:

Array ( [views] => 1303 [clicks] => 1453 )

edited Feb 9, 2018 at 13:20

answered Feb 9, 2018 at 12:56

localroot

5563 silver badges13 bronze badges

Collectives™ on Stack Overflow

How to sum and count specific keys in a multidimensional array [duplicate]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related