How to display nested JSON data in PHP

Question

this is my JSON

{"status":1,"error":0,"packet_list":[{"booked_packet_id":"22597002","booking_date":"29\/01\/2020","track_number":"LE782095573","track_number_short":"782095573","booked_packet_weight":"500","arival_dispatch_weight":"947","booked_packet_vol_weight_w":"0","booked_packet_vol_weight_h":null,"booked_packet_vol_weight_l":null,"booked_packet_no_piece":"1","booked_packet_collect_amount":"0.00","booked_packet_order_id":"Clothes","origin_country_name":"PAKISTAN\r","origin_city_name":"LAHORE","destination_city_name":"KARACHI","invoice_number":"IBLE5027089","invoice_date":"2020-02-18","shipment_name_eng":"Printed Mobile Covers","shipment_email":"[email protected]","shipment_phone":"03038518000","shipment_address":"HOUSE # 310 KAMRAN BLOCK ALLAMA IQBAL TOWN LAHORE","consignment_name_eng":"Umer Shabbir","consignment_email":null,"consignment_phone":"03312394595","consignment_phone_two":"0","consignment_phone_three":"0","consignment_address":"Ali Garh Bakery, PIB Colony near Jama Masjid Karachi","special_instructions":"Clothes Shahnaz Khala","booked_packet_status":"Delivered","status_remarks":"Array\/Array","Tracking Detail":[{"Status":"Shipment picked in LAHORE MAIN CITY","Activity_Date":"2020-01-29","Activity_Time":"22:50:57","Activity_datetime":"2020-01-29 22:50:57"},{"Status":"Dispatched to KHI MAIN OFFICE","Activity_Date":"2020-01-29","Activity_Time":"23:52:36","Activity_datetime":"2020-01-29 23:52:36"},{"Status":"Arrived at Station in KARACHI LOCAL","Reciever_Name":null,"Activity_Date":"2020-01-30","Activity_Time":"13:59:00","Reason":null,"Activity_datetime":"2020-01-30 13:59:00"},{"Status":"Assigned to courier in KARACHI LOCAL","Reciever_Name":null,"Activity_Date":"2020-01-31","Activity_Time":"08:33:12","Reason":null,"Activity_datetime":"2020-01-31 08:33:12"},{"Status":"Delivered","Reciever_Name":"UMER","Activity_Date":"2020-01-31","Activity_Time":"10:44:33","Reason":"SELF","Activity_datetime":"2020-01-31 10:44:33"}]}]}

and this is my JSON beautifier result via an online tool

Here is my php code to echo data

foreach ($arr['packet_list'] as $a){
    echo '<strong>Courier Name: </strong> Leopards Courier';
    echo '<br>';
    echo '<strong>Tracking #: </strong>' . $a['track_number'];
    echo '<br>';
    echo '<strong>Current Status: </strong>' . $a['booked_packet_status'];
    echo '<br>';
    echo '<br>';
    echo '<strong>Booking Date: </strong>' . $a['booking_date'];
    echo '<br>';
    echo '<strong>Customer Name: </strong>' . $a['consignment_name_eng'];
    echo '<br>';
    echo '<strong>Destination City: </strong>' . $a['destination_city_name'];
    echo '<br>';
    echo '<br>';
}

foreach ($arr['Tracking Detail'] as $b){
    echo '<strong>Status: </strong>' . $b['Status'];
}

The 'packet_list' loop returns everything perfect but the error is 'Tracking Detail' did not return anything. I want to display all data available in a Tracking Detail. How to do this?

Thank You

Markus AO · Accepted Answer · 2020-05-18 21:53:43Z

1

Tracking Detail isn't located at $arr['Tracking Detail']. It's located at $arr['packet_list'][0,1,2...]['Tracking Detail'], ie. it's a sub-array under each packet's array. For the simplest solution to output tracking details after each packet, using your code, nest the loops as follows:

foreach ($arr['packet_list'] as $a){
    echo '<strong>Courier Name: </strong> Leopards Courier';
    echo '<br>';
    echo '<strong>Tracking #: </strong>' . $a['track_number'];
    echo '<br>';
    echo '<strong>Current Status: </strong>' . $a['booked_packet_status'];
    echo '<br>';
    echo '<br>';
    echo '<strong>Booking Date: </strong>' . $a['booking_date'];
    echo '<br>';
    echo '<strong>Customer Name: </strong>' . $a['consignment_name_eng'];
    echo '<br>';
    echo '<strong>Destination City: </strong>' . $a['destination_city_name'];
    echo '<br>';
    echo '<br>';

    // Notice how we're using **$a**['Tracking Detail'] here.
    foreach ($a['Tracking Detail'] as $b){
        echo '<strong>Status: </strong>' . $b['Status'];
    }
}

answered May 18, 2020 at 21:53

Markus AO

4,8892 gold badges20 silver badges29 bronze badges

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

2 Comments

Anas Khan Over a year ago

Can you please help me to echo the data available in this screenshot: i.imgur.com/ijpvLCY.png ... I need to echo data in TrackInfo and DeliveryInfo ... THANKS

Markus AO Over a year ago

What difficulties are you having? Please try first -- understanding the structure of your data -- and let us know what goes wrong.

jabubo · Accepted Answer · 2020-05-18 21:53:38Z

0

Your structure match not with your code. Move Tracking Detail in your json or adjust your code to loop over $arr['packet_list']['Tracking Detail'].

answered May 18, 2020 at 21:53

jabubo

1799 bronze badges

1 Comment

Markus AO Over a year ago

That wouldn't work, you'd need $arr['packet_list'][0]['Tracking Detail'], etc. Mind the structure of the data: [packet_list] => [ [0] => [ [booked_packet_id] => 22597002 ... [Tracking Detail] => [...

Collectives™ on Stack Overflow

How to display nested JSON data in PHP

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related