How to get particular value from JSON using php

Question

I have run the below code

$api_key = 'XXXXXXXXX';
$api_url = "http://sms.eduapp.com:8381/app/miscapi/".$api_key."/getBalance/true/";
$credit_balance = file_get_contents( $api_url);
echo $credit_balance;

And got output

   [{"ROUTE_ID":"101057","ROUTE":"SMSWAY_TRANS","BALANCE":"13700"}]

From the above output I just want to get value 13700 in php variable.

Thanks in advance :)

use json_decode as `$array = json_decode('[{"ROUTE_ID":"101057","ROUTE":"SMSWAY_TRANS","BALANCE":"13700"}]'); echo $array[0]->BALANCE ;` — Devsi Odedra, Jan 18 '20 at 07:38

hosein in jast · Answer 1 · 2020-01-18T07:48:13.437

1

the site return you an array try this

$api_key = 'XXXXXXXXX';
$api_url = "http://sms.eduapp.com:8381/app/miscapi/".$api_key."/getBalance/true/";
$credit = file_get_contents( $api_url);
// sorry im forgot to decode th json
$credit_balance = json_decode($credit, true);
echo $credit_balance['BALANCE'];

edited Jan 18 '20 at 07:48

answered Jan 18 '20 at 07:33

hosein in jast

370
2
15

Thanks for quick help but showing only [ nothing else – sandeep autade Jan 18 '20 at 07:36
try new code and tell us result – hosein in jast Jan 18 '20 at 07:48
it's now working perflcly thanks for your help :) $balance = json_decode($credit_balance); echo $balance[0]->BALANCE; – sandeep autade Jan 18 '20 at 07:56

jeprubio · Accepted Answer · 2020-01-18T08:07:56.107

1

$credit_balance = file_get_contents($api_url);
$balance = json_decode($credit_balance, true);
echo $balance[0]['BALANCE'];

Or:

$credit_balance = file_get_contents($api_url);
$balance = json_decode($credit_balance);
echo $balance[0]->BALANCE

edited Jan 18 '20 at 08:07

answered Jan 18 '20 at 07:38

jeprubio

17,312
5
45
56

1

The first example won't work (wrong variable in `echo`) – Nigel Ren Jan 18 '20 at 07:48
Thanks @jeprubio I have just remove true from the second example and it's work :) – sandeep autade Jan 18 '20 at 07:51
1

Yes, sorry, the second parameter is to return it as associative array if it's true or as an object if it's not. Fixed both ways – jeprubio Jan 18 '20 at 07:56

How to get particular value from JSON using php

2 Answers2