add database value off array in CodeIgniter

Question

I want to add the values that I got from database..

I have an output of

Array ( [0] => stdClass Object ( [TOTAL_TIME] => 10.58 ) [1] => stdClass Object ( [TOTAL_TIME] => 9.23 ) [2] => stdClass Object ( [TOTAL_TIME] => 10.35 ) [3] => stdClass Object ( [TOTAL_TIME] => 10.10 ) [4] => stdClass Object ( [TOTAL_TIME] => 9.95 ) [5] => stdClass Object ( [TOTAL_TIME] => 3.40 ) [6] => stdClass Object ( [TOTAL_TIME] => 9.90 ) [7] => stdClass Object ( [TOTAL_TIME] => 10.63 ) [8] => stdClass Object ( [TOTAL_TIME] => 10.48 ) [9] => stdClass Object ( [TOTAL_TIME] => 9.43 ) [10] => stdClass Object ( [TOTAL_TIME] => 6.42 ) [11] => stdClass Object ( [TOTAL_TIME] => 10.12 ) [12] => stdClass Object ( [TOTAL_TIME] => 9.33 ) [13] => stdClass Object ( [TOTAL_TIME] => 5.53 ) [14] => stdClass Object ( [TOTAL_TIME] => 9.35 ) [15] => stdClass Object ( [TOTAL_TIME] => 9.60 ) [16] => stdClass Object ( [TOTAL_TIME] => 10.08 ) [17] => stdClass Object ( [TOTAL_TIME] => 10.03 ) [18] => stdClass Object ( [TOTAL_TIME] => 7.73 ) [19] => stdClass Object ( [TOTAL_TIME] => 16.82 ) [20] => stdClass Object ( [TOTAL_TIME] => 16.55 ) )

I want to do is to add those value.

I already did

$sum = array_sum($data)

But it does not work. the only output I got was 0.

How can I add it?

Output is not an array >It is an object.So array_sum will not work — Bikash
– Bikash, Commented May 17, 2016 at 12:11
Possible duplicate of codeigniter, result() vs. result_array() — Farside
– Farside, Commented May 17, 2016 at 14:08

Alex Andrei · Accepted Answer · 2016-05-17 13:44:28Z

Loop over the array and sum up the values of the TOTAL_TIME property of each object together.

$sum = 0; foreach ($array as $object){ $sum += $object->TOTAL_TIME; } print $sum;

You can also use array_walk as an alternative to the loop

$sum = 0; array_walk($array,function($object) use (&$sum){ $sum += $object->TOTAL_TIME; }); print $sum;

lavavrik · Accepted Answer · 2016-05-17 12:18:47Z

You can use array_reduce:

$total_time = array_reduce($arr, function($carry, $item) { return $carry += $item->TOTAL_TIME; }, 0);

array_reduce @ php.net

Brijal Savaliya · Accepted Answer · 2016-05-17 12:22:13Z

Use this code

function convertObjectToArrayWithSum($data) { if (is_object($data)) { $data = get_object_vars($data); } if (is_array($data)) { $input = array_map(__FUNCTION__, $data); array_walk_recursive($input, function($item, $key) use (&$final) { $final[$key] = isset($final[$key]) ? $item + $final[$key] : $item; }); return $final; } return $data; } print_r(convertObjectToArrayWithSum($data));

Ivan · Accepted Answer · 2016-05-17 12:25:34Z

If you want to store in variable sum of value TOTAL_TIME try this

$total_time = 0; if (!empty($data)) { foreach ($data as $value) { $total_time += $value->TOTAL_TIME; } }

If you get that data from database, i suggest to use SUM on the query so we return variable and don't need to perform foreach loop.

Bikash · Accepted Answer · 2016-05-17 12:41:23Z

0

$array = (array) $yourObject;

Then you apply array_sum

edited May 17, 2016 at 12:41

answered May 17, 2016 at 12:14

Bikash

1,9483 gold badges26 silver badges34 bronze badges

Collectives™ on Stack Overflow

add database value off array in CodeIgniter

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Linked

Related