How to insert json array into mysql database with php

If you want to store the array as a string, you can use JSON.stringify():

$string = [{"name":"peter","phone":"dsf","city":"sdfsdf","email":"dsf"},{"name":"111","phone":"222","city":"hn","email":"[email protected]"}];    
$json = JSON.stringify($string);

The variable $json is then a simple string which can be inserted into MySQL easily.

You can then use:

var obj = JSON.parse($json);

To convert the string back to an array.

This method usually isn't recommended for performance reasons though, so you might alternatively want to break up the array and store each field individually.

Try this:

 $json = serialize(json_array);

Use $jsonArray = json_decode($jsonStr);. Then iterate the array as you want to save data in your mysql database.

you can use - serialize()

$json = '[{"name":"peter","phone":"dsf","city":"sdfsdf","email":"dsf"},{"name":"111","phone":"222","city":"hn","email":"[email protected]"}]';
$newJson = serialize(json_decode($json));

$newJson is ready to be inserted. and after fetching -

$data = unserialize($fetchedData); and then json_encode($data);