Mine
public text v1 · immutable $i = 1;
$valuesString .= '('.($i).',';
set_time_limit (600);
foreach ($data as $item) {
foreach ($item->childNodes as $node) {
$value = utf8_decode($node->nodeValue);
$valuesString .= "'".addSlashes($value)."'". ',';
}
$valuesString = rtrim($valuesString, ',');
$valuesString .= '),';
$i++;
}
$valuesString = rtrim($valuesString, ',');
$truncate = "TRUNCATE {$tableName};";
$SQL = "INSERT INTO {$tableName} VALUES {$valuesString};";