PHP foreach - parsed json from URL

Question

I have a JSON file called from an URL. I've checked and I'm getting the the data from the URL.
I've tried a lot, but I can't get the loop foreach to work - what is wrong?

<?php

$url = 'http://banen.klintmx.dk/json/ba-simple-proxy.php?url=api.autoit.dk/car/GetCarsExtended/59efc61e-ceb2-463b-af39-80348d771999';
$json= file_get_contents($url);

$data = json_decode($json);
$rows = $data->{'contents'};
foreach($rows as $row) {
echo '<p>';
$FabrikatNavn = $row->{'contents'}->{'FabrikatNavn'};
$ModelNavn = $row->{'contents'}->{'ModelNavn'};
$PrisDetailDkk = $row->{'contents'}->{'PrisDetailDkk'};
echo $FabrikatNavn . $ModelNavn . ' Pris ' . $PrisDetailDkk;
echo '</p>';
}

?>

I've never seen a notation like this $data->{'contents'} in PHP. What is the error message? — dialogik
– dialogik, Commented Jun 11, 2014 at 12:21
You can replace $data->{'contents'} with $data->contents. The syntax is used, if you want to access dynamic properties, like $data->{$otherVar} — Balázs Édes
– Balázs Édes, Commented Jun 11, 2014 at 12:24

Rikesh · Accepted Answer · 2014-06-11 12:29:15Z

1

The actual problem is you trying to access content object again. Just change your foreach snippet with,

foreach ($rows as $row) {
    echo '<p>';
    $FabrikatNavn = $row->FabrikatNavn;
    $ModelNavn = $row->ModelNavn;
    $PrisDetailDkk = $row->PrisDetailDkk;
    echo $FabrikatNavn . $ModelNavn . ' Pris ' . $PrisDetailDkk;
    echo '</p>';
}

DEMO.

answered Jun 11, 2014 at 12:29

Rikesh

26.5k14 gold badges82 silver badges90 bronze badges

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

Comments

dialogik · Accepted Answer · 2014-06-11 12:29:43Z

1

Use json_decode($data, true) so that it parses the JSON content into a PHP array. So it will be something like

$rows = $data['contents'];
foreach($rows as $row) {
    echo '<p>';
    $FabrikatNavn = $row['contents']['FabrikatNavn'];
    $ModelNavn = $row['contents']['ModelNavn'];
    $PrisDetailDkk = $row['contents']['PrisDetailDkk'];
    echo $FabrikatNavn . $ModelNavn . ' Pris ' . $PrisDetailDkk;
    echo '</p>';
}

edited Jun 11, 2014 at 12:29

answered Jun 11, 2014 at 12:23

dialogik

9,59218 gold badges79 silver badges122 bronze badges

2 Comments

Balázs Édes Over a year ago

json_decode($contents, true) does what you said. otherwise the associative parts will be objects.

dialogik Over a year ago

Thanks for the info, didn't know that. I modified my answer accordingly.

user2339252 · Accepted Answer · 2014-06-17 01:22:04Z

1

Take a look at using json_decode($json, true) as this will convert the data to an associative array which seems to be the way you are approaching the solution.

Check the output by printing with var_dump() or print_r()

edited Jun 17, 2014 at 1:22

user2339252

877 bronze badges

answered Jun 11, 2014 at 12:26

Ian Lewis

1,31113 silver badges18 bronze badges

Comments

A l w a y s S u n n y · Accepted Answer · 2014-06-11 12:28:30Z

0

Try like this

$data = json_decode($json,true); //decode json result as array and thenloop it
print '<pre>';
print_r($data);
foreach($data as $row){
//do something here
}

answered Jun 11, 2014 at 12:28

A l w a y s S u n n y

38.8k9 gold badges68 silver badges120 bronze badges

Collectives™ on Stack Overflow

PHP foreach - parsed json from URL

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related