PHP Dokumentation: Function db2-escape-string
12. Januar 2010 von werner
db2_escape_string
(PECL ibm_db2 >= 1.6.0)
db2_escape_string — Used to escape certain characters
Beschreibung
string db2_escape_string ( string $string_literal )
Prepends backslashes to special characters in the string argument.
Parameter-Liste
- string_literal
The string that contains special characters that need to be modified. Characters that are prepended with a backslash are \x00, \n, \r, \, ', " and \x1a.
Rückgabewerte
Returns string_literal with the special characters noted above prepended with backslashes.
Beispiele
Beispiel #1 A db2_escape_string() example
Result of using the db2_escape_string() function
<?php$conn
= db2_connect($database, $user, $password);if (
$conn) {
$str[0] = "All characters: \x00 , \n , \r , \ , ' , \" , \x1a .";
$str[1] = "Backslash (\). Single quote ('). Double quote (\")";
$str[2] = "The NULL character \0 must be quoted as well";
$str[3] = "Intersting characters: \x1a , \x00 .";
$str[4] = "Nothing to quote";
$str[5] = 200676;
$str[6] = ""; foreach(
$str as $string ) {
echo "db2_escape_string: " . db2_escape_string($string). "\n";
}
}
?>Das oben gezeigte Beispiel erzeugt folgendeAusgabe:
db2_escape_string: All characters: \0 , \n , \r , \\ , \' , \" , \Z .db2_escape_string: Backslash (\\). Single quote (\'). Double quote (\")db2_escape_string: The NULL character \0 must be quoted as welldb2_escape_string: Intersting characters: \Z , \0 .db2_escape_string: Nothing to quotedb2_escape_string: 200676db2_escape_string:
Siehe auch
- db2_prepare() – Prepares an SQL statement to be executed