Adding the integer values inside JSON using PHP

Question

For example I have this JSON.

[{"rate":3},{"rate":4},{"rate":3},{"rate":5}]

What can I do so I can add all the values inside of it in PHP. Thaanks :)

So this is the code goes srry.

<?PHP
include_once("connection.php");

$query = "SELECT rate FROM tbl_ratings WHERE userID = 10";

$result = mysqli_query($conn, $query);

$json = array();

if(mysqli_num_rows($result)){
    while($row = mysqli_fetch_assoc($result)){
     $json[]=$row;
}
}
mysqli_close($conn);
echo json_encode($json, JSON_NUMERIC_CHECK);
echo array_sum($json, JSON_NUMERIC_CHECK);
?>

Can it be possible that you add this all json elements and then send it to php? will it work? — Jaymin
– Jaymin, Commented Aug 9, 2017 at 10:57
Decode the JSON, process the resulting object, encode it back if necessary. — raina77ow
– raina77ow, Commented Aug 9, 2017 at 10:57

mickmackusa · Accepted Answer · 2019-08-18 21:49:04Z

1

You don't need to reconfigure your json string to suit the method -- just add array_column().

Code: (Demo)

// these are subarrays containing 1 element each
$json = '[{"rate":3},{"rate":4},{"rate":3},{"rate":5}]';

// decode it to an array    
$array = json_decode($json, true);

// extract the "rate" column values from each subarray and sum them
echo array_sum(array_column($array, 'rate'));

Output:

...but honestly, it looks like you have over-complicated the task. Just add it all up using MySQL.

$result = mysqli_query($conn, "SELECT SUM(rate) FROM tbl_ratings WHERE userID = 10");
echo mysqli_fetch_row($result)[0];  //15

edited Aug 18, 2019 at 21:49

answered Aug 9, 2017 at 14:18

mickmackusa♦

49.2k13 gold badges98 silver badges165 bronze badges

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

Comments

Jaymin · Accepted Answer · 2017-08-09 11:00:28Z

0

<?php
//Your json decode
$json = json_decode($YourJson);
//summation of all elements
$total = array_sum($jaon);
?>

answered Aug 9, 2017 at 11:00

Jaymin

1,6612 gold badges20 silver badges42 bronze badges

Comments

Milan Chheda · Accepted Answer · 2017-08-09 11:12:55Z

0

Your JSON in incorrect. It should have proper square brackets. Before 3, there should be opening square bracket and not {
You should do json_decode()
Use array_sum() to get the sum of all values.

Below is the code:

$json = '{"rates": [3,2,3,5,7]}';
$arr = json_decode($json);
echo array_sum($arr->rates);

answered Aug 9, 2017 at 11:12

Milan Chheda

8,2593 gold badges23 silver badges35 bronze badges

Collectives™ on Stack Overflow

Adding the integer values inside JSON using PHP

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related