} elseif ('' . bigintval($value, TRUE, FALSE) . '' == '' . $value . '') {
// No need for ticks (')
$SQL .= '`' . $entry . '`=' . $value . ',';
+ } elseif ('' . (float) $value . '' == '' . $value . '') {
+ // Float number detected
+ $SQL .= '`' . $entry . '`=' . sprintf(getConfig('FLOAT_MASK'), $value) . ',';
} else {
// Strings need ticks (') around them
$SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value) . "',";
} elseif (('' . bigintval($value[$multiDimId], TRUE, FALSE) . '' == '' . $value[$multiDimId] . '')) {
// No need for ticks (')
$SQL .= '`' . $entry . '`=' . $value[$multiDimId] . ',';
+ } elseif ('' . (float) $value[$multiDimId] . '' == '' . $value[$multiDimId] . '') {
+ // Float number detected
+ $SQL .= '`' . $entry . '`=' . sprintf(getConfig('FLOAT_MASK'), $value[$multiDimId]) . ',';
} else {
// Strings need ticks (') around them
$SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value[$multiDimId]) . "',";
// "Getter" for an "INSERT INTO" SQL query
function getInsertSqlFromArray ($array, $tableName) {
// Init SQL
- $SQL = 'INSERT INTO
-`{?_MYSQL_PREFIX?}_' . $tableName . '`
-(
-`' . implode('`, `', array_keys($array)) . '`
-) VALUES (';
+ $SQL = 'INSERT INTO `{?_MYSQL_PREFIX?}_' . $tableName . '` (`' . implode('`, `', array_keys($array)) . '`) VALUES (';
// Walk through all entries
foreach ($array as $key => $value) {
$SQL .= bigintval($value) . ',';
} elseif ('' . (float) $value . '' == '' . $value . '') {
// Float number detected
- $SQL .= sprintf('%01.5f', $value);
+ $SQL .= sprintf(getConfig('FLOAT_MASK'), $value) . ',';
} else {
// Everything else might be a string, so add ticks around it
$SQL .= chr(39) . SQL_ESCAPE($value) . chr(39) . ',';
$SQL = substr($SQL, 0, -1) . ')';
// Return SQL query
+ //* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',sql=' . $SQL);
return $SQL;
}