PHP: Get data from JSON?

Question

I'm trying to get a data from a JSON.

The JSON looks like this:

{
  "object": "balance",
  "available": [
    {
      "currency": "aud",
      "amount": 0,
      "source_types": {
        "card": 0
      }
    }
  ],
  "livemode": false,
  "pending": [
    {
      "currency": "aud",
      "amount": 37706,
      "source_types": {
        "card": 37706
      }
    }
  ]
}{
  "object": "balance",
  "available": [
    {
      "currency": "aud",
      "amount": 0,
      "source_types": {
        "card": 0
      }
    }
  ],
  "livemode": false,
  "pending": [
    {
      "currency": "aud",
      "amount": 37706,
      "source_types": {
        "card": 37706
      }
    }
  ]
}{
  "object": "balance",
  "available": [
    {
      "currency": "aud",
      "amount": 0,
      "source_types": {
        "card": 0
      }
    }
  ],
  "livemode": false,
  "pending": [
    {
      "currency": "aud",
      "amount": 37706,
      "source_types": {
        "card": 37706
      }
    }
  ]
}

All I need from there is the available balance.

I tried this code but the output of this code is just this {{{

This is my code:

$amount = $balanceArr['balance']['available'][0]['amount'];

echo $amount;

Note that the $balanceArr is just the JSON.

Could someone please advice on this issue?

Any help would be appreciated.

Thanks in advance.

This has been asked and answered many times. Please refer to the link in the "Possible duplicate" comment. — random_user_name, Aug 18 '17 at 18:01
actually, this has been answered for valid json. Yours is not. — YvesLeBorg, Aug 18 '17 at 18:02
Aside from this not being valid JSON (assuming you posted it exactly), there is no `'balance'` property. There is an `'object'` property with the value `'balance'` — jonhopkins, Aug 18 '17 at 18:04

score 1 · Answer 1 · answered Aug 18 '17 at 17:59

1

use json_decode to make php assoc array from json string http://php.net/manual/ru/function.json-decode.php

answered Aug 18 '17 at 17:59

Max Deepfield

349
1
7

exussum · Accepted Answer · 2017-08-18T18:05:30.580

1

you need to json_decode the output, by default it will be objects, if you do

$balanceArr = json_decode($balanceArr, true);

above the code you posted, that will likely work

Your json is incorrectly formed also

$balanceArr[0]['available'][0]['amount']

Will work if your json string is valid (needs some commas and an array wrapping the whole thing)

edited Aug 18 '17 at 18:05

answered Aug 18 '17 at 18:00

exussum

18,275
8
32
65

1

I'd like to encourage you to _not_ answer questions like this, close as duplicate. Be a good steward of SO. – random_user_name Aug 18 '17 at 18:01

PHP: Get data from JSON?

2 Answers2