ifx_fetch_row

Get row as an associative array ()
array ifx_fetch_row ( resource result_id [, mixed position] )

Example 1072. Informix fetch rows

copy to clipboard

<?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)\n<br />", $rowcount);

    die ("Please restrict your query<br />\n");

}

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("\n<br />");

    $row = ifx_fetch_row($rid, "NEXT");

}
ifx_free_result ($rid);
?>

Code Examples / Notes » ifx_fetch_row

rpuchalsky

If you use a select statement that identifies fields according to which table they come from, i.e. select tab1.name, tab2.phone from tab1, tab2 where tab1.id = tab2.id then the associative keys of the array returned by ifx_fetch_row will not include the table names. For the example above, if you used $row = ifx_fetch_row ($rid); then the first field in the returned array would be $row["name"], not $row["tab1.name"] .

Change Language

ifx_affected_rows
ifx_blobinfile_mode
ifx_byteasvarchar
ifx_close
ifx_connect
ifx_copy_blob
ifx_create_blob
ifx_create_char
ifx_do
ifx_error
ifx_errormsg
ifx_fetch_row
ifx_fieldproperties
ifx_fieldtypes
ifx_free_blob
ifx_free_char
ifx_free_result
ifx_get_blob
ifx_get_char
ifx_getsqlca
ifx_htmltbl_result
ifx_nullformat
ifx_num_fields
ifx_num_rows
ifx_pconnect
ifx_prepare
ifx_query
ifx_textasvarchar
ifx_update_blob
ifx_update_char
ifxus_close_slob
ifxus_create_slob
ifxus_free_slob
ifxus_open_slob
ifxus_read_slob
ifxus_seek_slob
ifxus_tell_slob
ifxus_write_slob

ifx_fetch_row

Get row as an associative array () array ifx_fetch_row ( resource result_id [, mixed position] )

Example 1072. Informix fetch rows

Code Examples / Notes » ifx_fetch_row

Change Language

Get row as an associative array ()
array ifx_fetch_row ( resource result_id [, mixed position] )