array_sum() to values within an array

Question

How can i add array_sum to the string in my loop without making another foreach loop for it? I am trying to combine all of the numbers together instead of having this multi dimensional array and then just have the value and i see that array_sum wont add them up because its inside of an array. any ideas?

$hours_arr = array();
foreach($proj_time as $item){
    $hours_arr [$item['project_id']]['item_value'] = $item['item_value'];
    $hours_arr [$item['project_id']]['hours'][] = $item['hours'];
}

//output
array (size=3)
  4 => 
    array (size=2)
      'item_value' => string 'Coaching' (length=8)
      'hours' => 
        array (size=1)
          0 => string '999.99' (length=6)
  1487 => 
    array (size=2)
      'item_value' => string 'Standby' (length=7)
      'hours' => 
        array (size=1)
          0 => string '15.00' (length=5)
  1488 => 
    array (size=2)
      'item_value' => string 'Standby' (length=7)
      'hours' => 
        array (size=4)
          0 => string '10.00' (length=5)
          1 => string '10.00' (length=5)
          2 => string '10.00' (length=5)
          3 => string '10.00' (length=5)

I would like my output to be

1488 => 
    array (size=2)
      'item_value' => string 'Standby' (length=7)
      'hours' => string '40.00' (length=5)

edit: added contents of $proj_time

Array
(
    [0] => Array
        (
            [project_id] => 4
            [consultant_id] => 51
            [engagement_id] => 8
            [hours] => 999.99
            [item_value] => Coaching
        )

    [1] => Array
        (
            [project_id] => 1487
            [consultant_id] => 1
            [engagement_id] => 1
            [hours] => 15.00
            [item_value] => Standby
        )

    [2] => Array
        (
            [project_id] => 1488
            [consultant_id] => 31
            [engagement_id] => 7
            [hours] => 10.00
            [item_value] => Design App RFP
        )

    [3] => Array
        (
            [project_id] => 1488
            [consultant_id] => 32
            [engagement_id] => 41
            [hours] => 10.00
            [item_value] => Training
        )

    [4] => Array
        (
            [project_id] => 1488
            [consultant_id] => 55
            [engagement_id] => 41
            [hours] => 10.00
            [item_value] => Training
        )

    [5] => Array
        (
            [project_id] => 1488
            [consultant_id] => 1
            [engagement_id] => 1
            [hours] => 10.00
            [item_value] => Standby
        )

)

can you show the $proj_time array contents?

RomanPerekhrest
– RomanPerekhrest

2016-06-29 09:04:18 +00:00
Commented Jun 29, 2016 at 9:04 — RomanPerekhrest
– RomanPerekhrest, Commented Jun 29, 2016 at 9:04
@RomanPerekhrest Added it.

Suzed
– Suzed

2016-06-29 09:07:46 +00:00
Commented Jun 29, 2016 at 9:07 — Suzed
– Suzed, Commented Jun 29, 2016 at 9:07

Thamilhan · Accepted Answer · 2016-06-29 09:14:54Z

1

Instead of creating array and then applying operation, while creating itself why don't you sum up like this:

DEMO

$hours_arr = array();
foreach($proj_time as $item){
    $hours_arr [$item['project_id']]['item_value'] = $item['item_value'];
    if(array_key_exists('hours', $hours_arr [$item['project_id']]))
        $hours_arr [$item['project_id']]['hours'] += $item['hours'];
    else
        $hours_arr [$item['project_id']]['hours'] = $item['hours']; 
}

Result:

Array
(
    [4] => Array
        (
            [item_value] => Coaching
            [hours] => 999.99
        )

    [1487] => Array
        (
            [item_value] => Standby
            [hours] => 15
        )

    [1488] => Array
        (
            [item_value] => Standby
            [hours] => 40
        )

)

answered Jun 29, 2016 at 9:14

Thamilhan

13.3k5 gold badges40 silver badges60 bronze badges

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

1 Comment

Suzed Over a year ago

Thank you, I appreciate it.

b0ne · Accepted Answer · 2016-06-29 09:08:33Z

0

Try this out

<?php
    $hours_arr = array();
    foreach($proj_time as $item){
        if(!isset($hours_arr [$item['project_id']]) || $hours_arr [$item['project_id']]['item_value'] != $item['item_value']) {     
            $hours_arr [$item['project_id']]['item_value'] = $item['item_value'];
            $hours_arr [$item['project_id']]['hours'][] = $item['hours'];
        } else {
            $hours_arr [$item['project_id']]['hours'][0] += $item['hours'];
        }
    }

edited Jun 29, 2016 at 9:08

answered Jun 29, 2016 at 9:01

b0ne

6653 silver badges10 bronze badges

2 Comments

Suzed Over a year ago

No luck, the array is almost still the same. pastebin.com/ci55girE

b0ne Over a year ago

Oops my bad, forgot the add the key for hours. Try it now

Collectives™ on Stack Overflow

array_sum() to values within an array

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related