<!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 result row as an object</title>
</head>
<body><div class="manualnavbar" style="text-align: center;">
<div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-fetch-lengths.html">fbsql_fetch_lengths</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-row.html">fbsql_fetch_row</a></div>
<div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="function.fbsql-fetch-object" class="refentry">
<div class="refnamediv">
<h1 class="refname">fbsql_fetch_object</h1>
<p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_fetch_object</span> — <span class="dc-title">Fetch a result row as an object</span></p>
</div>
<div class="refsect1 description" id="refsect1-function.fbsql-fetch-object-description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">object</span> <span class="methodname"><strong>fbsql_fetch_object</strong></span>
( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$result</code></span>
)</div>
<p class="para rdfs-comment">
<span class="function"><strong>fbsql_fetch_object()</strong></span> is similar to
<span class="function"><a href="function.fbsql-fetch-array.html" class="function">fbsql_fetch_array()</a></span>, with one difference - an
object is returned, instead of an array. Indirectly, that means
that you can only access the data by the field names, and not by
their offsets (numbers are illegal property names).
</p>
<p class="para">
Speed-wise, the function is identical to
<span class="function"><a href="function.fbsql-fetch-array.html" class="function">fbsql_fetch_array()</a></span>, and almost as quick as
<span class="function"><a href="function.fbsql-fetch-row.html" class="function">fbsql_fetch_row()</a></span> (the difference is
insignificant).
</p>
</div>
<div class="refsect1 parameters" id="refsect1-function.fbsql-fetch-object-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">A result identifier
returned by <span class="function"><a href="function.fbsql-query.html" class="function">fbsql_query()</a></span> or
<span class="function"><a href="function.fbsql-db-query.html" class="function">fbsql_db_query()</a></span>.</p></dd>
</dt>
</dl>
</p>
</div>
<div class="refsect1 returnvalues" id="refsect1-function.fbsql-fetch-object-returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an object with properties that correspond 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.fbsql-fetch-object-examples">
<h3 class="title">Examples</h3>
<p class="para">
<div class="example" id="example-1126">
<p><strong>Example #1 <span class="function"><strong>fbsql_fetch_object()</strong></span> example</strong></p>
<div class="example-contents">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br />fbsql_connect</span><span style="color: #007700">(</span><span style="color: #0000BB">$host</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">fbsql_db_query</span><span style="color: #007700">(</span><span style="color: #DD0000">"database"</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">fbsql_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">fbsql_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div>
</p>
</div>
<div class="refsect1 seealso" id="refsect1-function.fbsql-fetch-object-seealso">
<h3 class="title">See Also</h3>
<p class="para">
<ul class="simplelist">
<li class="member"> <span class="function"><a href="function.fbsql-fetch-array.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_array()</a> - Fetch a result row as an associative array, a numeric array, or both</span></li>
<li class="member"> <span class="function"><a href="function.fbsql-fetch-row.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_row()</a> - Get a result row as an enumerated array</span></li>
<li class="member"> <span class="function"><a href="function.fbsql-fetch-assoc.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_assoc()</a> - Fetch a result row as an associative 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.fbsql-fetch-lengths.html">fbsql_fetch_lengths</a></div>
<div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-row.html">fbsql_fetch_row</a></div>
<div class="up"><a href="ref.fbsql.html">FrontBase Functions</a></div>
<div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
