function getQueryInsert($sTable, $aItems, $mixedComment = false, $aExclude = array('id'))
{
$bFirst = true;
$sContent = $sComment = "";
foreach ($aItems as $aItem) {
foreach ($aExclude as $sKey) {
if (isset($aItem[$sKey])) {
unset($aItem[$sKey]);
}
}
$aKeys = array_keys($aItem);
$aValues = array_values($aItem);
$iValues = count($aValues);
foreach ($aValues as $iKey => $sValue) {
$aValues[$iKey] = BxDevFunctions::dbAddSlashes($sValue, true);
}
if ($bFirst) {
$sContent .= "INSERT INTO `" . $sTable . "`(`" . implode("`, `", $aKeys) . "`) VALUES \n";
$bFirst = false;
}
$sSql = "(" . implode(", ", array_fill(0, $iValues, "?")) . "),\n";
$sSql = call_user_func_array(array($this, 'prepare'), array_merge(array($sSql), $aValues));
$sContent .= $sSql;
}
$sContent = substr($sContent, 0, -2) . ";\n\n";
if ($mixedComment === true || is_string($mixedComment) && $mixedComment != '') {
$sComment = "--\n-- " . ($mixedComment === true ? "Dumping data for table `" . $sTable . "`" : $mixedComment) . "\n--\n";
}
return $sComment . $sContent;
}
