How to Store Array in Mysql Using PHP

Question

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

You should have a look at [`serialize`](http://php.net/serialize) — secelite, Nov 16 '16 at 09:18
Funny, if I Google that title of yours I see [this](http://stackoverflow.com/questions/1978438/save-php-array-to-mysql). Please tell me, how were you unable to find this? — Xorifelse, Nov 17 '16 at 02:14

RJParikh · Accepted Answer · 2016-11-16T09:23:01.450

5

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

edited Nov 16 '16 at 09:23

answered Nov 16 '16 at 09:12

RJParikh

4,096
1
19
36

can i store directly $result = json_encode($array); like this – Prashant Kumbhar Nov 16 '16 at 09:19
you need to store $result data/output in database – RJParikh Nov 16 '16 at 09:21

score 4 · Answer 2 · answered Nov 16 '16 at 09:06

4

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

answered Nov 16 '16 at 09:06

jurruh

119
6

when i use serialize array then data goes 0 and user unserialize then data store a:15:{s:18:"electricity_backup";s:18:"electricity backup";s:15:"air_conditioned";s:15:"air conditioned";s:22:"djcredit_card_accepted";} – Prashant Kumbhar Nov 16 '16 at 09:14
I'm not sure what you mean but you can save that serialized string to the database – jurruh Nov 16 '16 at 09:18

score 0 · Answer 3 · answered Nov 16 '16 at 09:57

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

How to Store Array in Mysql Using PHP

3 Answers3