Posted inphp / JavaScript / Mysql / Mysqli

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 import json to mysql using php script, hear for json to mysql php.

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 MySQLi Database Connection with an example.

Step 1: Read the JSON file in PHP

read the json file contents

$memberjsondata = file_get_contents('members.json');

Step 2: Convert JSON String into PHP Array

convert json object to php associative array

$data = json_decode($memberjsondata, true);

Step 3: Extract the Array Values in Variables

get the member details

$id = $data['memberId'];
$name = $data['peopleinfo']['name'];
$age = $data['peopleinfo']['age'];
$streetaddress = $data['peopleinfo']['address']['streetaddress'];
$task = $data['peopleinfo']['address']['task'];
$branch = $data['peopleinfo']['address']['branch'];
$postalcode = $data['peopleinfo']['address']['postalcode'];

Step 4: Insert JSON to MySQL Database with PHP Code

insert into mysql table

$sql = "INSERT INTO tbl_members(memberId, name, age, streetaddress, task, branch, postalcode)
    VALUES('$id', '$name', '$age', '$streetaddress', '$task', '$branch', '$postalcode')";
if(!mysqli_query($con, $sql))
{
    die('Error : ' . mysql_error());
}

members.json

{
    "memberId": "MT00985",
    "peopleinfo": {
        "name": "Rahul Mehta",
        "age": "32",
        "address": {
            "streetaddress": "9 12th Street",
            "task": "Komidaiya",
            "branch": "KD",
            "postalcode": "360002"
        }
    }
}

I hope you get an idea about how to store json data in mysql using php.
I would like to have feedback on my infinityknow.com 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.

I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.

Leave a Reply

Your email address will not be published. Required fields are marked *

We accept paid guest Posting on our Site : Guest Post Chat with Us On Skype