Function.dbx-escape-string

Aus PHP-Wiki

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

Beschreibung

string dbx_escape_string ( object $link_identifier , string $text )

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

Parameter-Liste

link_identifier

• The DBX link object returned by dbx_connect()

text

• The string to escape.

Rückgabewerte

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

Beispiele

Beispiel #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);
?>

Siehe auch

• dbx_query()