using remote json file in php code

Question

To get the details with regards to "ID", I have prepared the following PHP with json array inside it. It is working perfectly.

<?php
$json = '{"records": 
       [
         {"Name":"Jhon", "Age":"45", "id":"101"},
         {"Name":"Bhil", "Age":"42", "id":"102"},
         {"Name":"Tone", "Age":"41", "id":"103"},
       ]
    }';

$myjson = json_decode($json, true);  
  foreach ( $myjson['records'] as $row ) {  
                        if ($row['id'] =='216') { 
                         echo 'Details of  login id:&nbsp;'.  $row['id']. '<br/>';
                         foreach ( $row as $field => $value ) {  // loop the fields
                               // do the work here
                             }
                   }
         }
?>

Now for one of my project, i have to crete arround 750 Ids with various vaules. Putting all these inside php file may slow down the page loading.

Hence, I have craeted json file(remote): xyz.com/dir/jsondata.json

Kindly guide me, how to incopporate the above json file in the php code.

file_get_contents() should work fine for this.

Michael Doye
– Michael Doye

2015-03-12 05:51:50 +00:00
Commented Mar 12, 2015 at 5:51 — Michael Doye
– Michael Doye, Commented Mar 12, 2015 at 5:51

Solid I · Accepted Answer · 2015-03-12 05:50:12Z

1

file_get_contents() is what you're looking for. It will put the entire contents of the file into a string.

$json = file_get_contents('dir/jsondata.json');

answered Mar 12, 2015 at 5:50

Solid I

6905 gold badges14 silver badges35 bronze badges

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

5 Comments

user3410277 Over a year ago

In case the remote file is csv: like xyz.com/dir/data.csv

Solid I Over a year ago

file_get_contents() will work with any file type. If using a CSV file, you'd have to parse through the string to create your JSON array.

user3410277 Over a year ago

Is so, how to create the json array from the csv file

Solid I Over a year ago

That is a whole new question entirely. I suggest you ask a new question and post a link to it here.

user3410277 Over a year ago

stackoverflow.com/questions/29003164/…

Karthick Kumar · Accepted Answer · 2015-03-12 05:49:21Z

0

fetch the file using $data=file_get_contents('xyz.com/dir/jsondata.json'); and then use the decode the json and loop through it

$myjson = json_decode($data, true);  
  foreach ( $myjson['records'] as $row ) {  
                        if ($row['id'] =='216') { 
                         echo 'Details of  login id:&nbsp;'.  $row['id']. '<br/>';
                         foreach ( $row as $field => $value ) {  // loop the fields
                               // do the work here
                             }
                   }
         }

answered Mar 12, 2015 at 5:49

Karthick Kumar

2,3751 gold badge19 silver badges30 bronze badges

2 Comments

user3410277 Over a year ago

My question is: whether the remote json file is fast loading comaparing to json array inside php?

Solid I Over a year ago

It would be slightly faster to include the json array within the php file rather than using file_get_contents()

Collectives™ on Stack Overflow

using remote json file in php code

2 Answers 2

5 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related