Php/docs/mysqlnduhconnection.escapestring
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
<?phpclass 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 语句中使用的字符串中的特殊字符,并考虑到连接的当前字符集