PHP calculate values from json or array

Question

I am reading form a a file that print out of the following.

    {  
   "draw":0,
   "recordsTotal":3995,
   "recordsFiltered":1,
   "data":[  
      {  
         "customer_id":"1",
         "channel":"2",
         "date":"2017-03\/21 ",
         "earnings":"2500"
      },
      {  
         "customer_id":"2",
         "channel":"2",
         "date":"2017-03\/21 ",
         "earnings":"1500"
      }
   ]
}

is it possible in a separate php file to read this and to calcualte the total earnings?

i.e 2500 + 1500 = 4000

See: http://stackoverflow.com/q/29308898/3933332 – Rizier123 Mar 29 '17 at 11:43 — Rizier123, Mar 29 '17 at 11:43

score 3 · Accepted Answer · answered Mar 29 '17 at 11:45

3

Try this:

$decoded = json_decode($json, true); // Decode JSON to array

echo array_sum(array_column($decoded['data'], 'earnings')); // Calculate sum of 'earnings' index within 'data'

answered Mar 29 '17 at 11:45

Indrasis Datta

8,692
2
14
32

PHP calculate values from json or array

1 Answers1