📄 function.fbsql-fetch-array.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Fetch a result row as an associative array, a numeric array, or both</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.fbsql-error.html">fbsql_error</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-assoc.html">fbsql_fetch_assoc</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-array" class="refentry"> <div class="refnamediv"> <h1 class="refname">fbsql_fetch_array</h1> <p class="verinfo">(PHP 4 >= 4.0.6, PHP 5)</p><p class="refpurpose"><span class="refname">fbsql_fetch_array</span> — <span class="dc-title">Fetch a result row as an associative array, a numeric array, or both</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">array</span> <span class="methodname"><b><b>fbsql_fetch_array</b></b></span> ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$result</tt></span> [, <span class="methodparam"><span class="type">int</span> <tt class="parameter">$result_type</tt></span> ] )</div> <p class="para rdfs-comment"> <b>fbsql_fetch_array()</b> is a combination of <a href="function.fbsql-fetch-row.html" class="function">fbsql_fetch_row()</a> and <a href="function.fbsql-fetch-assoc.html" class="function">fbsql_fetch_assoc()</a>. </p> <p class="para"> An important thing to note is that using <b>fbsql_fetch_array()</b> is NOT significantly slower than using <a href="function.fbsql-fetch-row.html" class="function">fbsql_fetch_row()</a>, while it provides a significant added value. </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">A result identifierreturned by <a href="function.fbsql-query.html" class="function">fbsql_query()</a> or <a href="function.fbsql-db-query.html" class="function">fbsql_db_query()</a>.</p></dd></dt> <dt> <span class="term"><i><tt class="parameter">result_type</tt></i></span> <dd> <p class="para"> A constant and can take the following values: <b><tt>FBSQL_ASSOC</tt></b>, <b><tt>FBSQL_NUM</tt></b>, or <b><tt>FBSQL_BOTH</tt></b>. </p> <p class="para"> When using <b><tt>FBSQL_BOTH</tt></b>, 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> </dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns an array that corresponds to the fetched row, or <b><tt>FALSE</tt></b> if there are no more rows. </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 other column(s) of the same name, you must the numeric index of the column or make an alias for the column. <div class="informalexample"> <div class="example-contents"><div class="cdata"><pre>select t1.f1 as foo t2.f1 as bar from t1, t2</pre></div> </div> </div> </p> </div> <div class="refsect1 examples"> <h3 class="title">Examples</h3> <p class="para"> <div class="example"> <p><b>Example #1 <b>fbsql_fetch_array()</b> example</b></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 user_id, fullname 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_array</span><span style="color: #007700">(</span><span style="color: #0000BB">$result</span><span style="color: #007700">)) {<br /> echo </span><span style="color: #DD0000">"user_id: " </span><span style="color: #007700">. </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: #DD0000">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"user_id: " </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #0000BB">0</span><span style="color: #007700">] . </span><span style="color: #DD0000">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"fullname: " </span><span style="color: #007700">. </span><span style="color: #0000BB">$row</span><span style="color: #007700">[</span><span style="color: #DD0000">"fullname"</span><span style="color: #007700">] . </span><span style="color: #DD0000">"<br />\n"</span><span style="color: #007700">;<br /> echo </span><span style="color: #DD0000">"fullname: " </span><span style="color: #007700">. </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: #DD0000">"<br />\n"</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"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><a href="function.fbsql-fetch-row.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_row()</a></li> <li class="member"><a href="function.fbsql-fetch-assoc.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_assoc()</a></li> <li class="member"><a href="function.fbsql-fetch-object.html" class="function" rel="rdfs-seeAlso">fbsql_fetch_object()</a></li> </ul> </p> </div></div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.fbsql-error.html">fbsql_error</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.fbsql-fetch-assoc.html">fbsql_fetch_assoc</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>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -