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_HTMLTBL_RESULT(3)							 1						     IFX_HTMLTBL_RESULT(3)

ifx_htmltbl_result - Formats all rows of a query into a HTML table

SYNOPSIS

       int ifx_htmltbl_result (resource  $result_id, [string  $html_table_options])

DESCRIPTION

	Formats and prints all rows of the $result_id query into a HTML table.

PARAMETERS

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

	      o $html_table_options
		- This optional argument is a string of <table> tag options.

RETURN VALUES

	Returns the number of fetched rows, or FALSE on errors.

EXAMPLES

       Example #1

	      Informix results as HTML table

	      <?php
	      $rid = ifx_prepare ("select * from emp where name like " . $name,
				   $connid, IFX_SCROLL);
	      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 />
");
	      }
	      if (! ifx_do($rid)) {
		  /* ... error ... */
	      }

	      ifx_htmltbl_result ($rid, "border="2"");

	      ifx_free_result($rid);
	      ?>

PHP Documentation Group 												     IFX_HTMLTBL_RESULT(3)