ingres_error(3) [php man page]

INGRES_ERROR(3) 							 1							   INGRES_ERROR(3)

ingres_error - Get a meaningful error message for the last error generated

SYNOPSIS

       string ingres_error ([resource  $link])

DESCRIPTION

	Returns a string containing the last error, or NULL if no error has occurred.

	If  a  $link  resource	is  passed  to	ingres_error(3),  it  returns  the  last  error  recorded  for the link. If no link is passed then
       ingres_error(3) returns the last error reported using the default link.

	The function, ingres_error(3), should always be called after executing any database query. Calling another function before ingres_error(3)
       is called will reset or change any error message from the last Ingres function call.

PARAMETERS

	      o $link
		- The connection link identifier

RETURN VALUES

	Returns a string containing the last error, or NULL if no error has occurred.

EXAMPLES

       Example #1

	      Get a message for the last error generated

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

	      $result = ingres_query($link, "select * from table");

	      $error_text = ingres_error();

	      if (!is_null($error_text)) {
		 echo "An error occurred - " . $error_text;
	      }
	      ?>

SEE ALSO

       ingres_errno(3), ingres_errsqlstate(3), ingres_next_error(3).

PHP Documentation Group 													   INGRES_ERROR(3)

INGRES_PREPARE(3)							 1							 INGRES_PREPARE(3)

ingres_prepare - Prepare a query for later execution

SYNOPSIS

       mixed ingres_prepare (resource  $link, string  $query)

DESCRIPTION

	Prepares a query for execution by ingres_execute(3).

	The  query  becomes  part  of the currently open transaction. If there is no open transaction, ingres_query(3) opens a new transaction. To
       close the transaction, you can call either ingres_commit(3) to commit the changes made to the  database	or  ingres_rollback(3)	to  cancel
       these  changes. When the script ends, any open transaction is rolled back (by calling ingres_rollback(3)). You can also use ingres_autocom-
       mit(3) before opening a new transaction to have every SQL query immediately committed.

       Note

	      Related Configurations

	       See also the ingres.describe, ingres.scrollable and ingres.utf8 directives in Runtime Configuration.

PARAMETERS

	      o $link
		- The connection link identifier

	      o $query
		- A valid SQL query (see the Ingres SQL reference guide) in the Ingres documentation. See the query parameter  in  ingres_query(3)
		for a list of SQL statements which cannot be executed using ingres_prepare(3)

RETURN VALUES

       ingres_prepare(3)  returns a query result identifier that is used with ingres_execute(3) to execute the query. To see if an error occurred,
       use ingres_errno(3), ingres_error(3), or ingres_errsqlstate(3).

SEE ALSO

       ingres_unbuffered_query(3), ingres_fetch_array(3), ingres_fetch_assoc(3),  ingres_fetch_object(3),  ingres_fetch_row(3),  ingres_commit(3),
       ingres_rollback(3), ingres_autocommit(3), ingres_set_environment(3), ingres_errno(3), ingres_error(3).

PHP Documentation Group 													 INGRES_PREPARE(3)