Printing data retrieved from json file
In our previous tutorials we have shown you how to retrieve database information, encode and print it to json file. Now, we will learn how to decode the same json file and print it to user interface stream. If you look and json data format below this is exactly what we retrieve from our database. Put the json file in the same folder where the next php code will be placed. Below is example of our json file named data.json for this testing.
<![CDATA[
{
"id": "1",
"image": "image\/chiquado.jpg",
"fullname": "Kenan Chiquado",
"fulladdress": "Udah, Igbo-eze North LGA, Enugu state, Nigeria",
"emailaddress": "2348130802790",
"phonenumber": "presschiquado@gmail.com",
"username": "Chikwado",
"password": "web@design&33",
"project": "Local and public network developer",
"subscription": "0.00",
"gender": "Male",
"reg_date": "2023-03-27 10:18:48"
}
]]>
Our php script to grab and open json file
If you look at the php code below it has been prepared ready to copy and paste for testing. First, we will use php function object file_get_contents() to get json file and use php function object json_decode() to decode json file and print it on user interface stream. Now, copy the code below save it as jsondecode.php and run it to see the output.
<![CDATA[
<!--php
$data = file_get_contents("data.json");
$prof = json_decode($data, true);
$id = $prof['id'];
$image = $prof['image'];
$fullname = $prof['fullname'];
$fulladdress = $prof['fulladdress'];
$emailaddress = $prof['emailaddress'];
$phonenumber = $prof['phonenumber'];
$username = $prof['username'];
$password = $prof['password'];
$project = $prof['project'];
$subscription = $prof['subscription'];
$gender = $prof['gender'];
$reg_date = $prof['reg_date'];
echo "<p-->".$id."</p>";
echo "<p>".$image."</p>";
echo "<p>".$fullname."</p>";
echo "<p>".$fulladdress."</p>";
echo "<p>".$emailaddress."</p>";
echo "<p>".$phonenumber."</p>";
echo "<p>".$username."</p>";
echo "<p>".$password."</p>";
echo "<p>".$project."</p>";
echo "<p>".$subscription."</p>";
echo "<p>".$gender."</p>";
echo "<p>".$reg_date."</p>";
?>
]]>
Json decode data on user interface stream
After decoding json data the below is the output of our json file. If the above return error or if you see error message from php, let us know so will look into it.
<![CDATA[
1
image/chiquado.jpg
Kenan Chiquado
Udah, Igbo-eze North LGA, Enugu state
presschiquado@gmail.com
2348130802790
Chikwado
web@design&33
Local and public network developer
0.00
Male
2023-03-27 10:18:48
]]>
Summary
In the above tutorials almost everything is already made for testing purposes. If you encounter error don't hesitate to post your question in comment box below. We are ready to answer your questions. Thanks for reading and practicing with us.
Comments