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.