<!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 object</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.ingres-fetch-assoc.html">ingres_fetch_assoc</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ingres-fetch-proc-return.html">ingres_fetch_proc_return</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-object" class="refentry">
<div class="refnamediv">
<h1 class="refname">ingres_fetch_object</h1>
<p class="verinfo">(PHP 4 >= 4.0.2, PHP 5 <= 5.0.5, PECL ingres >= 1.0.0)</p><p class="refpurpose"><span class="refname">ingres_fetch_object</span> — <span class="dc-title">Fetch a row of result into an object</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.ingres-fetch-object-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">object</span> <span class="methodname"><strong>ingres_fetch_object</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 similar to
<span class="function"><a href="function.ingres-fetch-array.html" class="function">ingres_fetch_array()</a></span>, with one difference - an
object is returned instead of an array. Indirectly, this means
that you can access the data only by the field names and not by
their offsets (numbers are illegal property names).
</p>
<p class="para">
With regard to speed, the function is identical to
<span class="function"><a href="function.ingres-fetch-array.html" class="function">ingres_fetch_array()</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>
<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.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-object-parameters">
<h3 class="title">Parameters</h3>
<p class="para">
<dl>
<dt>
<span class="term"><em><code class="parameter">link</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">
(Optional argument.) <em><code class="parameter">result_type</code></em> is a
constant and can take the following values: <strong><code>INGRES_ASSOC</code></strong>,
<strong><code>INGRES_NUM</code></strong>, and <strong><code>INGRES_BOTH</code></strong>.
</p>
</dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.ingres-fetch-object-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an object 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-object-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1216">
<p><strong>Example #1 Fetch a row into an object</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 /></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_object</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: #0000BB">user_id</span><span style="color: #007700">;<br /> echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">fullname</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-object-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-array.html" class="function" rel="rdfs-seeAlso">ingres_fetch_array()</a> - Fetch a row of result into an array</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-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-fetch-assoc.html">ingres_fetch_assoc</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.ingres-fetch-proc-return.html">ingres_fetch_proc_return</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>
