);
}
+// Generates an updating SQL query from given array
+function getUpdateSqlFromArray ($array, $tableName, $whereColumn, $whereData, $excludedFields, $multiDimId = NULL) {
+ // Begin SQL query
+ $SQL = 'UPDATE `{?_MYSQL_PREFIX?}_' . $tableName . '` SET ';
+
+ // Insert all data
+ foreach ($array as $entry => $value) {
+ // Skip login/id entry
+ if (in_array($entry, $excludedFields)) {
+ continue;
+ } // END - if
+
+ // Do we have a non-string (e.g. number, NULL, NOW() or back-tick at the beginning?
+ if (is_null($multiDimId)) {
+ // Handle one-dimensional data
+ if (is_null($value)) {
+ // NULL detected
+ $SQL .= '`' . $entry . '`=NULL,';
+ } elseif (('' . bigintval($value, true, false) . '' == '' . $value . '') || ($value == 'NOW()') || (substr($value, 0, 1) == '`')) {
+ // No need for ticks (')
+ $SQL .= '`' . $entry . '`=' . $value . ',';
+ } else {
+ // Strings need ticks (') around them
+ $SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value) . "', ";
+ }
+ } else {
+ // Handle multi-dimensional data
+ if (is_null($value[$multiDimId])) {
+ // NULL detected
+ $SQL .= '`' . $entry . '`=NULL, ';
+ } elseif (('' . bigintval($value[$multiDimId], true, false) . '' == '' . $value[$multiDimId] . '') || ($value[$multiDimId] == 'NOW()') || (substr($value[$multiDimId], 0, 1) == '`')) {
+ // No need for ticks (')
+ $SQL .= '`' . $entry . '`=' . $value[$multiDimId] . ',';
+ } else {
+ // Strings need ticks (') around them
+ $SQL .= '`' . $entry . "`='" . SQL_ESCAPE($value[$multiDimId]) . "',";
+ }
+ }
+ } // END - foreach
+
+ // Remove last 2 chars and finish query
+ $SQL = substr($SQL, 0, -1) . ' WHERE `' . $whereColumn . '`=' . $whereData . ' LIMIT 1';
+
+ // Return SQL query
+ return $SQL;
+}
+
+// "Getter" for an "INSERT INTO" SQL query
+function getInsertSqlFromArray ($array, $tableName) {
+ // Init SQL
+ $SQL = 'INSERT INTO
+`{?_MYSQL_PREFIX?}_' . $tableName . '`
+(
+`' . implode('`,`', array_keys(postRequestArray())) . '`
+) VALUES (';
+
+ // Walk through all entries
+ foreach (postRequestArray() as $key => $value) {
+ // Log debug message
+ /* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'tableName=' . $tableName . ',key=' . $key . ',value=' . $value);
+
+ // Add all entries
+ if (is_null($value)) {
+ // Add NULL
+ $SQL .= 'NULL,';
+ } elseif ('' . bigintval($value, true, false) . '' == '' . $value . '') {
+ // Number detected, no need for ticks (')
+ $SQL .= bigintval($value) . ',';
+ } elseif ('' . (float) $value . '' == '' . $value . '') {
+ // Float number detected
+ $SQL .= sprintf('%01.5f', $value);
+ } else {
+ // Everything else might be a string, so add ticks around it
+ $SQL .= "'" . SQL_ESCAPE($value) . "',";
+ }
+ } // END - foreach
+
+ // Finish SQL query
+ $SQL = substr($SQL, 0, -1) . ')';
+
+ // Return SQL query
+ return $SQL;
+}
+
// [EOF]
?>