dbx_escape_string(3) php man page | unix.com

DBX_ESCAPE_STRING(3)							 1						      DBX_ESCAPE_STRING(3)

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

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

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

PARAMETERS
	      o $link_identifier
		- The DBX link object returned by dbx_connect(3)

	      o $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(3) 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
       dbx_query(3).

PHP Documentation Group 												      DBX_ESCAPE_STRING(3)