store session array in database

[asmith]

$option = array("1" => "aaa","2" => "bbb","3" => "ccc");
$_SESSION[option] = $option;

 

 

how can i store option values in one of my database fields? (or more than one field)

 

 

[aschk]

Do you want all those array values in 1 field, or each of those array values in separate fields?

If the former, then just implode with a separator and insert.

If the latter then you need to know the fields you are after.

[asmith]

implode helps,

for the latter, how it can be if i have field1 , field2, filed3  on table "fileds"  ?

 

 

[aschk]

You database table would need to have those columns (i.e. field1, field2, field3) then you insert key 1 into field1, key 2 into field2, etc...

 

note : if you are thinking about adding new COLUMNS for each of those array values then slap yourself on the forehead and redo your database design and rethink that you're doing.

[asmith]

you mean i extract the array then insert each value to each field  ?

or has specific code or function ?

(sorry i didn't quiet get you, but thanks for implode ! )