How can I sum up values from a json string?

Question

I get the following json data from a database:

[{"type":"Sig","value":"0.0"},{"type":"SH","value":"9.95"},{"type":"COD","value":"6.95"}][{"type":"Sig","value":"0.0"},{"type":"SH","value":"9.95"},{"type":"COD","value":"6.95"}][{"type":"Sig","value":"0.0"},{"type":"SH","value":"9.95"},{"type":"COD","value":"6.95"}][{"type":"Sig","value":"0.0"},{"type":"SH","value":"9.95"},{"type":"COD","value":"6.95"}]

I'm trying to add all value values together, so: 9.95 + 6.95 ... so that I get 67.6 as result.

I tried the below code, but I am getting 16.9 as repeated values.

for ($i = 0; $i <= $count - 1 ; $i++) {

    $charge = $service[$i]['charge']; 
    $serviceValue = json_decode($charge, true); 
    $totalservice = 0;

    foreach ($serviceValue as $key => $value)      {              
        $totalservice += $value['service_value'];
    }
    echo $totalservice;                
}

Set $totalservice = 0; outside for loop.

u_mulder
– u_mulder

2017-01-13 18:46:06 +00:00
Commented Jan 13, 2017 at 18:46 — u_mulder
– u_mulder, Commented Jan 13, 2017 at 18:46
Thanks @u_mulder now it works fine. Thanks alot.

Haripriya
– Haripriya

2017-01-13 18:51:18 +00:00
Commented Jan 13, 2017 at 18:51 — Haripriya
– Haripriya, Commented Jan 13, 2017 at 18:51

Death-is-the-real-truth · Accepted Answer · 2017-01-13 19:05:43Z

1

You can do it like below:-

$jsonObj = json_decode($json); // Decode the JSON to OBJ

// Now loop and find the SUM
$total = 0;
foreach ($jsonObj as $item){
    $total =+ $item->value;
}

// Print the SUM
echo "Sum : $total";

Note:- In your code $totalservice beome 0 every time when loop goes to next iteration and that's why you are getting same value repeated time. So do like (what @u_mulder said) :-

$totalservice = 0;
for ($i = 0; $i <= $count-1 ; $i++) {
.....//rest code
}

edited Jan 13, 2017 at 19:05

answered Jan 13, 2017 at 18:46

Death-is-the-real-truth

72.3k10 gold badges59 silver badges105 bronze badges

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

1 Comment

Haripriya Over a year ago

Thanks for your answer @anant . Got the solution by keeping $totalservice=0 outside the loop.

Haripriya · Accepted Answer · 2017-01-13 18:53:44Z

1

I have made the below changes. It works fine.

$totalservice = 0;
for ($i = 0; $i <= $count-1 ; $i++) {
    $charge = $service[$i]['charge']; 
    $serviceValue = json_decode($charge, true); 

    foreach ($serviceValue as $key => $value)      {              
        $totalservice+= $value['service_value'];
    }
    echo $totalservice;                
    }

Thanks for the help

answered Jan 13, 2017 at 18:53

Haripriya

1011 gold badge3 silver badges10 bronze badges

Collectives™ on Stack Overflow

How can I sum up values from a json string?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related