Insert an array into DB

alfpalafox

Hi, I'm trying to receive a variable like this:

then submitt it to make the insertion on the database. In the next page I receive this variable and store it in an array like this:

$array[] = $comentario;

The insertion I make it like this:

"INSERT INTO encuesta.datos(id_pregunta, valor, comentario) VALUES ('11', '0', '$array')";

And the updating with this instruction:

"UPDATE encuesta.datos SET comentario = comentario + '$array' WHERE datos.id_pregunta = '11'";

But nothing happens, Could you help me on this?

Thanks

eoghain

An array isn't a simple datatype and thus can't be put into a databse the way you want. Just try echoing your array variable and you will see that all you get is "Array" printed out. If you want to store an arrays value in a database you need to either store each value individually ($array[1], $array[2], ...) or you need to turn your array into some type of string or integer to be stored.

[man]implode/man is a very good function for turning your array into a string for storing into a database.

alfpalafox

Thanks for your reply,

I'll check out implode() , I want to store data into a variable (String) but I need to concatenate with the previous value. So I think I could use an array to store all the answers put into the textarea.

What shall I do?

Sxooter

By the way, serialize is considered the proper function for importing / exporting arrays and other complex variables like objects.