I want to store array in mysql database. with key and value
Following are code i used
$name= "prashant";
$lname= "kumbhar";
$test = "testing";
$array = array('fname'=>$name,'lname'=>$lname,'test' =>$testing);
Store these $array in database using php
Use json_encode() to store data in mysql table.
<?php
$name= "prashant";
$lname= "kumbhar";
$test = "testing";
$array = array('fname'=>$name,
'lname'=>$lname,
'test' => $test
);
$res = json_encode($array);
echo "Convert from array to json :" .$res;
echo "\n\nFrom json to array:\n";
print_r(json_decode($res));
output
Convert from array to json :
{"fname":"prashant","lname":"kumbhar","test":"testing"}
From json to array:
stdClass Object
(
[fname] => prashant
[lname] => kumbhar
[test] => testing
)
At the time of retrieve data in array form then use json_decode()
Working Demo : Click Here
You can serialize the array and store the string in the database:
serialize ($array);
If you want to use it just unserialize the result that you've get from the database
$array = unserialize ($databaseResult);
If you prefer json you can do the same with json_encode and json_decode
use convert array into json format using json_encode and then store in database, you can convert json string format back to array using json_decode. Example
$name= "prashant";
$lname= "kumbhar";
$test = "testing";
$array = array('fname'=>$name,'lname'=>$lname,'test' = $testing);
$data_for_db = json_endcode($array);
You can convert stored json format data back to normal array as below
$array = json_decode($data_for_db);
Thanks
serialize