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

Funny, if I Google that title of yours I see this. Please tell me, how were you unable to find this? — Xorifelse
– Xorifelse, Commented Nov 17, 2016 at 2:14

RJParikh · Accepted Answer · 2016-11-16 09:23:01Z

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, 2016 at 9:23

answered Nov 16, 2016 at 9:12

RJParikh

4,1661 gold badge24 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Prashant Kumbhar Over a year ago

can i store directly $result = json_encode($array); like this

RJParikh Over a year ago

you need to store $result data/output in database

jurruh · Accepted Answer · 2016-11-16 09:06:43Z

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, 2016 at 9:06

jurruh

1196 bronze badges

2 Comments

Prashant Kumbhar Over a year ago

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";}

jurruh Over a year ago

I'm not sure what you mean but you can save that serialized string to the database

Shyam · Accepted Answer · 2016-11-16 09:57:46Z

0

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

answered Nov 16, 2016 at 9:57

Shyam

3101 gold badge6 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to Store Array in Mysql Using PHP

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related