function.msql-fetch-object.html
来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 133 行
HTML
133 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Fetch row as object</title> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.msql-fetch-field.html">msql_fetch_field</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.msql-fetch-row.html">msql_fetch_row</a></div> <div class="up"><a href="ref.msql.html">mSQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="function.msql-fetch-object" class="refentry"> <div class="refnamediv"> <h1 class="refname">msql_fetch_object</h1> <p class="verinfo">(PHP 4, PHP 5)</p><p class="refpurpose"><span class="refname">msql_fetch_object</span> — <span class="dc-title">Fetch row as object</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">object</span> <span class="methodname"><b><b>msql_fetch_object</b></b></span> ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span> )</div> <p class="para rdfs-comment"> <b>msql_fetch_object()</b> is similar to <a href="function.msql-fetch-array.html" class="function">msql_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.msql-fetch-array.html" class="function">msql_fetch_array()</a>, and almost as quick as <a href="function.msql-fetch-row.html" class="function">msql_fetch_row()</a> (the difference is insignificant). </p> </div> <div class="refsect1 parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt><span class="term"><i><tt class="parameter">result</tt></i></span><dd><p class="para">The result <a href="language.types.resource.html" class="type resource">resource</a> thatis being evaluated. This result comes from a call to <a href="function.msql-query.html" class="function">msql_query()</a>.</p></dd></dt> </dl> </p> </div> <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>FALSE</tt></b> if there are no more rows. </p> </div> <div class="refsect1 examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example"> <p><b>Example #1 <b>msql_fetch_object()</b> example</b></p> <div class="example-contents"><div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB"><?php<br />$con </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_connect</span><span style="color: #007700">();<br />if (!</span><span style="color: #0000BB">$con</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Server connection problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br />if (!</span><span style="color: #0000BB">msql_select_db</span><span style="color: #007700">(</span><span style="color: #DD0000">'test'</span><span style="color: #007700">, </span><span style="color: #0000BB">$con</span><span style="color: #007700">)) {<br /> die(</span><span style="color: #DD0000">'Database connection problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_query</span><span style="color: #007700">(</span><span style="color: #DD0000">'SELECT id, name FROM people'</span><span style="color: #007700">, </span><span style="color: #0000BB">$con</span><span style="color: #007700">);<br />if (!</span><span style="color: #0000BB">$result</span><span style="color: #007700">) {<br /> die(</span><span style="color: #DD0000">'Query execution problem: ' </span><span style="color: #007700">. </span><span style="color: #0000BB">msql_error</span><span style="color: #007700">());<br />}<br /><br />while (</span><span style="color: #0000BB">$row </span><span style="color: #007700">= </span><span style="color: #0000BB">msql_fetch_object</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">, </span><span style="color: #0000BB">MSQL_ASSOC</span><span style="color: #007700">)) {<br /> echo </span><span style="color: #0000BB">$row</span><span style="color: #007700">-></span><span style="color: #0000BB">id </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">name </span><span style="color: #007700">. </span><span style="color: #DD0000">"\n"</span><span style="color: #007700">;<br />}<br /><br /></span><span style="color: #0000BB">msql_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 changelog"> <h3 class="title">ChangeLog</h3> <p class="para"> <table class="informaltable"> <colgroup> <thead valign="middle"> <tr valign="middle"> <th colspan="1">Version</th> <th colspan="1">Description</th> </tr> </thead> <tbody valign="middle" class="tbody"> <tr valign="middle"> <td colspan="1" rowspan="1" align="left">4.3.11 and 5.0.4 </td> <td colspan="1" rowspan="1" align="left"> A bug was fixed when retrieving data from columns containing <b><tt>NULL</tt></b> values. Such columns were not placed into the resulting array. </td> </tr> </tbody> </colgroup> </table> </p> </div> <div class="refsect1 seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><a href="function.msql-fetch-array.html" class="function" rel="rdfs-seeAlso">msql_fetch_array()</a></li> <li class="member"><a href="function.msql-fetch-row.html" class="function" rel="rdfs-seeAlso">msql_fetch_row()</a></li> <li class="member"><a href="function.msql-data-seek.html" class="function" rel="rdfs-seeAlso">msql_data_seek()</a></li> <li class="member"><a href="function.msql-result.html" class="function" rel="rdfs-seeAlso">msql_result()</a></li> </ul> </p> </div></div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.msql-fetch-field.html">msql_fetch_field</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.msql-fetch-row.html">msql_fetch_row</a></div> <div class="up"><a href="ref.msql.html">mSQL Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?