<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML
><HEAD
><TITLE
>ifx_fetch_row</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="Manual PHP"
HREF="index.html"><LINK
REL="UP"
TITLE="Informix Functions"
HREF="ref.ifx.html"><LINK
REL="PREVIOUS"
TITLE="ifx_errormsg"
HREF="function.ifx-errormsg.html"><LINK
REL="NEXT"
TITLE="ifx_fieldproperties"
HREF="function.ifx-fieldproperties.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-2"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Manual PHP</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.ifx-errormsg.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.ifx-fieldproperties.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.ifx-fetch-row"
></A
>ifx_fetch_row</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN43877"
></A
><P
> (PHP 3>= 3.0.3, PHP 4 , PHP 5)</P
>ifx_fetch_row -- Get row as enumerated array</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN43880"
></A
><H2
>Description</H2
>array <B
CLASS="methodname"
>ifx_fetch_row</B
> ( int result_id [, mixed position])<BR
></BR
><P
>
Returns an associative array that corresponds to the fetched row,
or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if there are no more rows.
</P
><P
> Blob columns are returned as integer blob id values for use in
<A
HREF="function.ifx-get-blob.html"
><B
CLASS="function"
>ifx_get_blob()</B
></A
> unless you have used
ifx_textasvarchar(1) or ifx_byteasvarchar(1), in which case blobs
are returned as string values. Returns <TT
CLASS="constant"
><B
>FALSE</B
></TT
> on error
</P
><P
> <VAR
CLASS="parameter"
>result_id</VAR
> is a valid resultid returned by
<A
HREF="function.ifx-query.html"
><B
CLASS="function"
>ifx_query()</B
></A
> or
<A
HREF="function.ifx-prepare.html"
><B
CLASS="function"
>ifx_prepare()</B
></A
> (select type queries only!).
</P
><P
> <VAR
CLASS="parameter"
>position</VAR
> is 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.
</P
><P
> <B
CLASS="function"
>ifx_fetch_row()</B
> fetches one row of data from
the result associated with the specified result identifier. The
row is returned as an array. Each result column is stored in an
array offset, starting at offset 0, with the column name as key.
</P
><P
> Subsequent calls to <B
CLASS="function"
>ifx_fetch_row()</B
> would
return the next row in the result set, or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if there are no
more rows.
</P
><P
> <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN43908"
></A
><P
><B
>Exemplu 1. Informix fetch rows</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br />$rid </font><font color="#007700">= </font><font color="#0000BB">ifx_prepare </font><font color="#007700">(</font><font color="#DD0000">"select * from emp where name like " </font><font color="#007700">. </font><font color="#0000BB">$name</font><font color="#007700">,<br /> </font><font color="#0000BB">$connid</font><font color="#007700">, </font><font color="#0000BB">IFX_SCROLL</font><font color="#007700">);<br />if (! </font><font color="#0000BB">$rid</font><font color="#007700">) {<br /> </font><font color="#FF8000">/* ... error ... */<br /></font><font color="#007700">}<br /></font><font color="#0000BB">$rowcount </font><font color="#007700">= </font><font color="#0000BB">ifx_affected_rows</font><font color="#007700">(</font><font color="#0000BB">$rid</font><font color="#007700">);<br />if (</font><font color="#0000BB">$rowcount </font><font color="#007700">> </font><font color="#0000BB">1000</font><font color="#007700">) {<br /> </font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"Too many rows in result set (%d)\n<br />"</font><font color="#007700">, </font><font color="#0000BB">$rowcount</font><font color="#007700">);<br /> die (</font><font color="#DD0000">"Please restrict your query<br />\n"</font><font color="#007700">);<br />}<br />if (! </font><font color="#0000BB">ifx_do </font><font color="#007700">(</font><font color="#0000BB">$rid</font><font color="#007700">)) {<br /> </font><font color="#FF8000">/* ... error ... */<br /></font><font color="#007700">}<br /></font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">ifx_fetch_row </font><font color="#007700">(</font><font color="#0000BB">$rid</font><font color="#007700">, </font><font color="#DD0000">"NEXT"</font><font color="#007700">);<br />while (</font><font color="#0000BB">is_array</font><font color="#007700">(</font><font color="#0000BB">$row</font><font color="#007700">)) {<br /> for (</font><font color="#0000BB">reset</font><font color="#007700">(</font><font color="#0000BB">$row</font><font color="#007700">); </font><font color="#0000BB">$fieldname</font><font color="#007700">=</font><font color="#0000BB">key</font><font color="#007700">(</font><font color="#0000BB">$row</font><font color="#007700">); </font><font color="#0000BB">next</font><font color="#007700">(</font><font color="#0000BB">$row</font><font color="#007700">)) {<br /> </font><font color="#0000BB">$fieldvalue </font><font color="#007700">= </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#0000BB">$fieldname</font><font color="#007700">];<br /> </font><font color="#0000BB">printf </font><font color="#007700">(</font><font color="#DD0000">"%s = %s,"</font><font color="#007700">, </font><font color="#0000BB">$fieldname</font><font color="#007700">, </font><font color="#0000BB">$fieldvalue</font><font color="#007700">);<br /> }<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"\n<br />"</font><font color="#007700">);<br /> </font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">ifx_fetch_row</font><font color="#007700">(</font><font color="#0000BB">$rid</font><font color="#007700">, </font><font color="#DD0000">"NEXT"</font><font color="#007700">);<br />}<br /></font><font color="#0000BB">ifx_free_result </font><font color="#007700">(</font><font color="#0000BB">$rid</font><font color="#007700">);<br /></font><font color="#0000BB">?></font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.ifx-errormsg.html"
ACCESSKEY="P"
>Înapoi</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Acasã</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.ifx-fieldproperties.html"
ACCESSKEY="N"
>Înainte</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>ifx_errormsg</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.ifx.html"
ACCESSKEY="U"
>Sus</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>ifx_fieldproperties</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
distrib
>
PLD
>
ac
>
amd64
>
media
>
dist
>
by-pkgid
>
dd8ef74e7a184506d40e4328053fb785
>
files
>
1237
