MySQL在db中保存数组

Question

Is it possible to store an associative array as it is in the db?

array(
       key  => value,
       key2 => value2,
       key3 => value3,
       ...
      )

Currently, if I write fieldname = '$array', only the string "Array" is stored in the field.

Answer 1

Try this

fieldname = json_encode($array);

and when you want to retrieve from database then use

$array = json_decode($fieldname);