You can use this function safely with your MySQL database queries if and only if you are sure that your database connection is using ASCII, UTF-8, or ISO-8859-* and that the backslash is your database's escape character. If you're not sure, then use mysqli_real_escape_string instead. This function is not safe to use on databases with multi-byte character sets.
The only benefit of this function is that it does not require a database connection.
mysql_escape_string
(PHP 4 >= 4.0.3, PHP 5)
mysql_escape_string — Escapes a string for use in a mysql_query
Warning
This extension is deprecated as of PHP 5.5.0, and will be removed in the future. Instead, the MySQLi or PDO_MySQL extension should be used. See also MySQL: choosing an API guide and related FAQ for more information. Alternatives to this function include:
說明
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.
Warning
自 PHP 5.3.0 起，已經廢棄此函式。強烈建議不要使用此函式。
參數
-
unescaped_string -
The string that is to be escaped.
回傳值
Returns the escaped string.
更新日誌
| 版本 | 說明 |
|---|---|
| 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
<?php
$item = "Zak's Laptop";
$escaped_item = mysql_escape_string($item);
printf("Escaped string: %s\n", $escaped_item);
?>
上例將輸出：
Escaped string: Zak\'s Laptop
註釋
Note:
mysql_escape_string() does not escape % and _.
參見
- mysql_real_escape_string() - Escapes special characters in a string for use in an SQL statement
- addslashes() - Quote string with slashes
- The magic_quotes_gpc directive.
add a note
User Contributed Notes 2 notes
PHPguru ¶
9 years ago
s dot marechal at jejik dot com ¶
13 years ago
The exact characters that are escaped by this function are the null byte (0), newline (\n), carriage return (\r), backslash (\), single quote ('), double quote (") and substiture (SUB, or \032).
