PHP: Addition of values in multidimensional array where key equal to and equal to

Question

Having following array:

Array
(
    [notifys] => Array
    (
        [0] => Array
        (
            [notifytype_id] => 10
            [notify_total] => 1
        )

        [1] => Array
        (
            [notifytype_id] => 11
            [notify_total] => 1
        )

        [2] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 3
        )

        [3] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 3
        )

        [4] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 2
        )

        [5] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 32
        )

        [6] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 28
        )

        [7] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 3
        )

        [8] => Array
        (
            [notifytype_id] => 14
            [notify_total] => 7
        )

        [9] => Array
        (
            [notifytype_id] => 2
            [notify_total] => 7
        )

        [10] => Array
        (
            [notifytype_id] => 2
            [notify_total] => 15
        )
    )
)

---------------------------------------------------------------------------------------

Need a PHP solution to do an addition, in example, of all values in [notify_total] WHERE [notifytype_id] == 10 OR [notifytype_id] == 2

So, the result in this example would be:

$result = 23

That's an OR, not an AND

Hanky Panky
– Hanky Panky

2013-11-11 07:38:05 +00:00
Commented Nov 11, 2013 at 7:38 — Hanky Panky
– Hanky Panky, Commented Nov 11, 2013 at 7:38

Hanky Panky · Accepted Answer · 2013-11-11 07:40:03Z

1

$total=0;
foreach($myArray["notifys"] as $value)
{
  if($value["notifytype_id"]==10 || $value["notifytype_id"]==2)
  $total+=$value["notify_total"];
}
echo $total;

answered Nov 11, 2013 at 7:40

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

Comments

gloomy.penguin · Accepted Answer · 2013-11-11 07:41:54Z

1

try this:

$sum = 0; 
foreach ($array['notifys'] as $index => $data)
{
   if ($data['notifytype_id']==10 or $data['notifytype_id']==2)
   {
      $sum += $data['notify_total'];
   } 
}
print $sum;

answered Nov 11, 2013 at 7:41

gloomy.penguin

5,9206 gold badges37 silver badges59 bronze badges

1 Comment

Hanky Panky Over a year ago

Nope let it be. Since you wrote this answer yourself and didn't copy an existing answer, and this is helpful as well, there is no reason to delete it.

Community · Accepted Answer · 2023-11-17 20:33:26Z

1

Use array_reduce() for that.

PHP >=5.4:

$result = array_reduce($array['notifys'], function($temp, $item)
{
   $temp+=in_array($item['notifytype_id'], [2,10])?$item['notify_total']:0;
   return $temp;
},0);

PHP 5.3:

$result = array_reduce($array['notifys'], function($temp, $item)
{
   $temp+=in_array($item['notifytype_id'], array(2,10))?$item['notify_total']:0;
   return $temp;
},0);

PHP <=5.2:

$result = array_reduce($array['notifys'], create_function('$temp, $item', '
{
   $temp+=in_array($item["notifytype_id"], array(2,10))?$item["notify_total"]:0;
   return $temp;
}'),0);

edited Nov 17, 2023 at 20:33

CommunityBot

11 silver badge

answered Nov 11, 2013 at 7:45

Alma Do

37.4k10 gold badges81 silver badges106 bronze badges

4 Comments

lickmycode Over a year ago

Getting a white page with this function. You know why? And what's the advantage of using array_reduce()?

Alma Do Over a year ago

That depends of PHP version you using. Code above is for PHP >=5.4 (in 5.3 there are no short-array definition and in 5.2 or lower there are no closures via function definition)

lickmycode Over a year ago

Using PHP 5.3.3, Sorry :)

Alma Do Over a year ago

See my edit then (but really - upgrade your PHP. There's no reason to stay on ancient versions, and, if it's about hosting - just change it)

Bhavik Shah · Accepted Answer · 2013-11-11 07:51:30Z

0

/*
$arr - array to be searched in
$k   - allowed key to be compared with
You can specify the keys dynamically that you want to compare against.
*/

function getTotal($arr, $k){
    $temp = 0;                                   //initialization
    foreach($arr['notifys'] as $a){
        if( in_array($a['notifytype_id'], $k))
            $temp = $temp + $a['notify_total'];
    }
    return $temp;
}

//Hanky reminded me
$keys = array(2, 10);                            //for this case
echo getTotal($value, $keys);

edited Nov 11, 2013 at 7:51

answered Nov 11, 2013 at 7:46

Bhavik Shah

2,2911 gold badge18 silver badges32 bronze badges

3 Comments

Hanky Panky Over a year ago

Forgot to initialize $keys?

Bhavik Shah Over a year ago

No. Actually, Its upto user. So, i have didnt initialized. I have purposefully made dynamic way for that. BTW, thanks for efforts.

lickmycode Over a year ago

A dynamic solution always wins!! Thanks!

Collectives™ on Stack Overflow

PHP: Addition of values in multidimensional array where key equal to and equal to

---------------------------------------------------------------------------------------

4 Answers 4

Comments

1 Comment

4 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

---------------------------------------------------------------------------------------

4 Answers 4

Comments

1 Comment

4 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related