MySQL save array in the db

Question

Is it possible to store an associative array as it is in the db?

array(
       key  => value,
       key2 => value2,
       key3 => value3,
       ...
      )

Currently, if I write fieldname = '$array', only the string "Array" is stored in the field.

you will need to flatten it serialize could work or some encode / decode method — Anigel, Jul 15 '14 at 08:25
@kevinabelita. the array keys are not the same as the fields in db table. — Adil Abbas, Jul 15 '14 at 08:28
[this](http://stackoverflow.com/questions/804045/preferred-method-to-store-php-arrays-json-encode-vs-serialize) might give some perspective, this does not cover database insertion though, please avoid `mysql_` — user1978142, Jul 15 '14 at 08:29
@Anigel, json encoding / decoding will just do fine. Thankyou for the suggestion. — Adil Abbas, Jul 15 '14 at 08:35
yes! in my case, json encode / decode is the way indeed! Thanks @kevinabelita — Adil Abbas, Jul 15 '14 at 08:39

score 0 · Accepted Answer · answered Jul 15 '14 at 08:24

0

Try this

fieldname = json_encode($array);

and when you want to retrieve from database then use

$array = json_decode($fieldname);

answered Jul 15 '14 at 08:24

Sadikhasan

18,365
21
80
122

this is in fact solved it! My bad, I was not thinking that way. Thanks! – Adil Abbas Jul 15 '14 at 08:36

score 0 · Answer 2 · answered Jul 15 '14 at 08:26

0

You can also do this:

serialize($array);

and then when you fetch it from the database:

unserialize($array);

answered Jul 15 '14 at 08:26

Jonan

2,485
3
24
42

score 0 · Answer 3 · answered Jul 15 '14 at 08:26

0

Do use

$fieldname = json_encode($array);

answered Jul 15 '14 at 08:26

Torrezzzz

307
2
13

Chirag Shah · Answer 4 · 2014-07-15T08:35:44.457

    php code to store array in database
    <?
        $array_string = array(key => value, key2 => value2, key3 => value3);
        $conn=mysql_connect('localhost', 'mysql_user', 'mysql_password');
        mysql_select_db("mysql_db",$conn);
        $array_string=mysql_escape_string(serialize($array));
        mysql_query("insert into table (column) values($array_string)",$conn);
    ?>

    To retrieve array from database

    <?
        $conn=mysql_connect('localhost', 'mysql_user', 'mysql_password');
        mysql_select_db("mysql_db",$conn);
        $q=mysql_query("select column from table",$conn);
        while($rs=mysql_fetch_assoc($q))
        {
        $array= unserialize($rs['column']);
        print_r($array);
        }
    ?>

Thank you for this solution. It is other way than using json encode / decode. — Adil Abbas, Jul 15 '14 at 09:31

MySQL save array in the db

4 Answers4