CVS update: php3/doc/functions

Date: Friday September 18, 1998 @ 16:41 Author: eschmid Update of /repository/php3/doc/functions In directory asf:/u2/tmp/cvs-serv16341 Modified Files: ifx.sgml Log Message: Nearly all of the ifx stuff. Hi Chris, Danny and Jouni have a look at it and correct my stupid errors. Index: php3/doc/functions/ifx.sgml diff -c php3/doc/functions/ifx.sgml:1.5 php3/doc/functions/ifx.sgml:1.6 *** php3/doc/functions/ifx.sgml:1.5 Fri Sep 18 01:38:23 1998 --- php3/doc/functions/ifx.sgml Fri Sep 18 16:41:51 1998 *************** *** 487,493 **** </para> <example> <title>Informix fetch rows</title> ! <programlisting> $rid = ifx_prepare ("select * from emp where name like " . $name, $connid, "SCROLL"); if (! $rid) { --- 487,493 ---- </para> <example> <title>Informix fetch rows</title> ! <programlisting role="php3"> $rid = ifx_prepare ("select * from emp where name like " . $name, $connid, "SCROLL"); if (! $rid) { *************** *** 511,739 **** $row = ifx_fetch_row ($rid, "NEXT"); } ifx_free_result ($rid); </programlisting> </example> </refsect1> </refentry> ! <!-- ! <refentry id="function.ifx-result"> <refnamediv> ! <refname>ifx_result</refname> ! <refpurpose>get result data</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifx_result</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> ! <paramdef>int <parameter>row</parameter></paramdef> ! <paramdef>mixed <parameter>field</parameter></paramdef> </funcsynopsis> - <para> - Returns: The contents of the cell at the row and offset in the - specified Informix result set. <para> ! <function>ifx_result</function> returns the contents of one ! cell from a Informix result set. The field argument can be the ! field's offset, or the field's name, or the field's table dot ! field's name (fieldname.tablename). If the column name has been ! aliased ('select foo as bar from...'), use the alias instead of ! the column name. <para> ! When working on large result sets, you should consider using one ! of the functions that fetch an entire row (specified below). As ! these functions return the contents of multiple cells in one ! function call, they're MUCH quicker than ! <function>ifx_result</function>. Also, note that specifying a ! numeric offset for the field argument is much quicker than ! specifying a fieldname or tablename.fieldname argument. <para> ! Recommended high-performance alternatives: ! <function>ifx_fetch_row</function>, ! <function>ifx_fetch_array</function>, and ! <function>ifx_fetch_object</function>. </refsect1> </refentry> - --> ! <refentry id="function.ifx-num-rows"> <refnamediv> ! <refname>ifx_num_rows</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_num_rows</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <!-- blobs --> ! <refentry id="function.ifx-blobinfile-mode"> <refnamediv> ! <refname>ifx_blobinfile_mode</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_blobinfile_mode</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-copy-blob"> <refnamediv> ! <refname>ifx_copy_blob</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_copy_blob</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-create-blob"> <refnamediv> ! <refname>ifx_create_blob</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_create_blob</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-fieldproperties"> <refnamediv> ! <refname>ifx_fieldproperties</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_fieldproperties</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-fieldtypes"> <refnamediv> ! <refname>ifx_fieldtypes</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_fieldtypes</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-free-blob"> <refnamediv> ! <refname>ifx_free_blob</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_free_blob</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-free-result"> <refnamediv> ! <refname>ifx_free_result</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_free_result</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-get-blob"> <refnamediv> ! <refname>ifx_get_blob</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_get_blob</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-htmltbl-result"> <refnamediv> ! <refname>ifx_htmltbl_result</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_htmltbl_result</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-num-fields"> <refnamediv> ! <refname>ifx_num_fields</refname> <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_num_fields</function></funcdef> <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-update-blob"> <refnamediv> ! <refname>ifx_update_blob</refname> ! <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_update_blob</function></funcdef> ! <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> </reference> --- 511,1090 ---- $row = ifx_fetch_row ($rid, "NEXT"); } ifx_free_result ($rid); + </programlisting> + </example> + </refsect1> + </refentry> + <refentry id="function.ifx-htmltbl-result"> + <refnamediv> + <refname>ifx_htmltbl_result</refname> + <refpurpose>Formats all rows of a query into a HTML table</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>int <function>ifx_htmltbl_result</function></funcdef> + <paramdef>int <parameter>result_id</parameter></paramdef> + <paramdef>string <parameter><optional>html_table_options</optional></parameter></paramdef> + </funcsynopsis> + <para> + Returns TRUE on success, FALSE on error. + </para><para> + Formats all rows of the <parameter>result_id</parameter> query + into a html table. The optional second argument is a string of + &lt;table&gt; tag options + </para> + <example> + <title>Informix results as HTML table</title> + <programlisting role="php3"> + $rid = ifx_prepare ("select * from emp where name like " . $name, + $connid, "SCROLL"); + if (! $rid) { + ... error ... + } + $rowcount = ifx_affected_rows ($rid); + if ($rowcount > 1000) { + printf ("Too many rows in result set (%d)\n&lt;br>", $rowcount); + die ("Please restrict your query&lt;br>\n"); + } + if (! ifx_do($rid) { + ... error ... + } + + ifx_htmltbl_result ($rid, "border=\"2\""); + + ifx_free_result($rid); + </programlisting> + </example> + </refsect1> + </refentry> + + <refentry id="function.ifx-fieldtypes"> + <refnamediv> + <refname>ifx_fieldtypes</refname> + <refpurpose>List of Informix SQL fields</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>array <function>ifx_fieldtypes</function></funcdef> + <paramdef>int <parameter>result_id</parameter></paramdef> + </funcsynopsis> + <para> + Returns an associative array with fieldnames as key and the SQL + fieldtypes as data for query with + <parameter>result_id</parameter>. Returns FALSE on error. + </para> + <example> + <title>Fielnames and SQL fieldtypes</title> + <programlisting role="php3"> + $types = ifx_fieldtypes ($resultid); + if (! isset ($types)) { + ... error ... + } + for ($i = 0; $i < count($types); $i++) { + $fname = key($types); + printf("%s :\t type = %s\n", $fname, $types[$fname]); + next($types); + } </programlisting> </example> </refsect1> </refentry> + <refentry id="function.ifx-fieldproperties"> + <refnamediv> + <refname>ifx_fieldproperties</refname> + <refpurpose>List of SQL fieldproperties</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>array <function>ifx_fieldproperties</function></funcdef> + <paramdef>int <parameter>result_id</parameter></paramdef> + </funcsynopsis> + <para> + Returns an associative array with fieldnames as key and the SQL + fieldproperties as data for a query with + <parameter>result_id</parameter>. Returns FALSE on error. + </para><para> + Returns the Informix SQL fieldproperies of every field in the + query as an associative array. Properties are encoded as: + "SQLTYPE;length;precision;scale;ISNULLABLE" where SQLTYPE = the + Informix type like "SQLVCHAR" etc. and ISNULLABLE = "Y" or "N". + </para> + <example> + <title>Informix SQL fieldproperties</title> + <programlisting role="php3"> + $properties = ifx_fieldtypes ($resultid); + if (! isset($properties)) { + ... error ... + } + for ($i = 0; $i < count($properties); $i++) { + $fname = key ($properties); + printf ("%s:\t type = %s\n", $fname, $properties[$fname]); + next ($properties); + } + </programlisting> + </example> + </refsect1> + </refentry> ! <refentry id="function.ifx-num-fields"> <refnamediv> ! <refname>ifx_num_fields</refname> ! <refpurpose>Returns the number of columns in the query</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifx_num_fields</function></funcdef> ! <paramdef>int <parameter>result_id</parameter></paramdef> </funcsynopsis> <para> ! Returns the number of columns in query for ! <parameter>result_id</parameter> or FALSE on error ! </para><para> ! After preparing or executing a query, this call gives you the ! number of columns in the query. ! </para> ! </refsect1> ! </refentry> ! ! <refentry id="function.ifx-free-result"> ! <refnamediv> ! <refname>ifx_free_result</refname> ! <refpurpose>Releases resources for the query</refpurpose> ! </refnamediv> ! <refsect1> ! <title>Description</title> ! <funcsynopsis> ! <funcdef>int <function>ifx_free_result</function></funcdef> ! <paramdef>int <parameter>result_id</parameter></paramdef> ! </funcsynopsis> <para> ! Releases resources for the query associated with ! <parameter>result_id</parameter>. Returns FALSE on error. ! </refsect1> ! </refentry> ! ! <refentry id="function.ifx-create-blob"> ! <refnamediv> ! <refname>ifx_create_blob</refname> ! <refpurpose>Creates an blob object</refpurpose> ! </refnamediv> ! <refsect1> ! <title>Description</title> ! <funcsynopsis> ! <funcdef>int <function>ifx_create_blob</function></funcdef> ! <paramdef>int <parameter>type</parameter></paramdef> ! <paramdef>int <parameter>mode</parameter></paramdef> ! <paramdef>string <parameter>param</parameter></paramdef> ! </funcsynopsis> <para> ! Creates an blob object. ! </para><para> ! type: 1 = TEXT, 0 = BYTE ! </para><para> ! mode: 0 = blob-object holds the content in memory, ! 1 = blob-object holds the content in file. ! </para><para> ! param: if mode = 0: pointer to the content, ! if mode = 1: pointer to the filestring. ! </para><para> ! Return FALSE on error, otherwise the new blob object-id. ! </para> </refsect1> </refentry> + <refentry id="function.ifx-copy-blob"> + <refnamediv> + <refname>ifx_copy_blob</refname> + <refpurpose>Duplicates the given blob object</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>int <function>ifx_copy_blob</function></funcdef> + <paramdef>int <parameter>bid</parameter></paramdef> + </funcsynopsis> + <para> + Duplicates the given blob object. <parameter>bid</parameter> is + the ID of the blob object. + </para><para> + Returns FALSE on error otherwise the new blob object-id. + </para> + </refsect1> + </refentry> + <refentry id="function.ifx-free-blob"> + <refnamediv> + <refname>ifx_free_blob</refname> + <refpurpose>Deletes the blob object</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>int <function>ifx_free_blob</function></funcdef> + <paramdef>int <parameter>bid</parameter></paramdef> + </funcsynopsis> + <para> + Deletes the blobobject for the given blob object-id + <parameter>bid</parameter>. Returns FALSE on error otherwise + TRUE. + </para> + </refsect1> + </refentry> + <refentry id="function.ifx-get-blob"> + <refnamediv> + <refname>ifx_get_blob</refname> + <refpurpose>Return the content of a blob object</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>int <function>ifx_get_blob</function></funcdef> + <paramdef>int <parameter>bid</parameter></paramdef> + </funcsynopsis> + <para> + Returns the content of the blob object for the given blob + object-id <parameter>bid</parameter>. + </para> + </refsect1> + </refentry> + <refentry id="function.ifx-update-blob"> + <refnamediv> + <refname>ifx_update_blob</refname> + <refpurpose>Updates the content of the blob object</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef><function>ifx_update_blob</function></funcdef> + <paramdef>int <parameter>bid</parameter></paramdef> + <paramdef>string <parameter>content</parameter></paramdef> + </funcsynopsis> + <para> + Updates the content of the blob object for the given blob object + <parameter>bid</parameter>. <parameter>content</parameter> is a + string with new data. Returns FALSE on error otherwise TRUE. + </para> + </refsect1> + </refentry> ! <refentry id="function.ifx-blobinfile-mode"> <refnamediv> ! <refname>ifx_blobinfile_mode</refname> ! <refpurpose>Set the default blob mode for all select queries</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>void <function>ifx_blobinfile_mode</function></funcdef> ! <paramdef>int <parameter>mode</parameter></paramdef> </funcsynopsis> + <para> + Set the default blob mode for all select queries. Mode "0" means + save Byte-Blobs in memory, and mode "1" means save Byte-Blobs in + a file. + </para> </refsect1> </refentry> + <refentry id="function.ifx-textasvarchar"> + <refnamediv> + <refname>ifx_textasvarchar</refname> + <refpurpose>Set the default text mode</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>void <function>ifx_textasvarchar</function></funcdef> + <paramdef>int <parameter>mode</parameter></paramdef> + </funcsynopsis> + <para> + Sets the default text mode for all select-queries. Mode "0" will + return a blob id, and mode "1" will return a varchar with text + content. + </para> + </refsect1> + </refentry> + <refentry id="function.ifx-byteasvarchar"> + <refnamediv> + <refname>ifx_byteasvarchar</refname> + <refpurpose>Set the default byte mode</refpurpose> + </refnamediv> + <refsect1> + <title>Description</title> + <funcsynopsis> + <funcdef>void <function>ifx_byteasvarchar</function></funcdef> + <paramdef>int <parameter>mode</parameter></paramdef> + </funcsynopsis> + <para> + Sets the default byte mode for all select-queries. Mode "0" will + return a blob id, and mode "1" will return a varchar with text + content. + </para> + </refsect1> + </refentry> ! <refentry id="function.ifx-nullformat"> ! <refnamediv> ! <refname>ifx_nullformat</refname> ! <refpurpose>Sets the default return value on a fetch row</refpurpose> ! </refnamediv> ! <refsect1> ! <title>Description</title> ! <funcsynopsis> ! <funcdef>void <function>ifx_nullformat</function></funcdef> ! <paramdef>int <parameter>mode</parameter></paramdef> ! </funcsynopsis> ! <para> ! Sets the default return value of a NULL-value on a fetch row. ! Mode "0" returns "", and mode "1" returns "NULL". ! </para> ! </refsect1> ! </refentry> ! <refentry id="function.ifx-intifx-null"> <refnamediv> ! <refname>ifx_intifx_null</refname> ! <refpurpose>Returns the NULL-string depending on nullformat</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>void <function>ifx_intifx_null</function></funcdef> ! <paramdef>void </paramdef> </funcsynopsis> + <para> + Return the NULL-string depending on + <function>ifx_nullformat</function> Returns "" or "NULL". + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-create-slob"> <refnamediv> ! <refname>ifxus_create_slob</refname> ! <refpurpose>Creates an slob object and opens it</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_create_slob</function></funcdef> ! <paramdef>int <parameter>mode</parameter></paramdef> </funcsynopsis> + <para> + Creates an slob object and opens it. Modes: 1 = LO_RDONLY, 2 = + LO_WRONLY, 4 = LO_APPEND, 8 = LO_RDWR, 16 = LO_BUFFER, 32 = + LO_NOBUFFER -> or-mask. Return FALSE on error otherwise the new + slob object-id. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-free-slob"> <refnamediv> ! <refname>ifx_</refname> ! <refpurpose>Deletes the slob object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_free_slob</function></funcdef> ! <paramdef>int <parameter>bid</parameter></paramdef> </funcsynopsis> + <para> + Deletes the slob object. <parameter>bid</parameter> is the Id of + the slob object. Returns FALSE on error otherwise TRUE. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-close-slob"> <refnamediv> ! <refname>ifxus_close_slob</refname> ! <refpurpose>Deletes the slob object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_close_slob</function></funcdef> ! <paramdef>int <parameter>bid</parameter></paramdef> </funcsynopsis> + <para> + Deletes the slob object on the given slob object-id + <parameter>bid</parameter>. Return FALSE on error otherwise + TRUE. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-open-slob"> <refnamediv> ! <refname>ifxus_open_slob</refname> ! <refpurpose>Opens an slob object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_open_slob</function></funcdef> ! <paramdef>long <parameter>bid</parameter></paramdef> ! <paramdef>int <parameter>mode</parameter></paramdef> </funcsynopsis> + <para> + Opens an slob object. <parameter>bid</parameter> should be an + existing slob id. Modes: 1 = LO_RDONLY, 2 = LO_WRONLY, 4 = + LO_APPEND, 8 = LO_RDWR, 16 = LO_BUFFER, 32 = LO_NOBUFFER -> + or-mask. Returns FALSE on error otherwise the new slob + object-id. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-tell-slob"> <refnamediv> ! <refname>ifxus_tell_slob</refname> ! <refpurpose>Returns the current file or seek position</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_tell_slob</function></funcdef> ! <paramdef>long <parameter>bid</parameter></paramdef> </funcsynopsis> + <para> + Returns the current file or seek position of an open slob object + <parameter>bid</parameter> should be an existing slob id. Return + FALSE on error otherwise the seek position. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-seek-slob"> <refnamediv> ! <refname>ifxus_seek_slob</refname> ! <refpurpose>Sets the current file or seek position</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_seek_blob</function></funcdef> ! <paramdef>long <parameter>bid</parameter></paramdef> ! <paramdef>int <parameter>mode</parameter></paramdef> ! <paramdef>long <parameter>offset</parameter></paramdef> </funcsynopsis> + <para> + Sets the current file or seek position of an open slob object. + <parameter>bid</parameter> should be an existing slob id. Modes: + 0 = LO_SEEK_SET, 1 = LO_SEEK_CUR, 2 = LO_SEEK_END and + <parameter>offset</parameter> is an byte offset. Return FALSE on + error otherwise the seek position. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-read-slob"> <refnamediv> ! <refname>ifxus_read_slob</refname> ! <refpurpose>Reads nbytes of the slob object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_read_slob</function></funcdef> ! <paramdef>long <parameter>bid</parameter></paramdef> ! <paramdef>long <parameter>nbytes</parameter></paramdef> </funcsynopsis> + <para> + Reads nbytes of the slob object. <parameter>bid</parameter> is a + existing slob id and <parameter>nbytes</parameter> is the number + of bytes zu read. Return FALSE on error otherwise the string. + </para> </refsect1> </refentry> ! <refentry id="function.ifxus-write-slob"> <refnamediv> ! <refname>ifxus_write_slob</refname> ! <refpurpose>Writes a string into the slob object</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifxus_write_slob</function></funcdef> ! <paramdef>long <parameter>bid</parameter></paramdef> ! <paramdef>string <parameter>content</parameter></paramdef> </funcsynopsis> + <para> + Writes a string into the slob object. <parameter>bid</parameter> + is a existing slob id and <parameter>content</parameter> the + content to write. Return FALSE on error otherwise bytes written. + </para> </refsect1> </refentry> ! <!-- was solls? --> ! <!-- ! <refentry id="function.ifx-num-rows"> <refnamediv> ! <refname>ifx_num_rows</refname> <refpurpose></refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef><function>ifx_num_rows</function></funcdef> <paramdef><parameter></parameter></paramdef> </funcsynopsis> </refsect1> </refentry> ! <refentry id="function.ifx-result"> <refnamediv> ! <refname>ifx_result</refname> ! <refpurpose>get result data</refpurpose> </refnamediv> <refsect1> <title>Description</title> <funcsynopsis> ! <funcdef>int <function>ifx_result</function></funcdef> ! <paramdef>int <parameter>result</parameter></paramdef> ! <paramdef>int <parameter>row</parameter></paramdef> ! <paramdef>mixed <parameter>field</parameter></paramdef> </funcsynopsis> + <para> + Returns: The contents of the cell at the row and offset in the + specified Informix result set. + <para> + <function>ifx_result</function> returns the contents of one + cell from a Informix result set. The field argument can be the + field's offset, or the field's name, or the field's table dot + field's name (fieldname.tablename). If the column name has been + aliased ('select foo as bar from...'), use the alias instead of + the column name. + <para> + When working on large result sets, you should consider using one + of the functions that fetch an entire row (specified below). As + these functions return the contents of multiple cells in one + function call, they're MUCH quicker than + <function>ifx_result</function>. Also, note that specifying a + numeric offset for the field argument is much quicker than + specifying a fieldname or tablename.fieldname argument. + <para> + Recommended high-performance alternatives: + <function>ifx_fetch_row</function>, + <function>ifx_fetch_array</function>, and + <function>ifx_fetch_object</function>. </refsect1> </refentry> + + --> </reference> -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net