ifx_affected_rows(3) [php man page]

IFX_AFFECTED_ROWS(3)							 1						      IFX_AFFECTED_ROWS(3)

ifx_affected_rows - Get number of rows affected by a query

SYNOPSIS

       int ifx_affected_rows (resource	$result_id)

DESCRIPTION

	Returns the number of rows affected by a query associated with $result_id.

	For  inserts, updates and deletes the number is the real number (sqlerrd[2]) of affected rows. For selects it is an estimate (sqlerrd[0]).
       Don't rely on it. The database server can never return the actual number of rows that will be returned by a SELECT because it has not  even
       begun fetching them at this stage (just after the "PREPARE" when the optimizer has determined the query plan).

	Useful after ifx_prepare(3) to limit queries to reasonable result sets.

PARAMETERS

	      o $result_id
		- A valid result id returned by ifx_query(3) or ifx_prepare(3).

RETURN VALUES

	Returns the number of rows as an integer.

EXAMPLES

       Example #1

	      Informix affected rows

	      <?php
	      $rid = ifx_prepare("select * from emp
				   where name like " . $name, $connid);
	      if (! $rid) {
		  /* ... error ... */
	      }
	      $rowcount = ifx_affected_rows($rid);
	      if ($rowcount > 1000) {
		  printf ("Too many rows in result set (%d)
<br />", $rowcount);
		  die ("Please restrict your query<br />
");
	      }
	      ?>

SEE ALSO

       ifx_num_rows(3).

PHP Documentation Group 												      IFX_AFFECTED_ROWS(3)

IFX_PREPARE(3)								 1							    IFX_PREPARE(3)

ifx_prepare - Prepare an SQL-statement for execution

SYNOPSIS

       resource ifx_prepare (string  $query, resource  $link_identifier, [int  $cursor_def], mixed  $blobidarray)

DESCRIPTION

	Prepares a $query for later use with ifx_do(3).

	For "select-type" queries a cursor is declared and opened. Non-select queries are "execute immediate".

	For either query type the number of (estimated or real) affected rows is saved for retrieval by ifx_affected_rows(3).

	If  the contents of the TEXT (or BYTE) column allow it, you can also use ifx_textasvarchar(1) and ifx_byteasvarchar(1). This allows you to
       treat TEXT (or BYTE) columns just as if they were ordinary (but long) VARCHAR columns for select queries, and you don't need to bother with
       blob id's.

	With  ifx_textasvarchar(0)  or ifx_byteasvarchar(0) (the default situation), select queries will return BLOB columns as blob id's (integer
       value). You can get the value of the blob as a string or file with the blob functions (see below).

PARAMETERS

	      o $query
		- The query string.

	      o $link_identifier
		- The link identifier.

	      o $cursor_def
		- This optional parameter allows you to make this a scroll and/or hold cursor. It's  a	bitmask  and  can  be  either  IFX_SCROLL,
		IFX_HOLD, or both or'ed together.

	      o $blobidarray
		-  If  you  have BLOB (BYTE or TEXT) columns in the query, you can add a $blobidarray parameter containing the corresponding "blob
		ids", and you should replace those columns with a "?" in the query text.

RETURN VALUES

	Returns a valid result identifier for use by ifx_do(3), or FALSE on errors.

SEE ALSO

       ifx_do(3).

PHP Documentation Group 													    IFX_PREPARE(3)