PHP Manual
dbx 函数
Escape a string so it can safely be used in an sql-statement

dbx_escape_string

(PHP 4 >= 4.3.0, PHP 5 < 5.1.0, PECL dbx >= 1.1.0)

dbx_escape_string — Escape a string so it can safely be used in an sql-statement

说明

dbx_escape_string ( object $link_identifier , string $text ) : string

Escape the given string so that it can safely be used in an sql-statement.

参数

link_identifier: The DBX link object returned by dbx_connect()
text: The string to escape.

返回值

Returns the text, escaped where necessary (such as quotes, backslashes etc). On error, NULL is returned.

范例

Example #1 dbx_escape_string() example

 <?php
$link   = dbx_connect(DBX_MYSQL, "localhost", "db", "username", "password")
    or die("Could not connect");

$text = dbx_escape_string($link, "It\'s quoted and backslashed (\\).");
$result = dbx_query($link, "insert into tbl (txt) values ('" . $text . "')");
if ($result == 0) {
    echo dbx_error($link);
}
dbx_close($link);
?>

参见

dbx_query() - Send a query and fetch all results (if any)

相关文章

php cubrid mysql 兼容性函数 return the number of rows affected by the last sql statement php cubrid 函数 prepare a sql statement for execution php cubrid mysql 兼容性函数 escape special characters in a string for use in an sql statement php ibm db2 函数 returns the cursor type used by a statement resource php ibm db2 函数 used to escape certain characters php ibm db2 函数 prepares an sql statement to be executed php ibm db2 函数 returns a string containing the sqlstate returned by an sql statement php ibm db2 函数 returns a string containing the last sql statement error message php dbx 函数 escape a string so it can safely be used in an sql statement php informix 函数 execute a previously prepared sql statement php informix 函数 prepare an sql statement for execution php mcve 函数 returns array of strings which represents the keys that can be used for response parameters on this transaction php maxdb 函数 prepare an sql statement for execution php maxdb 函数 escapes special characters in a string for use in an sql statement taking into account the current charset of the connection php maxdb 函数 prepare an sql statement for execution php win32service 函数 registers the script with the scm so that it can act as the service with the given name php xmlwriter 函数 set string used for indenting php gearmanworker give the worker an identifier so it can be tracked when asking gearmand for the list of available workers php mongogridfsfile returns a resource that can be used to read the stored file php mysqlnduhconnection escapes special characters in a string for use in an sql statement taking into account the current charset of the connection

关注编程学问公众号