how to insert json data into mysql using php : PHP Script read JSON file contents and Insert into MySQL.
how to insert json data into mysql using php
first of all, created a Multi JSON file and write the file by the PHP source code. Creating Data in the JSON Field. Now, you are going to make products to add to the database using INSERT INTO and VALUES.
Do you want to know how a JSON file looks like? Well here is the sample json Data File.
{ "memberid": "SJ011MS", "individual": { "name": "Virat Kohali", "gender": "Male", "age": "32", "apartment": { "streetapartment": "8 19th Street", "city": "Gujrat", "state": "GJ", "zip": "10038" } }, "account": { "appointment": "Manager Sinors", "section": "Finance" } }
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
Don’t Miss : how to store json data in mysql using php
Insert JSON data into MySQL using php
Complete PHP Script (index.php)
memberdetails.json
{ "memberid": "SJ011MS", "individual": { "name": "Virat Kohali", "gender": "Male", "age": "28", "apartment": { "streetapartment": "8 19th Ambuja", "city": "Rajkot", "state": "GJ", "zip": "360002" } }, "account": { "appointment": "Deputy General", "section": "Finance" } }
I hope you get an idea about how to insert json data into 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.