How do I put this multidimensional array into a SQL-DB cell?

Question

I have this multidimensional array:

Array
(
    [tennis] => Array
        (
            [3] => Seattle
            [4] => WA
            [5] => 98109
        )

    [Middle East] => Array
        (
            [6] => 2066822513
            [7] => 34740 - Georgetown Keg - 1/2 Manny Pale
            [0] => Hello World
        )

    [Florida] => Array
        (
            [1] => 38380 - Thirteen Coins-Boren
            [2] => 125 Boren Ave N
            [3] => Seattle
        )

)

I am looking for a way to best store it into one single cell in my SQL-DB. The keys of the main array (tennis, middle east, florida) have to be kept. The other keys of the subarrays can be omitted. How can I do that?

possible duplicate of How to store an array into mysql? - and the many other duplicates. — hakre
– hakre, Commented Feb 23, 2012 at 19:20

Tomi Seus · Accepted Answer · 2012-02-24 10:06:24Z

1

I read about the serialize function, and implemented it.

The solution: First I turn the array into a string:

$array = serialize($array);

Then I store the string into the DB cell.

To get back the array, I unserialize the string from the DB cell:

$array = unserialize($array);

And I end up with the same array. Simple

answered Feb 24, 2012 at 10:06

Tomi Seus

1,1612 gold badges13 silver badges28 bronze badges

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

Comments

penartur · Accepted Answer · 2012-02-23 19:03:53Z

0

Look at the serialize function.

answered Feb 23, 2012 at 19:03

penartur

9,9325 gold badges41 silver badges51 bronze badges

1 Comment

Tomi Seus Over a year ago

thank you penartur. I've done that and posted a detailed solution

Gustav · Accepted Answer · 2012-02-23 19:08:09Z

0

I would use JSON since it's more universal.

<?php
  $json=addslashes(json_encode($array));
  mysql_query("INSERT INTO table (data) VALUES ('$json')");
?>

For really large blobs you could do gzdeflate() in that case I recommend also saving a checksum.

answered Feb 23, 2012 at 19:08

Gustav

2,9401 gold badge27 silver badges31 bronze badges

Collectives™ on Stack Overflow

How do I put this multidimensional array into a SQL-DB cell?

3 Answers 3

Comments

1 Comment

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Linked

Related