php man page for ifx_fetch_row

Query: ifx_fetch_row

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

IFX_FETCH_ROW(3)							 1							  IFX_FETCH_ROW(3)

ifx_fetch_row - Get row as an associative array

SYNOPSIS
array ifx_fetch_row (resource $result_id, [mixed $position])
DESCRIPTION
Fetches one row of data from the result associated with the specified result identifier. Subsequent calls to ifx_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result_id -$result_id is a valid resultid returned by ifx_query(3) or ifx_prepare(3) (select type queries only!). o $position - An optional parameter for a "fetch" operation on "scroll" cursors: NEXT, PREVIOUS, CURRENT, FIRST, LAST or a number. If you specify a number, an "absolute" row fetch is executed. This parameter is optional, and only valid for SCROLL cursors.
RETURN VALUES
Returns an associative array that corresponds to the fetched row, or FALSE if there are no more rows. Blob columns are returned as integer blob id values for use in ifx_get_blob(3) unless you have used ifx_textasvarchar(1) or ifx_byteasvar- char(1), in which case blobs are returned as string values.
EXAMPLES
Example #1 Informix fetch rows <?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 ... */ } $row = ifx_fetch_row ($rid, "NEXT"); while (is_array($row)) { for (reset($row); $fieldname=key($row); next($row)) { $fieldvalue = $row[$fieldname]; printf ("%s = %s,", $fieldname, $fieldvalue); } printf(" <br />"); $row = ifx_fetch_row($rid, "NEXT"); } ifx_free_result ($rid); ?> PHP Documentation Group IFX_FETCH_ROW(3)
Related Man Pages
mysqli_fetch_array(3) - php
mysqli_result.fetch_assoc(3) - php
ifx_fetch_row(3) - php
msql_fetch_row(3) - php
ovrimos_fetch_into(3) - php
Similar Topics in the Unix Linux Community
Cut rowcount from one file to another
(g)awk how to preseve white spaces (FS characters) or read a right subpart of $0?
Sort each row (horizontally) in AWK or any
How to get rid of zombie process?
Replacing part of filename