<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >ingres_fetch_array</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="PHP 手册" HREF="index.html"><LINK REL="UP" TITLE="Ingres II Functions" HREF="ref.ingres.html"><LINK REL="PREVIOUS" TITLE="ingres_errsqlstate" HREF="function.ingres-errsqlstate.html"><LINK REL="NEXT" TITLE="ingres_fetch_object" HREF="function.ingres-fetch-object.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8"></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 手册</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ingres-errsqlstate.html" ACCESSKEY="P" >上一页</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" >下一页</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="AEN101775" ></A ><P > (PHP 4 >= 4.0.2, PHP 5 <= 5.0.4)</P >ingres_fetch_array -- Fetch a row of result into an array</DIV ><DIV CLASS="refsect1" ><A NAME="AEN101778" ></A ><H2 >Description</H2 >array <B CLASS="methodname" >ingres_fetch_array</B > ( [int result_type [, resource link]] )<BR ></BR ><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="AEN101795" ></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 > <CODE CLASS="parameter" >result_type</CODE > 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="AEN101803" ></A ><P ><B >例 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-errsqlstate.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >起始页</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ingres-fetch-object.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >ingres_errsqlstate</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.ingres.html" ACCESSKEY="U" >上一级</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >ingres_fetch_object</TD ></TR ></TABLE ></DIV ></BODY ></HTML >