ingres_fetch_proc_return(3) [php man page]

INGRES_FETCH_PROC_RETURN(3)						 1					       INGRES_FETCH_PROC_RETURN(3)

ingres_fetch_proc_return - Get the return value from a procedure call

SYNOPSIS

       int ingres_fetch_proc_return (resource  $result)

DESCRIPTION

	This function is used to retrieve the return value following the execution of an Ingres database procedure (stored procedure).

       Note

	       If  used  with  a  row-producing  procedure, this function should be called after all the rows from the procedure have been fetched
	      using ingres_fetch_array(3), ingres_fetch_object(3) or ingres_fetch_row(3). This function will eliminate any rows yet to be  fetched
	      should there be any left over.

PARAMETERS

	      o $result
		- The result identifier for a query

RETURN VALUES

	Returns an integer if there is a return value otherwise it will return NULL.

EXAMPLES

       Example #1

	      Get the return value from a procedure call

	      <?php

	      $link = ingres_connect($database);

	      if ( ingres_errno() != 0 ) {
		  $error_text = ingres_error();
		  die($error_text);
	      }

	      $result = ingres_query($link, "execute procedure php_proc (value = 1000)");

	      if ( ingres_errno() != 0 ) {
		  $error_text = ingres_error();
		  die($error_text);
	      }

	      echo "return value - " . ingres_fetch_proc_return($result) . "
";

	      ingres_close($link);

	      ?>

SEE ALSO

       ingres_query(3), ingres_fetch_array(3), ingres_fetch_object(3), ingres_fetch_row(3).

PHP Documentation Group 											       INGRES_FETCH_PROC_RETURN(3)

INGRES_FETCH_OBJECT(3)							 1						    INGRES_FETCH_OBJECT(3)

ingres_fetch_object - Fetch a row of result into an object

SYNOPSIS

       object ingres_fetch_object (resource  $result, [int  $result_type])

DESCRIPTION

	This function is similar to ingres_fetch_array(3), with one difference - an object is returned instead of an array. Indirectly, this means
       that you can access the data only by the field names and not by their offsets (numbers are illegal property names).

	With regard to speed, the function is identical to ingres_fetch_array(3), and almost as quick as ingres_fetch_row(3)  (the  difference	is
       insignificant).

       Note

	      Related Configurations

	       See also the ingres.fetch_buffer_size and ingres.utf8 directives in Runtime Configuration.

PARAMETERS

	      o $link
		- The query result identifier

	      o $result_type
		- (Optional argument.) $result_type is a constant and can take the following values: INGRES_ASSOC, INGRES_NUM, and INGRES_BOTH.

RETURN VALUES

	Returns an object that corresponds to the fetched row, or FALSE if there are no more rows

EXAMPLES

       Example #1

	      Fetch a row into an object

	      <?php
	      $link = ingres_connect($database, $user, $password);
	      $result = ingres_query($link, "select * from table");
	      while ($row = ingres_fetch_object($result)) {
		  echo $row->user_id;
		  echo $row->fullname;
	      }
	      ?>

SEE ALSO

       ingres_query(3), ingres_num_fields(3), ingres_field_name(3), ingres_fetch_array(3), ingres_fetch_assoc(3), ingres_fetch_row(3).

PHP Documentation Group 												    INGRES_FETCH_OBJECT(3)