ingres_escape_string(3) php man page | unix.com

INGRES_ESCAPE_STRING(3) 						 1						   INGRES_ESCAPE_STRING(3)

ingres_escape_string - Escape special characters for use in a query

SYNOPSIS
       string ingres_escape_string (resource  $link, string  $source_string)

DESCRIPTION
       ingres_escape_string(3) is used to escape certain characters within a string before it is sent to the database server.

PARAMETERS
	      o $link
		- The connection link identifier

	      o $source_string
		- The source string to be parsed

RETURN VALUES
	Returns a string containing the escaped data.

EXAMPLES
       Example #1

	      Escape special characters for use in a query

	      <?php
	      $link = ingres_connect($database, $user, $password);

	      $last_name = "O'Connor";

	      $sql = sprintf("select * from user_profile where up_last = '%s'", ingres_escape_string( $link, $last_name));

	      $result = ingres_query($link, $sql);

	      while ($user = ingres_fetch_object($result))
	      {
		echo $user->up_first . '<BR/>';
	      }

	      ingres_commit($link);

	      ingres_close($link);

	      ?>

SEE ALSO
       ingres_query(3).

PHP Documentation Group 												   INGRES_ESCAPE_STRING(3)