Parsing a JSON file using PHP

Question

I have been given a JSON file that I need to parse. I am doing some work for a hotel, and the end goal is to build a table that lists:

Room Number
Adult Content (enabled or disabled)
Room Charges (enabled or disabled)
Status (occupied or unoccupied)

The JSON file, I have no control over. It is given to me, and from there I have to create the layout noted above.

This is an example of the JSON file I am given (it is only part of the file, but you will understand how it works from this sample):

{
   "apiVersion" : "0.1",
   "data" : {
      "roomCount" : 105,
      "rooms" : [
         {
            "room_number" : "104",
            "services" : [
               {
                  "adult" : {
                     "enabled" : true
                  },
                  "room_charges" : {
                     "enabled" : true
                  }
               }
            ],
            "status" : "OCCUPIED"
         },
         {
            "room_number" : "105",
            "services" : [
               {
                  "adult" : {
                     "enabled" : true
                  },
                  "room_charges" : {
                     "enabled" : false
                  }
               }
            ],
            "status" : "OCCUPIED"
         },
         {
            "room_number" : "106",
            "services" : [
               {
                  "adult" : {
                     "enabled" : false
                  },
                  "room_charges" : {
                     "enabled" : true
                  }
               }
            ],
            "status" : "OCCUPIED"
         },
         {
            "room_number" : "107",
            "services" : [
               {
                  "adult" : {
                     "enabled" : false
                  },
                  "room_charges" : {
                     "enabled" : false
                  }
               }
            ],
            "status" : "OCCUPIED"

What I have done thus far:

I have tried to parse the data, and I can get the data to display, however, I am having trouble laying it out exactly the way I need it to look as stated above. Currently, my parse script outputs this:

data
roomCount: 105 

rooms
0
room_number: 104 

services
0
adult
enabled: 1 

room_charges
enabled: 1 

status: OCCUPIED

I need it to NOT display the key for the nested array, "Services." What I would like as I said above is for the output to look like this:

Room Number: 104 
Adult: Enabled or Disabled (depending on true or false) 
Room Charges: Enabled or Disabled (depending on true or false)
Status: OCCUPIED or UNOCCUPIED

And finally, here is the code that I have completed so far:

<?php
$string = file_get_contents("test.json");
$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($string, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);

foreach ($jsonIterator as $key => $val) {
    if(is_array($val)) {
        echo "<br> $key";
    } else {
        echo "<br> $key: $val <br>";
    }
}

?>

I am looking for some refinement on outputting the data in a cleaner way. If you can help or give me any suggestions/advice I will greatly appreciate it.

The file is 1478 lines of code. 37kb. I am looking for help on the output. I need it to mirror what I have explained in my question, in a clean and neat user-friendly way. — ValleyDigital
– ValleyDigital, Commented Oct 1, 2014 at 0:00

BojanT · Accepted Answer · 2014-10-01 00:07:13Z

2

Here is json decoded as Object

$arr = json_decode($jsonString);
$out = "";
foreach ($arr->data->rooms as $k => $v) {
    $adult = $v->services[0]->adult->enabled == 'true' ? 'Enabled' : 'Disabled';
    $room = $v->services[0]->room_charges->enabled == 'true' ? 'Enabled' : 'Disabled';
    $out .="Room Number: $v->room_number\n";

    $out .="Adult: $adult\n";
    $out .="Room Charges: $room\n";
    $out .="Status: $v->status\n";
    $out .= "----\n";
}
echo $out;

Tested and here is an output

Room Number: 104
Adult: Enabled
Room Charges: Enabled
Status: OCCUPIED
----
Room Number: 105
Adult: Enabled
Room Charges: Disabled
Status: OCCUPIED
----
Room Number: 106
Adult: Disabled
Room Charges: Enabled
Status: OCCUPIED
----

answered Oct 1, 2014 at 0:07

BojanT

8011 gold badge6 silver badges12 bronze badges

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

1 Comment

ValleyDigital Over a year ago

Thank you! This is exactly what I needed and the output is perfect.

James · Accepted Answer · 2014-10-01 00:07:34Z

1

Basically you just need to check if the keys and values are set:

$jsonIterator = new RecursiveIteratorIterator(
    new RecursiveArrayIterator(json_decode($json, TRUE)),
    RecursiveIteratorIterator::SELF_FIRST);

foreach ($jsonIterator as $key=>$value) {
    if($key === 'room_number') {
        echo "Room Number: " . $value . "<br />";
    }
    if($key === 'adult') {
        echo "Adult: " . $value['enabled'] . "<br />";
    }
    if($key === 'status') {
        echo "status: " . $value . "<br />";
    }
}

answered Oct 1, 2014 at 0:07

James

8707 silver badges29 bronze badges

Comments

Kevin · Accepted Answer · 2014-10-01 00:19:43Z

For illustrational purposes you could just use a table or a description list on this case. The UI is up to you:

<?php

$response = '{ "apiVersion": "0.1", "data": { "roomCount": 105, "rooms": [ { "room_number": "104", "services": [ { "adult": { "enabled": true }, "room_charges": { "enabled": true } } ], "status": "OCCUPIED" }, { "room_number": "105", "services": [ { "adult": { "enabled": true }, "room_charges": { "enabled": false } } ], "status": "OCCUPIED" }, { "room_number": "106", "services": [ { "adult": { "enabled": false }, "room_charges": { "enabled": true } } ], "status": "OCCUPIED" }, { "room_number": "107", "services": [ { "adult": { "enabled": false }, "room_charges": { "enabled": false } } ], "status": "OCCUPIED" } ] }}';
$data = json_decode($response, true);

?>

<style type="text/css">/*DL, DT, DD TAGS LIST DATA*/dl { margin-bottom:50px;} dl dt { background:#5f9be3; color:#fff; float:left; font-weight:bold; margin-right:10px; padding:5px; width:150px; } dl dd { margin:2px 0; padding:5px 0;}</style>
<dl>
<?php foreach($data['data']['rooms'] as $info): ?>
    <dt>Room Number: </dt>
    <dd><?php echo $info['room_number']; ?></dd>
    <?php $services = reset($info['services']); ?>
    <dt>Adult: </dt>
    <dd><?php echo ($services['adult']['enabled'] == 1) ? 'ENABLED' : 'DISABLED'; ?></dd>
    <dt>Room Charges: </dt>
    <dd><?php echo ($services['room_charges']['enabled'] == 1) ? 'ENABLED' : 'DISABLED'; ?></dd>
    <dt>Status: </dt>
    <dd><?php echo $info['status']; ?></dd><br/>
<?php endforeach; ?>
</dl>

Collectives™ on Stack Overflow

Parsing a JSON file using PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related