ifx_do(3) [php man page]

IFX_DO(3)								 1								 IFX_DO(3)

ifx_do - Execute a previously prepared SQL-statement

SYNOPSIS

       bool ifx_do (resource  $result_id)

DESCRIPTION

	Executes a previously prepared query or opens a cursor for it.

	Does NOT free $result_id on error.

	Also sets the real number of ifx_affected_rows(3) for non-select statements for retrieval by ifx_affected_rows(3).

PARAMETERS

	      o $result_id
		-$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

SEE ALSO

       Example #1

	      ifx_do(3) Example

	      <?php
	      $conn = fx_connect( "db", "user", "password" );
	      $result = ifx_prepare("SELECT customer_num, company FROM customer", $conn);
	      ifx_do($result);
	      ?>

SEE ALSO

       ifx_prepare(3).

PHP Documentation Group 														 IFX_DO(3)

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)