PYTHON mysql_escape_string

Python replacement for PHP's mysql_escape_string [ edit ]

Do you know a Python replacement for PHP's mysql_escape_string ? Write it!

PHP mysql_escape_string

PHP original manual for mysql_escape_string [ show | ]


(PHP 4 >= 4.0.3, PHP 5)

mysql_escape_stringEscapes a string for use in a mysql_query


string mysql_escape_string ( string $unescaped_string )

This function will escape the unescaped_string , so that it is safe to place it in a mysql_query(). This function is deprecated.

This function is identical to mysql_real_escape_string() except that mysql_real_escape_string() takes a connection handler and escapes the string according to the current character set. mysql_escape_string() does not take a connection argument and does not respect the current charset setting.



The string that is to be escaped.

Return Values

Returns the escaped string.


Version Description
5.3.0 This function now throws an E_DEPRECATED notice.
4.3.0 This function became deprecated, do not use this function. Instead, use mysql_real_escape_string().


Example #1 mysql_escape_string() example

"Zak's Laptop";
$escaped_item mysql_escape_string($item);
printf("Escaped string: %s\n"$escaped_item);

The above example will output:

Escaped string: Zak\'s Laptop


Note: mysql_escape_string() does not escape % and _.

See Also