how to store json data in mysql using php?

Today, We want to share with you how to store json data in mysql using php.In this post we will show you json to mysql php, hear for fetch json data and insert into mysql table in php we will give you demo and example for implement.In this post, we will learn about php mysql store json with an example.

How to Insert JSON Data into MySQL using PHP?

What is JSON File Format?

JSON file simple data contains details stored in JSON format as well as has the extension of “*.json”. JSON stands for JavaScript Object Notation as well as is a light weight data interchange format. Being less cluttered as well as more readable than XML, it has become an simply alternative main json data format to store as well as interchange data. All latest browsers supports like a fresh JSON format.

here bellow we will display simple Example of a JSON File.


    "memberid": "SJ011MS",
    "memberdtl": {
        "name": "Virat Kohali",
        "gender": "Male",
        "age": "29",
        "location": {
            "streetlocation": "7 24th Street",
            "city": "India",
            "state": "IN",
            "zipcode": "20038"
    "profile": {
        "appointment": "Dipti Shah",
        "sector": "Computer"

Step 1: Connect PHP to MySQL Database

Step 2: Read the JSON file in PHP

Step 3: Convert JSON String into PHP Array

Step 4: Extract the Array Values

Step 5: Insert JSON to MySQL Database with PHP Code

Full PHP Script


I hope you get an idea about php mysql store json.
I would like to have feedback on my blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Leave a Comment