dbx_escape_string

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

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

说明

string dbx_escape_string ( object $link_identifier , string $text )

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()


	PHP5中文手册 dbx_error dbx_fetch_row dbx PHP Manual dbx_escape_string (PHP 4 >= 4.3.0, PHP 5 <= 5.0.5, PECL dbx:1.1.0) dbx_escape_string — Escape a string so it can safely be used in an sql-statement 说明 string dbx_escape_string ( object `$link_identifier` , string `$text` ) 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() dbx_error dbx_fetch_row dbx PHP Manual