Sophie: php-manual-en-4.3.0-2mdk noarch

php-manual-en-4.3.0-2mdk.noarch.rpm

<HTML
><HEAD
><TITLE
>ingres_fetch_array</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
REL="HOME"
TITLE="PHP Manual"
HREF="index.html"><LINK
REL="UP"
TITLE="Ingres II functions"
HREF="ref.ingres.html"><LINK
REL="PREVIOUS"
TITLE="ingres_connect"
HREF="function.ingres-connect.html"><LINK
REL="NEXT"
TITLE="ingres_fetch_object"
HREF="function.ingres-fetch-object.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=ISO-8859-1"></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"
>PHP Manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.ingres-connect.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.ingres-fetch-object.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.ingres-fetch-array"
></A
>ingres_fetch_array</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN41162"
></A
><P
>    (PHP 4 &#62;= 4.0.2)</P
>ingres_fetch_array&nbsp;--&nbsp;Fetch a row of result into an array</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN41165"
></A
><H2
>Description</H2
>array <B
CLASS="methodname"
>ingres_fetch_array</B
> ( [int result_type [, resource link]])<BR
></BR
><DIV
CLASS="warning"
><P
></P
><TABLE
CLASS="warning"
BORDER="1"
WIDTH="100%"
><TR
><TD
ALIGN="CENTER"
><B
>Warning</B
></TD
></TR
><TR
><TD
ALIGN="LEFT"
><P
>This function is
<SPAN
CLASS="emphasis"
><I
CLASS="emphasis"
>EXPERIMENTAL</I
></SPAN
>. The behaviour of this function, the
name of this function, and anything else documented about this
function may change without notice in a future release of PHP. 
Use this function at your own risk.</P
></TD
></TR
></TABLE
></DIV
><P
>&#13;     <B
CLASS="function"
>ingres_fetch_array()</B
> Returns an array that
     corresponds to the fetched row, or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if there are no more
     rows.
    </P
><P
>&#13;     This function is an extended version of
     <A
HREF="function.ingres-fetch-row.html"
><B
CLASS="function"
>ingres_fetch_row()</B
></A
>.  In addition to storing
     the data in the numeric indices of the result array, it also
     stores the data in associative indices, using the field names as
     keys.
    </P
><P
>&#13;     If two or more columns of the result have the same field names,
     the last column will take precedence. To access the other
     column(s) of the same name, you must use the numeric index of the
     column or make an alias for the column.
     <DIV
CLASS="informalexample"
><A
NAME="AEN41185"
></A
><P
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="programlisting"
>ingres_query(select t1.f1 as foo t2.f1 as bar from t1, t2);
$result = ingres_fetch_array();
$foo = $result["foo"];
$bar = $result["bar"];</PRE
></TD
></TR
></TABLE
><P
></P
></DIV
>
    </P
><P
>&#13;     <TT
CLASS="parameter"
><I
>result_type</I
></TT
> can be INGRES_NUM for
     enumerated array, INGRES_ASSOC for associative array, or
     INGRES_BOTH (default).
    </P
><P
>&#13;     Speed-wise, the function is identical to
     <A
HREF="function.ingres-fetch-object.html"
><B
CLASS="function"
>ingres_fetch_object()</B
></A
>, and almost as quick as
     <A
HREF="function.ingres-fetch-row.html"
><B
CLASS="function"
>ingres_fetch_row()</B
></A
> (the difference is
     insignificant).
    </P
><P
>&#13;     <TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN41193"
></A
><P
><B
>Example 1. <B
CLASS="function"
>ingres_fetch_array()</B
> example</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="php"
>&#60;?php
ingres_connect ($database, $user, $password);

ingres_query ("select * from table");
while ($row = ingres_fetch_array()) {
    echo $row["user_id"];  # using associative array
    echo $row["fullname"];
    echo $row[1];          # using enumerated array
    echo $row[2];
}
?&#62;</PRE
></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
>
    </P
><P
>&#13;     See also
     <A
HREF="function.ingres-query.html"
><B
CLASS="function"
>ingres_query()</B
></A
>,
     <A
HREF="function.ingres-num-fields.html"
><B
CLASS="function"
>ingres_num_fields()</B
></A
>,
     <A
HREF="function.ingres-field-name.html"
><B
CLASS="function"
>ingres_field_name()</B
></A
>,
     <A
HREF="function.ingres-fetch-object.html"
><B
CLASS="function"
>ingres_fetch_object()</B
></A
>, and
     <A
HREF="function.ingres-fetch-row.html"
><B
CLASS="function"
>ingres_fetch_row()</B
></A
>.
    </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.ingres-connect.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.ingres-fetch-object.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>ingres_connect</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.ingres.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>ingres_fetch_object</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>