MysqlndUhConnection::escapeString
(PECL mysqlnd-uh >= 1.0.0-alpha)
MysqlndUhConnection::escapeString — Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection
说明
public
MysqlndUhConnection::escapeString (
mysqlnd_connection
$connection
,
string $escape_string
) :
string
Escapes special characters in a string for use in an SQL statement, taking into account the current charset of the connection.
参数
-
MYSQLND_UH_RES_MYSQLND_NAME
-
Mysqlnd connection handle. Do not modify!
-
escape_string
-
The string to be escaped.
返回值
The escaped string.
范例
Example #1 MysqlndUhConnection::escapeString() example
<?php
class proxy extends MysqlndUhConnection {
public function escapeString($res, $string) {
printf("%s(%s)\n", __METHOD__, var_export(func_get_args(), true));
$ret = parent::escapeString($res, $string);
printf("%s returns %s\n", __METHOD__, var_export($ret, true));
return $ret;
}
}
mysqlnd_uh_set_connection_proxy(new proxy());
$mysqli = new mysqli("localhost", "root", "", "test");
$mysqli->set_charset("latin1");
$mysqli->real_escape_string("test0'test");
?>
以上例程会输出:
proxy::escapeString(array ( 0 => NULL, 1 => 'test0\'test', )) proxy::escapeString returns 'test0\\\'test'
参见
- mysqlnd_uh_set_connection_proxy() - Installs a proxy for mysqlnd connections
- mysqli_real_escape_string() - 根据当前连接的字符集,对于 SQL 语句中的特殊字符进行转义
- mysql_real_escape_string() - 转义 SQL 语句中使用的字符串中的特殊字符,并考虑到连接的当前字符集