Db escape string: Difference between revisions From Online Manual

Jump to: navigation, search
(Created page with "{{smcfunc |function=db_escape_string |usage=$smcFunc['db_escape_string'] (uncleaned_string) |description=Escapes strings for insertion into the database. The function does not re...")
 
m (refresh SMW properties)
 
(2 intermediate revisions by one other user not shown)
Line 1: Line 1:
{{smcfunc
{{smcfunc
|function=db_escape_string
|function=db_escape_string
|internal=true
|usage=$smcFunc['db_escape_string'] (uncleaned_string)
|usage=$smcFunc['db_escape_string'] (uncleaned_string)
|description=Escapes strings for insertion into the database. The function does not require a database connection.<br>For MySQL [http://php.net/manual/en/function.addslashes.php addslashes] is used, while for PostgreSQL [http://php.net/manual/en/function.pg-escape-string.php pg_escape_string] and for SQLite [http://php.net/manual/en/function.sqlite-escape-string.php sqlite_escape_string] as used.
|description=Escapes strings for insertion into the database. The function does not require a database connection.<br>For MySQL [http://php.net/manual/en/function.addslashes.php addslashes] is used, while for PostgreSQL [http://php.net/manual/en/function.pg-escape-string.php pg_escape_string] and for SQLite [http://php.net/manual/en/function.sqlite-escape-string.php sqlite_escape_string] as used.
Line 11: 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]]
[[Category:Database Functions]]</noinclude>
[[Category:2.0]]
[[Category:Customizing SMF]]
[[Category:Developing SMF]]</noinclude>

Latest revision as of 16:41, 11 October 2012

Usage:

$smcFunc['db_escape_string'] (uncleaned_string)


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);



Advertisement: