insert php array in database

[luke101]

Is it possible to insert php array directly in a mysql database? If so, how would I do this and do you think you could give an example?

[Barand]

Not directly, you have to convert to a string of delimited elements

<?php

$data = array (1,2,3,4,5);

$items = join ('|', $data);  //  --> "1|2|3|4|5"

?>

 

Now you can write $items to the table.

 

BUT whenever you have the need to this, 9 times out of 10 you should be normalizing the data and writing each value to its own row in a separate table.

[dbo]

How about serialize and unserialize?

[Barand]

Overkill IMO, unless it's a multidimensional array.

[dbo]

Nods, fair enough