Parsing part of a json object with multi levels using PHP

Question

If you open the URL, you'll see that it's a very long string of sub objects. I want to extract the values for the 70 position. So far I've been able to extract the first tree without a problem ... But if you go deeper then I don’t get any feedback at all. Please check the code below and tell me, what am I doing wrong?

$url= "https://bwt.cbp.gov/api/waittimes";

$port = file_get_contents($url); // put the contents of the file into a variable
$data = json_decode($port); // decode the JSON feed

echo $data[69]->port_name.'<br>';
echo $data[69]->port_status.'<br>';
echo $data[69]->passenger_vehicle_lanes->maximum_lanes.'<br>';
echo $data[69]->passenger_vehicle_lanes->standard_lanes->lanes_open.'<br>';

Hi, can you try to change json_decode($port, true); like this and access it like in array echo $data[69]['passenger_vehicle_lanes']['maximum_lanes'].'<br>'; — Oleksandr Pobuta
– Oleksandr Pobuta, Commented Jul 7, 2018 at 7:33
Your first suggestion worked perfectly. Boy am I glad you helped me. — Samuel Ramzan
– Samuel Ramzan, Commented Jul 7, 2018 at 7:41
I tried the code above (PHP 7.0.13) and I get the correct data "San Ysidro, Open, 24" from what I can see. There's no other code in the script that could interfere? — becquerel
– becquerel, Commented Jul 7, 2018 at 7:41
Well yes that's as far as it goes. The fourth line is not showing the results.. (lanes_open) — Samuel Ramzan
– Samuel Ramzan, Commented Jul 7, 2018 at 7:48

koalaok · Accepted Answer · 2018-07-07 08:18:53Z

1

The following is working for me:

$url= "https://bwt.cbp.gov/api/waittimes";

$port = file_get_contents($url); // put the contents of the file into a variable
$data = json_decode($port, true); // decode the JSON feed


echo "There are ".count($data)."Ports".PHP_EOL;


$found=false;
foreach ($data as $key => $value) {
     //EDIT AFTER COMMENT**
     if($value['port_number']==250401){
        echo $value['port_name'].' '.$value['crossing_name'].PHP_EOL;
        $found=true;
        break;
     }
}


if(!$found) echo "couldn't find port #";

edited Jul 7, 2018 at 8:18

answered Jul 7, 2018 at 7:48

koalaok

5,85012 gold badges63 silver badges96 bronze badges

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

6 Comments

Samuel Ramzan Over a year ago

Nice, but I was looking for a specific chunk of information within the string, I like your code tough, good job.

koalaok Over a year ago

This was just an example on how to scan your data... About the specific part you're looking for at the 70th position... I would be careful about relying on the order provided by an external service... I recommend to find it through a unique ID, not by position....

Samuel Ramzan Over a year ago

Ok... now that sounds interesting... How would you go about it.. if<port_number>250401 then echo <port_name>and<crossing_name/>And<hours> (Not meant to be rude).. You really stirred my interest.

koalaok Over a year ago

Since your answer doesnt fit for indexing on port_number the only solution I see is to scan the answer and return the wanted result... see my edit

koalaok Over a year ago

I added also a check if nothing is found.... breaking the loop is ok if you're sure there's only one result.... otherwise you should continue and return the whole list of matching results...

|

Oleksandr Pobuta · Accepted Answer · 2018-07-07 07:44:08Z

1

can you try to change json_decode($port, true); (true will change object to array and it will be better to access it) like this and access it like in array echo $data[69]['passenger_vehicle_lanes']['maximum_lanes'].'<br>';

answered Jul 7, 2018 at 7:44

Oleksandr Pobuta

4045 silver badges12 bronze badges

1 Comment

Samuel Ramzan Over a year ago

Excellent approach,it worked perfectly. Thank You Olexander, You rock.

Collectives™ on Stack Overflow

Parsing part of a json object with multi levels using PHP

2 Answers 2

6 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related