如何反序列化数组并为每个数据插入查询？

Question

I'm not used to work with arrays, and now i have to, and i need some help guys.

I have a list of absences,that contain multiples values. They are all ids (like 4,25,100...) separed by a ','.

I want to add every single id in a table (insert query),i know the simple methode :

Insert into table (columns..) Values(values1,value2,...), 
(values1,value2,...),
(values1,value2,...),
(values1,value2,...)

But i dont know how to use it the the serialsed array.

Answer 1

Explode the string on the commas, then iterate over the resulting array. Understanding arrays is essential to PHP (and coding in general), so check out http://php.net/manual/en/language.types.array.php.

$string = '4,25,100';
$array = explode(',', $string);
foreach ( $array as $value ) {
    $sql = "INSERT INTO `table` (`some_column`) VALUES ('".$v."')";
}