dbx_escape_string(3) [php man page]

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)

FBSQL_CREATE_BLOB(3)							 1						      FBSQL_CREATE_BLOB(3)

fbsql_create_blob - Create a BLOB

SYNOPSIS

       string fbsql_create_blob (string  $blob_data, [resource	$link_identifier])

DESCRIPTION

	Creates a BLOB from the given data.

PARAMETERS

	      o $blob_data
		- The BLOB data.

	      o $
		link_identifier  -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
		function will try to find an open link to the FrontBase server and if no such link is found it	will  try  to  create  one  as	if
		fbsql_connect(3) was called with no arguments.

RETURN VALUES

	Returns a resource handle to the newly created BLOB, which can be used with insert and update commands to store the BLOB in the database.

EXAMPLES

       Example #1

	      fbsql_create_blob(3) example

	      <?php
	      $link = fbsql_pconnect("localhost", "_SYSTEM", "secret")
		  or die("Could not connect");
	      $filename = "blobfile.bin";
	      $fp = fopen($filename, "rb");
	      $blobdata = fread($fp, filesize($filename));
	      fclose($fp);

	      $blobHandle = fbsql_create_blob($blobdata, $link);

	      $sql = "INSERT INTO BLOB_TABLE (BLOB_COLUMN) VALUES ($blobHandle);";
	      $rs = fbsql_query($sql, $link);
	      ?>

SEE ALSO

       fbsql_create_clob(3), fbsql_read_blob(3), fbsql_read_clob(3), fbsql_set_lob_mode(3).

PHP Documentation Group 												      FBSQL_CREATE_BLOB(3)