downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | my php.net 
search for in the  

<dbx_errordbx_fetch_row>
Last updated: Thu, 26 Jun 2008

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

Description

string dbx_escape_string ( object $link_identifier , string $text )

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

Parameters

link_identifier

The DBX link object returned by dbx_connect()

text

The string to escape.

Return Values

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

Examples

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

See Also



add a noteadd a note User Contributed Notes
Escape a string so it can safely be used in an sql-statement
There are no user contributed notes for this page.




<dbx_errordbx_fetch_row>
Last updated: Thu, 26 Jun 2008
show source | credits | sitemap | contact | advertising | mirror sites
Copyright © 2001-2005 The PHP Group
All rights reserved.
This unofficial mirror is operated at: http://phpbuilder.com/
Last updated: Tue Nov 1 20:20:59 2005 EST
Columns / Articles | Tips / Quickies | News | News Linking and RSS Feeds | Shared Code Library
Mail Archives | Support / Discussion Forums | Get Started! Links | Contribute! | Docs