Posted in PHP, SQL

PHP – serialise data for storage in MySQL

$cwarray = array($cw0, $cw1, $cw2, $cw3, $cw4, $cw5, $cw6, $cw7, $cw8, $cw9, $cw10, $cw11, $cw12, $cw13, $cw14, $cw15, $cw16, $cw17, $cw18, $cw19, $cw20, $cw21, $cw22, $cw23, $cw24, $cw25, $cw26, $cw27, $cw28, $cw29);

$upto30catw = serialize($cwarray);                                   // MySQL field must be TEXT!!!

$sql = “UPDATE templates SET _UPTO30CATW=’$upto30catw’ WHERE temp_id=$isn”;