Source of: /manual/en/function.mssql-fetch-object.php
<?php
include_once $_SERVER['DOCUMENT_ROOT'] . '/include/shared-manual.inc';
$TOC = array();
$PARENTS = array();
include_once dirname(__FILE__) ."/toc/ref.mssql.inc";
$setup = array (
'home' =>
array (
0 => 'index.php',
1 => 'PHP Manual',
),
'head' =>
array (
0 => 'UTF-8',
1 => 'en',
),
'this' =>
array (
0 => 'function.mssql-fetch-object.php',
1 => 'mssql_fetch_object',
),
'up' =>
array (
0 => 'ref.mssql.php',
1 => 'Mssql Functions',
),
'prev' =>
array (
0 => 'function.mssql-fetch-field.php',
1 => 'mssql_fetch_field',
),
'next' =>
array (
0 => 'function.mssql-fetch-row.php',
1 => 'mssql_fetch_row',
),
);
$setup["toc"] = $TOC;
$setup["parents"] = $PARENTS;
manual_setup($setup);
manual_header();
?>
<div id="function.mssql-fetch-object" class="refentry">
<div class="refnamediv">
<h1 class="refname">mssql_fetch_object</h1>
<p class="verinfo">(PHP 4, PHP 5, PECL odbtp >= 1.1.1)</p><p class="refpurpose"><span class="refname">mssql_fetch_object</span> — <span class="dc-title">Fetch row as object</span></p>
</div>
<a name="function.mssql-fetch-object.description"></a><div class="refsect1 description">
<h3 class="title">Description</h3>
<div class="methodsynopsis dc-description">
<span class="type">object</span> <span class="methodname"><b>mssql_fetch_object</b></span>
( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span>
)</div>
<p class="para rdfs-comment">
<b>mssql_fetch_object()</b> is similar to
<a href="function.mssql-fetch-array.php" class="function">mssql_fetch_array()</a>, 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
<a href="function.mssql-fetch-array.php" class="function">mssql_fetch_array()</a>, and almost as quick as
<a href="function.mssql-fetch-row.php" class="function">mssql_fetch_row()</a> (the difference is
insignificant).
</p>
</div>
<a name="function.mssql-fetch-object.parameters"></a><div class="refsect1 parameters">
<h3 class="title">Parameters</h3>
<p class="para">
</p><dl>
<dt class="varlistentry">
<span class="term"><i><tt class="parameter">result</tt></i>
</span>
</dt><dd class="listitem">
<p class="para">
The result resource that is being evaluated. This result comes from a
call to <a href="function.mssql-query.php" class="function">mssql_query()</a>.
</p>
</dd>
</dl>
<p>
</p>
</div>
<a name="function.mssql-fetch-object.returnvalues"></a><div class="refsect1 returnvalues">
<h3 class="title">Return Values</h3>
<p class="para">
Returns an object with properties that correspond to the fetched row, or
<b><tt class="constant">FALSE</tt></b> if there are no more rows.
</p>
</div>
<a name="function.mssql-fetch-object.examples"></a><div class="refsect1 examples">
<h3 class="title">Examples</h3>
<p class="para">
</p><div class="example">
<p><b>Example #1 <b>mssql_fetch_object()</b> example</b></p>
<div class="example-contents programlisting">
<div class="phpcode"><code><span style="color: #000000">
<span style="color: #0000BB"><?php<br /></span><span style="color: #FF8000">// Send a select query to MSSQL<br /></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT [username], [name] FROM [php].[dbo].[userlist]'</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">// Check if there were any records<br /></span><span style="color: #007700">if(!</span><span style="color: #0000BB">mssql_num_rows</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">))<br />{<br /> echo </span><span style="color: #DD0000">'No records found'</span><span style="color: #007700">;<br />}<br />else<br />{<br /> </span><span style="color: #FF8000">// Print a nice list of users in the format of:<br /> // * name (username)<br /><br /> </span><span style="color: #007700">echo </span><span style="color: #DD0000">'<ul>'</span><span style="color: #007700">;<br /><br /> while(</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">mssql_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">))<br /> {<br /> echo </span><span style="color: #DD0000">'<li>' </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">name </span><span style="color: #007700">. </span><span style="color: #DD0000">' (' </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">username </span><span style="color: #007700">. </span><span style="color: #DD0000">')</li>'</span><span style="color: #007700">;<br /> }<br /><br /> echo </span><span style="color: #DD0000">'</ul>'</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #FF8000">// Free the query result<br /></span><span style="color: #0000BB">mssql_free_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span>
</span>
</code></div>
</div>
</div><p>
</p>
</div>
<a name="function.mssql-fetch-object.notes"></a><div class="refsect1 notes">
<h3 class="title">Notes</h3>
<blockquote><p><b class="note">Note</b>: <span class="simpara">Field names returned by this function
are <em class="emphasis">case-sensitive</em>.</span></p></blockquote>
<blockquote><p><b class="note">Note</b>: <span class="simpara">This function sets NULL fields to
the PHP <b><tt class="constant">NULL</tt></b> value.</span></p></blockquote>
</div>
<a name="function.mssql-fetch-object.seealso"></a><div class="refsect1 seealso">
<h3 class="title">See Also</h3>
<p class="para">
</p><ul class="simplelist">
<li class="member"><a href="function.mssql-fetch-array.php" class="function" rel="rdfs-seeAlso">mssql_fetch_array()</a> - Fetch a result row as an associative array, a numeric array, or both</li>
<li class="member"><a href="function.mssql-fetch-row.php" class="function" rel="rdfs-seeAlso">mssql_fetch_row()</a> - Get row as enumerated array</li>
</ul><p>
</p>
</div>
</div><?php manual_footer(); ?>
