storing an array into a databse

[runitzme]

hi geniuses 🙂 i need help again...how do you store an array into a database? For example...i have an array like:

array[0] = me
array[1] = you
array[2] = them
array[3] = her
..and so on

what i want to kno is how can i store it so that each array index gets a row in the database, so row 1 = me, row 2= you, row 3 = them...and it also checks if it exists in the database already so it doesn't do it twice. Thanks

[NogDog]

$values = implode('),(', $array);
$sql = "INSERT INTO table_name (column_name) VALUES ('$values')";
// now execute the query use $sql

Note: you may need to use addslashes() or mysql_real_escape_string() on the values of the array first if it can possibly contain problematic characters (such as quotes). You could use array_walk() to do that.

[runitzme]

hi Nogdog, thanks for your quick reply but won't that code store $Values as one row?

[adhall]

I think you're looking for serialize and unserialize