No edit summary |
m (refresh SMW properties) |
||
Line 12: | Line 12: | ||
$new_var[$smcFunc['db_escape_string']($k)] = escapestring__recursive($v);</nowiki> | $new_var[$smcFunc['db_escape_string']($k)] = escapestring__recursive($v);</nowiki> | ||
}} | }} | ||
<noinclude> | <noinclude> | ||
[[Category:Database Functions]]</noinclude> | [[Category:Database Functions]]</noinclude> |
Latest revision as of 16:41, 11 October 2012
Usage:
$smcFunc['db_escape_string'] (uncleaned_string)
This function should never be used outside the database abstraction layer (Db-*.php or Subs-Db-*.php files) |
Description: Escapes strings for insertion into the database. The function does not require a database connection.
For MySQL addslashes is used, while for PostgreSQL pg_escape_string and for SQLite sqlite_escape_string as used.
Parameters:
- uncleaned_string the string to be escaped.
Return: the escaped string.
Example:
// Add slashes to every element, even the indexes! foreach ($var as $k => $v) $new_var[$smcFunc['db_escape_string']($k)] = escapestring__recursive($v);