Parse JSON file using PHP/Laravel

Question

I have a JSON that I need to parse.

{
    "Room 251": {
        "calID": "igm4pfi6cc78ncvm5i3gv521snp0si82@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 318": {
        "calID": "9duielvutvv2b8d52ikgf8793pbn43sk@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 319 (Friends Room)": {
        "calID": "q5tj99a61g71eqcaboae6md0qahle2hv@import.calendar.google.com",
        "availMsg": "Available For Study"
        },

    "Room 323": {
        "calID": "josiglibstb75c88o4s4f2r3h4i3lagc@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 513 (Voinovich Room)": {
        "calID": "anjv4nfcr0b00sttbjp6cse5l7j0mvbe@import.calendar.google.com",
        "availMsg": "Available For Study"
        }
}

I need to obtain the room name, the calID, and the available message. What would be the best way to go about doing this in PHP/Laravel?

have you tried any thing to parse json using laravel or php ? — hassan, Mar 10 '17 at 14:00
json_decode() in PHP but I didn't know if there was a Laravel specific way of going about doing it. — Zach Tackett, Mar 10 '17 at 14:01
Laravel is built on PHP - same thing. Once you've got the data in your controller, you use PHP to get the data and manipulate it the same way you would in any other PHP bit. — Hanny, Mar 10 '17 at 14:03
`$data = json_decode($data, TRUE);` returns a multidimensional array. Any laravel specific way would be pointless as it would be an abstraction of this one liner — Brett Gregson, Mar 10 '17 at 14:04
There is no Laravel specific way of decoding a json object other than using the PHP's built-in function `json_decode`. — Dexter Bengil, Mar 10 '17 at 19:12

Lucas Martins · Accepted Answer · 2017-03-10T14:42:35.560

12

You can use json_decode to parse a json data.

mixed json_decode ( string $json [, bool $assoc ] )

For example:

$rooms = json_decode($yourJsonHere, true);

var_dump($rooms);

foreach($rooms as $name => $data) {
    var_dump($name, $data['calID'], $data['availMsg']); // $name is the Name of Room
}

edited Mar 10 '17 at 14:42

answered Mar 10 '17 at 14:07

Lucas Martins

508
6
9

That gives all of the rooms as a multidimensional array, which I already have. I need to get the values from the rooms and set them to variables – Zach Tackett Mar 10 '17 at 14:09
Why set them to variables? Why can't you use array? – Lucas Martins Mar 10 '17 at 14:15
Because I need them to be variables to pass later on. – Zach Tackett Mar 10 '17 at 14:27
Okay, do as you wish. – Lucas Martins Mar 10 '17 at 14:42
1

Marked yours as correct as it had the correct solution to what I was needing even though i didn't need the data set into an array. Thanks – Zach Tackett Mar 10 '17 at 19:13

score 1 · Answer 2 · answered Mar 10 '17 at 14:15

1

You can do something like that :

<?php
$json = '
{
    "Room 251": {
        "calID": "igm4pfi6cc78ncvm5i3gv521snp0si82@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 318": {
        "calID": "9duielvutvv2b8d52ikgf8793pbn43sk@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 319 (Friends Room)": {
        "calID": "q5tj99a61g71eqcaboae6md0qahle2hv@import.calendar.google.com",
        "availMsg": "Available For Study"
        },

    "Room 323": {
        "calID": "josiglibstb75c88o4s4f2r3h4i3lagc@import.calendar.google.com",
        "availMsg": "Open Computer Lab"
        },

    "Room 513 (Voinovich Room)": {
        "calID": "anjv4nfcr0b00sttbjp6cse5l7j0mvbe@import.calendar.google.com",
        "availMsg": "Available For Study"
        }
}';
foreach(json_decode($json) as $room_name => $room){
  echo $room_name.'<br/>'; // output the room name, for instead "Room 251"
  echo $room->calID.'<br/>'; // output the room calID
  echo $room->availMsg.'<br/>'; // output the room availMsg
}

 ?>

answered Mar 10 '17 at 14:15

Vincent G

8,547
1
18
36

`Trying to get property of non-object` – Zach Tackett Mar 10 '17 at 14:21
I've tested it, it works, are you sure you don't miss something while copy/paste it ? – Vincent G Mar 10 '17 at 14:25
`$cal_ID = $keys['calID']; $availMsg = $keys['availMsg']; echo $cal_ID; echo "
"; echo $availMsg; echo "
";` – Zach Tackett Mar 10 '17 at 14:26
don't you think that `$data = json_decode($json); foreach ($data .....` would be better ? @VincentG – hassan Mar 10 '17 at 14:34
Maybe it could be better in performance term, but I'm not sure. It provides the same output result though. – Vincent G Mar 10 '17 at 14:41

Parse JSON file using PHP/Laravel

2 Answers2