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.

Also Read This πŸ‘‰   How to Create a Wordpress Plugin in 10 Minutes Flat

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);

Free Live Chat for Any Issue

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.

Rate this post

Also Read This πŸ‘‰   Woocommerce Get product category name in array