Php Json Decode - Display value of second level items

Question

I'm trying to decode JSON format My API Endpoint is https://api.reliableserver.host/api/landings

And this is the output

{
    "success": true,
    "data": [
        {
            "id": 1,
            "primary_balance": "$4,184.37",
            "primary_currency": "USD",
            "secondary_balance": "¥0",
            "secondary_currency": "JPY",
            "tertiary_balance": "฿0.00",
            "tertiary_currency": "THB",
            "first_language": "ไทย",
            "second_language": "English",
            "footer_text": "a",
            "created_at": "2020-10-26T07:45:49.000000Z",
            "updated_at": "2020-10-28T05:31:04.000000Z",
            "deleted_at": null
        }
    ],
    "message": "Landings retrieved successfully"
}

I need to echo individual values, for example: Primary Balance: $4,184.37

I tried using this:

$url = "https://api.reliableserver.host/api/landings";
    
$obj = json_decode($url);
    
echo $obj>primary_balance;

But it didnt work, kindly guide me what am I doing wrong.

you need to fetch the values coming from that url first, then you decode the results. you could use file_get_contents or implement the cURL lib in PHP — Kevin
– Kevin, Commented Oct 28, 2020 at 6:04

STA · Accepted Answer · 2020-10-28 06:30:07Z

2

You can do this way :

$url = '{"success": true,"data": [{"id": 1,"primary_balance": "$4,184.37","primary_currency": "USD","secondary_balance": "¥0","secondary_currency": "JPY","tertiary_balance": "฿0.00","tertiary_currency": "THB","first_language": "ไทย","second_language": "English","footer_text": "a","created_at": "2020-10-26T07:45:49.000000Z","updated_at": "2020-10-28T05:31:04.000000Z","deleted_at": null}],"message": "Landings retrieved successfully"}';
$obj = json_decode($url, true);
echo $obj['data'][0]['primary_balance'];
// output $4,184.37

Above code tested here

You need file_get_contents() method to get the JSON data from your given URL.

$url = "https://api.reliableserver.host/api/landings";
$obj = json_decode(file_get_contents($url), true);
echo $obj['data'][0]['primary_balance'];
// output $4,184.37

edited Oct 28, 2020 at 6:30

answered Oct 28, 2020 at 6:10

STA

35.3k9 gold badges49 silver badges62 bronze badges

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

5 Comments

OMR Over a year ago

thanks @sta I did not know about rextester until now

El B. Over a year ago

this is great, it worked perfectly. I used it for the landing page.

El B. Over a year ago

One question, I have another similar endpoint but with multiple data. I implemented your method and it worked to display the first chunk of data, but how do i go about doing a for each so i can display all the data and not just the first one. this is the endpoint in questions: api.reliableserver.host/api/recent_activities

STA Over a year ago

@ElB. Its really hard to tell you without see the code, I suggest you to ask a new question, so that we can help you :)

El B. Over a year ago

Please check it here, I asked my friend at the office to post instead, cz my account is still new. stackoverflow.com/questions/64567941/…

Chirag Kamat · Accepted Answer · 2020-10-28 06:21:08Z

0

Basically, you are not calling that api anywhere. If it is an open endpoint (without auth or headers, you can do file_get_contents() or I suggest you to use curl. Also, you need to check on response data structure, it has a 'data' key which is an array. so you need to use foreach to iterate on the 'data' key.

I have given a sample answer that should work if there is only 1 item in data.

    $url = "https://api.reliableserver.host/api/landings";
    $resp = file_get_contents($url);
    $obj= json_decode($resp);// will return in object form
    echo $obj->data[0]->primary_balance;

or

$url = "https://api.reliableserver.host/api/landings";
$resp = file_get_contents($url);
$obj= json_decode($resp, true); // will return in array form
echo $obj['data'][0]['primary_balance'];

json_decode()

answered Oct 28, 2020 at 6:21

Chirag Kamat

1091 silver badge12 bronze badges

1 Comment

El B. Over a year ago

what if i have more than one item in my data, how do i go about doing for each? this si the endpoint in questions api.reliableserver.host/api/recent_activities

Collectives™ on Stack Overflow

Php Json Decode - Display value of second level items

2 Answers 2

5 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related