Sum values from JSON array response by PHP

Question

I am retrieving JSON data in array and I sort them into the HTML table. So far it is OK, but I would like to sum the specific values from JSON Response and print the sum of object values.

I have a PHP code which sorting me the data from JSON as following:

foreach($result->response as $value)
 {

  echo "<tr>";
    echo "<td>" . $value->datetime  . "</td>";
    echo "<td>" . $value->service_type  . "</td>";
    echo "<td>" . $value->destination  . "</td>";
    echo "<td>" . $value->duration  . "</td>";
    echo "<td>" . $value->price  . "</td>";
    echo "</tr>";

 }

I am interested only in values of prices (in JSON Array), I would like to take only the value of prices from JSON and sum the values of prices and give the result number under the table.

I am trying this without any success:

$countprice = $result->response->price;
$totalprice = count($countprice);
echo $totalprice;

The result is weird number, I know that PHP use "count", but I am not sure how to use it. Sorry I am novice in JSON and PHP and I will thank you for any tip you may give me.

No it is mainly PHP problem, I am already handling the JSON response. — scree
– scree, Commented Jun 12, 2015 at 11:31

Faiz Rasool · Accepted Answer · 2015-06-12 10:12:53Z

2

Try this

    <?php

    $sum = 0;
    foreach ($result->response as $value) {
    echo "<tr>";
    echo "<td>" . $value->datetime  . "</td>";
    echo "<td>" . $value->service_type  . "</td>";
    echo "<td>" . $value->destination  . "</td>";
    echo "<td>" . $value->duration  . "</td>";
    echo "<td>" . $value->price  . "</td>";
    echo "</tr>";
    $sum += $value->price;
    }
    echo "sum is {$sum}";

edited Jun 12, 2015 at 10:12

answered Jun 12, 2015 at 10:09

Faiz Rasool

1,3791 gold badge12 silver badges20 bronze badges

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

3 Comments

Goikiu Over a year ago

You can add the sum control to the echo =)

Faiz Rasool Over a year ago

Yes you can have also the echo lines let me update it

scree Over a year ago

That is what I looked for. Your code is just simple and works on 100%. Thank you.

Collectives™ on Stack Overflow

Sum values from JSON array response by PHP

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related