<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Fetch a row of result into an array</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.ingres-execute.html">ingres_execute</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ingres-fetch-assoc.html">ingres_fetch_assoc</a></div>
<div class="up"><a href="ref.ingres.html">Ingres Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="function.ingres-fetch-array" class="refentry">
<div class="refnamediv">
<h1 class="refname">ingres_fetch_array</h1>
<p class="verinfo">( PHP 5 <= 5.0.5, PECL ingres >= 1.0.0)</p><p class="refpurpose"><span class="refname">ingres_fetch_array</span> — <span class="dc-title">Fetch a row of result into an array</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.ingres-fetch-array-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">array</span> <span class="methodname"><strong>ingres_fetch_array</strong></span>
( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result</code></span>
[, <span class="methodparam"><span class="type">int</span> <code class="parameter">$result_type</code></span>
] )</div>
<p class="para rdfs-comment">
This function is an extended version of
<span class="function"><a href="function.ingres-fetch-row.html" class="function">ingres_fetch_row()</a></span>. 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 class="para">
If two or more columns of the result have the same field names,
the last column will take precedence. To access the another
column or columns of the same name, you must use the numeric index of the
column or make an alias for the column. For example:
<div class="informalexample">
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br /><br />$result </span><span style="color: #007700">= </span><span style="color: #0000BB">ingres_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">, </span><span style="color: #DD0000">"select ap_place as city, ap_ccode as country from airport where ap_iatacode = 'VLL'"</span><span style="color: #007700">); <br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">ingres_fetch_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$foo </span><span style="color: #007700">= </span><span style="color: #0000BB">$result</span><span style="color: #007700">[</span><span style="color: #DD0000">"city"</span><span style="color: #007700">];<br /></span><span style="color: #0000BB">$bar </span><span style="color: #007700">= </span><span style="color: #0000BB">$result</span><span style="color: #007700">[</span><span style="color: #DD0000">"country"</span><span style="color: #007700">];<br /><br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div>
</p>
<p class="para">
With regard to speed, the function is identical to
<span class="function"><a href="function.ingres-fetch-object.html" class="function">ingres_fetch_object()</a></span>, and almost as quick as
<span class="function"><a href="function.ingres-fetch-row.html" class="function">ingres_fetch_row()</a></span> (the difference is
insignificant).
</p>
<p class="para">
By default, arrays created by <span class="function"><strong>ingres_fetch_array()</strong></span> start
from position 1 and not 0 as with other DBMS extensions. The starting position
can be adjusted to 0 using the configuration parameter <a href="ingres.configuration.html#ini.ingres.array-index-start" class="link">ingres.array_index_start</a>.
</p>
<blockquote class="note"><p><strong class="note">Note</strong>:
<strong>Related Configurations</strong><br />
<p class="para">
See also the <a href="ingres.configuration.html#ini.ingres.array-index-start" class="link">ingres.array_index_start</a>, <a href="ingres.configuration.html#ini.ingres.fetch-buffer-size" class="link">ingres.fetch_buffer_size</a>
and <a href="ingres.configuration.html#ini.ingres.utf8" class="link">ingres.utf8</a>
directives in <a href="ingres.configuration.html" class="link">Runtime
Configuration</a>.
</p>
</p></blockquote>
</div>
<div class="refsect1 parameters" id="refsect1-function.ingres-fetch-array-parameters">
<h3 class="title">Parameters</h3>
<p class="para">
<dl>
<dt>
<span class="term"><em><code class="parameter">result</code></em></span>
<dd>
<p class="para">
The query result identifier
</p>
</dd>
</dt>
<dt>
<span class="term"><em><code class="parameter">result_type</code></em></span>
<dd>
<p class="para">
The result type. This <em><code class="parameter">result_type</code></em> can be <strong><code>INGRES_NUM</code></strong> for
enumerated array, <strong><code>INGRES_ASSOC</code></strong> for associative array, or
<strong><code>INGRES_BOTH</code></strong> (default).
</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.ingres-fetch-array-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an array that corresponds to the fetched row,
or <strong><code>FALSE</code></strong> if there are no more rows
</p>
</div>
<div class="refsect1 examples" id="refsect1-function.ingres-fetch-array-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1214">
<p><strong>Example #1 Fetch a row of result into an array</strong></p>
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br />$link </span><span style="color: #007700">= </span><span style="color: #0000BB">ingres_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$database</span><span style="color: #007700">, </span><span style="color: #0000BB">$user</span><span style="color: #007700">, </span><span style="color: #0000BB">$password</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">ingres_query</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">,</span><span style="color: #DD0000">"select * from table"</span><span style="color: #007700">);<br />while (</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">ingres_fetch_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">)) {<br /> echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">"user_id"</span><span style="color: #007700">]; </span><span style="color: #FF8000">// using associative array<br /> </span><span style="color: #007700">echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">"fullname"</span><span style="color: #007700">];<br /> echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">1</span><span style="color: #007700">]; </span><span style="color: #FF8000">// using enumerated array<br /> </span><span style="color: #007700">echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">2</span><span style="color: #007700">];<br />}<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div>
</p>
</div>
<div class="refsect1 seealso" id="refsect1-function.ingres-fetch-array-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.ingres-query.html" class="function" rel="rdfs-seeAlso">ingres_query()</a> - Send an SQL query to Ingres</span></li>
<li class="member"> <span class="function"><a href="function.ingres-num-fields.html" class="function" rel="rdfs-seeAlso">ingres_num_fields()</a> - Get the number of fields returned by the last query</span></li>
<li class="member"> <span class="function"><a href="function.ingres-field-name.html" class="function" rel="rdfs-seeAlso">ingres_field_name()</a> - Get the name of a field in a query result</span></li>
<li class="member"> <span class="function"><a href="function.ingres-fetch-assoc.html" class="function" rel="rdfs-seeAlso">ingres_fetch_assoc()</a> - Fetch a row of result into an associative array</span></li>
<li class="member"> <span class="function"><a href="function.ingres-fetch-object.html" class="function" rel="rdfs-seeAlso">ingres_fetch_object()</a> - Fetch a row of result into an object</span></li>
<li class="member"> <span class="function"><a href="function.ingres-fetch-row.html" class="function" rel="rdfs-seeAlso">ingres_fetch_row()</a> - Fetch a row of result into an enumerated array</span></li>
</ul>
</p>
</div>
</div><hr /><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.ingres-execute.html">ingres_execute</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ingres-fetch-assoc.html">ingres_fetch_assoc</a></div>
<div class="up"><a href="ref.ingres.html">Ingres Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
