How to Export MySQL Data Into JSON Format in PHP

Hi guys. Today I will explain how to create or export data from a MySQL database into JavaScript Object Notation (JSON) format using PHP.





Note:Now you can read it on my blog.I have updated this article on my personal blog here.


JSON

JSON is a lightweight data-interchange format. It is easy for humans to read and write. It is easy for machines to parse and generate. it's lightweight, readable and easily manageable for exchanging data across various platforms.

Now a days most of the social networking application APIs like Facebook and Twitter use JSON as data exchange format.

A JSON Array starts with "[" and ends with "]". Between them, a number of values can reside. If there are more than one value then they are separated by ",".

For example:

JSON Object

An object starts with "{" and ends with "}". Between them, a number of string name/value pairs can reside. The name and value is separated by a ":" and if there is more than one name/value pairs then they are separated by ",".

For example:

{"id":"1","name":"Ehtesham","roll_no":"131","degree":"BSCS"}

PDO

The PHP Data Objects (PDO) extension defines a lightweight, consistent interface for accessing databases in PHP. PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data. You just need to change the database drivers. Let's start with it. Reference by PHP.

Student table:



With SQL query