<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >ingres_fetch_array</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="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-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.ingres-connect.html" ACCESSKEY="P" >Înapoi</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" >Înainte</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="AEN46577" ></A ><P > (PHP 4 >= 4.0.2, PHP 5)</P >ingres_fetch_array -- Fetch a row of result into an array</DIV ><DIV CLASS="refsect1" ><A NAME="AEN46580" ></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 >Avertisment</B ></TD ></TR ><TR ><TD ALIGN="LEFT" ><P >Aceastã funcþie este <SPAN CLASS="emphasis" ><I CLASS="emphasis" >EXPERIMENTALÃ</I ></SPAN >. Comportamentul acestei funcþii, numele funcþiei, ºi orice altceva documentat despre aceastã funcþie ar putea fi schimbate farã un anunþ prealabil, intr-o viitoare versiune PHP. V-am avertizat, deci folosiþi aceastã extensie pe riscul dv.</P ></TD ></TR ></TABLE ></DIV ><P > <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 > 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 > 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" ><P ></P ><A NAME="AEN46600" ></A ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?php<br /><br />ingres_query</font><font color="#007700">(</font><font color="#DD0000">"select t1.f1 as foo t2.f1 as bar from t1, t2"</font><font color="#007700">);<br /></font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">ingres_fetch_array</font><font color="#007700">();<br /></font><font color="#0000BB">$foo </font><font color="#007700">= </font><font color="#0000BB">$result</font><font color="#007700">[</font><font color="#DD0000">"foo"</font><font color="#007700">];<br /></font><font color="#0000BB">$bar </font><font color="#007700">= </font><font color="#0000BB">$result</font><font color="#007700">[</font><font color="#DD0000">"bar"</font><font color="#007700">];<br /><br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ><P ></P ></DIV > </P ><P > <VAR CLASS="parameter" >result_type</VAR > can be INGRES_NUM for enumerated array, INGRES_ASSOC for associative array, or INGRES_BOTH (default). </P ><P > 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 > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN46608" ></A ><P ><B >Exemplu 1. <B CLASS="function" >ingres_fetch_array()</B > example</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" CELLPADDING="5" ><TR ><TD ><code><font color="#000000"> <font color="#0000BB"><?php<br />ingres_connect</font><font color="#007700">(</font><font color="#0000BB">$database</font><font color="#007700">, </font><font color="#0000BB">$user</font><font color="#007700">, </font><font color="#0000BB">$password</font><font color="#007700">);<br /><br /></font><font color="#0000BB">ingres_query</font><font color="#007700">(</font><font color="#DD0000">"select * from table"</font><font color="#007700">);<br />while (</font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">ingres_fetch_array</font><font color="#007700">()) {<br /> echo </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#DD0000">"user_id"</font><font color="#007700">]; </font><font color="#FF8000">// using associative array<br /> </font><font color="#007700">echo </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#DD0000">"fullname"</font><font color="#007700">];<br /> echo </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#0000BB">1</font><font color="#007700">]; </font><font color="#FF8000">// using enumerated array<br /> </font><font color="#007700">echo </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#0000BB">2</font><font color="#007700">];<br />}<br /></font><font color="#0000BB">?></font> </font> </code></TD ></TR ></TABLE ></DIV ></TD ></TR ></TABLE > </P ><P > 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" >Î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.ingres-fetch-object.html" ACCESSKEY="N" >Înainte</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" >Sus</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ingres_fetch_object</TD ></TR ></TABLE ></DIV ></BODY ></HTML >