📄 function.maxdb-stmt-fetch.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Fetch results from a prepared statement into the bound variables</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.maxdb-stmt-execute.html">maxdb_stmt_execute</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.maxdb-stmt-free-result.html">maxdb_stmt_free_result</a></div> <div class="up"><a href="ref.maxdb.html">MaxDB Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="function.maxdb-stmt-fetch" class="refentry"> <div class="refnamediv"> <h1 class="refname">maxdb_stmt_fetch</h1> <h1 class="refname">stmt->fetch</h1> <p class="verinfo">(PECL maxdb:1.0-7.6.00.38)</p><p class="refpurpose"><span class="refname">maxdb_stmt_fetch</span> -- <span class="refname">stmt->fetch</span> — <span class="dc-title">Fetch results from a prepared statement into the bound variables</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <p class="para">Procedural style:</p> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><b>maxdb_stmt_fetch</b></b></span> ( <span class="methodparam"><span class="type">resource</span> <tt class="parameter">$stmt</tt></span> )</div> <p class="para rdfs-comment">Object oriented style (method):</p> <div class="classsynopsis"> <div class="ooclass"><b class="classname">stmt</b></div> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><b>fetch</b></b></span> ( <span class="methodparam">void</span> )</div> </div> <p class="para"> <b>maxdb_stmt_fetch()</b> returns row data using the variables bound by <a href="function.maxdb-stmt-bind-result.html" class="function">maxdb_stmt_bind_result()</a>. </p> <blockquote><p><b class="note">Note</b>: Note that all columns must be bound by the application before calling <b>maxdb_stmt_fetch()</b>. <br /> </p></blockquote> </div> <div class="refsect1 returnvalues"> <h3 class="title">Return Values</h3> <table border="5"> <caption><b>Return values</b></caption> <colgroup> <thead valign="middle"> <tr valign="middle"> <th colspan="1">Value</th> <th colspan="1">Description</th> </tr> </thead> <tbody valign="middle" class="tbody"> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>TRUE</tt></b></td> <td colspan="1" rowspan="1" align="left">Success. Data has been fetched</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>FALSE</tt></b></td> <td colspan="1" rowspan="1" align="left">Error occured</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>NULL</tt></b></td> <td colspan="1" rowspan="1" align="left">No more rows/data exists</td> </tr> </tbody> </colgroup> </table> </div> <div class="refsect1 examples"> <h3 class="title">Examples</h3> <div class="example"> <p><b>Example #1 Object oriented style</b></p> <div class="example-contents"><div class="phpcode"><code><span style="color: #000000"><span style="color: #0000BB"><?php<br />$maxdb </span><span style="color: #007700">= new </span><span style="color: #0000BB">maxdb</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"MONA"</span><span style="color: #007700">, </span><span style="color: #DD0000">"RED"</span><span style="color: #007700">, </span><span style="color: #DD0000">"DEMODB"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* check connection */<br /></span><span style="color: #007700">if (</span><span style="color: #0000BB">maxdb_connect_errno</span><span style="color: #007700">()) {<br /> </span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect failed: %s\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">maxdb_connect_error</span><span style="color: #007700">());<br /> exit();<br />}<br /><br /></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT zip, name FROM hotel.city ORDER by name"</span><span style="color: #007700">;<br /><br />if (</span><span style="color: #0000BB">$stmt </span><span style="color: #007700">= </span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-></span><span style="color: #0000BB">prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$query</span><span style="color: #007700">)) {<br /><br /> </span><span style="color: #FF8000">/* execute statement */<br /> </span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-></span><span style="color: #0000BB">execute</span><span style="color: #007700">();<br /><br /> </span><span style="color: #FF8000">/* bind result variables */<br /> </span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-></span><span style="color: #0000BB">bind_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$name</span><span style="color: #007700">, </span><span style="color: #0000BB">$code</span><span style="color: #007700">);<br /><br /> </span><span style="color: #FF8000">/* fetch values */<br /> </span><span style="color: #007700">while (</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-></span><span style="color: #0000BB">fetch</span><span style="color: #007700">()) {<br /> </span><span style="color: #0000BB">printf </span><span style="color: #007700">(</span><span style="color: #DD0000">"%s (%s)\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">$name</span><span style="color: #007700">, </span><span style="color: #0000BB">$code</span><span style="color: #007700">);<br /> }<br /><br /> </span><span style="color: #FF8000">/* close statement */<br /> </span><span style="color: #0000BB">$stmt</span><span style="color: #007700">-></span><span style="color: #0000BB">close</span><span style="color: #007700">();<br />}<br /><br /></span><span style="color: #FF8000">/* close connection */<br /></span><span style="color: #0000BB">$maxdb</span><span style="color: #007700">-></span><span style="color: #0000BB">close</span><span style="color: #007700">();<br /></span><span style="color: #0000BB">?></span></span></code></div> </div> </div> <div class="example"> <p><b>Example #2 Procedural style</b></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">maxdb_connect</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"MONA"</span><span style="color: #007700">, </span><span style="color: #DD0000">"RED"</span><span style="color: #007700">, </span><span style="color: #DD0000">"DEMODB"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* check connection */<br /></span><span style="color: #007700">if (</span><span style="color: #0000BB">maxdb_connect_errno</span><span style="color: #007700">()) {<br /> </span><span style="color: #0000BB">printf</span><span style="color: #007700">(</span><span style="color: #DD0000">"Connect failed: %s\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">maxdb_connect_error</span><span style="color: #007700">());<br /> exit();<br />}<br /><br /></span><span style="color: #0000BB">$query </span><span style="color: #007700">= </span><span style="color: #DD0000">"SELECT zip, name FROM hotel.city ORDER by name"</span><span style="color: #007700">;<br /><br />if (</span><span style="color: #0000BB">$stmt </span><span style="color: #007700">= </span><span style="color: #0000BB">maxdb_prepare</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">, </span><span style="color: #0000BB">$query</span><span style="color: #007700">)) {<br /><br /> </span><span style="color: #FF8000">/* execute statement */<br /> </span><span style="color: #0000BB">maxdb_stmt_execute</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">);<br /><br /> </span><span style="color: #FF8000">/* bind result variables */<br /> </span><span style="color: #0000BB">maxdb_stmt_bind_result</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">, </span><span style="color: #0000BB">$name</span><span style="color: #007700">, </span><span style="color: #0000BB">$code</span><span style="color: #007700">);<br /><br /> </span><span style="color: #FF8000">/* fetch values */<br /> </span><span style="color: #007700">while (</span><span style="color: #0000BB">maxdb_stmt_fetch</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">)) {<br /> </span><span style="color: #0000BB">printf </span><span style="color: #007700">(</span><span style="color: #DD0000">"%s (%s)\n"</span><span style="color: #007700">, </span><span style="color: #0000BB">$name</span><span style="color: #007700">, </span><span style="color: #0000BB">$code</span><span style="color: #007700">);<br /> }<br /><br /> </span><span style="color: #FF8000">/* close statement */<br /> </span><span style="color: #0000BB">maxdb_stmt_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$stmt</span><span style="color: #007700">);<br />}<br /><br /></span><span style="color: #FF8000">/* close connection */<br /></span><span style="color: #0000BB">maxdb_close</span><span style="color: #007700">(</span><span style="color: #0000BB">$link</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">?></span></span></code></div> </div> </div> <p class="para">The above example will output something similar to:</p> <div class="example-contents"><pre><div class="cdata"><pre>12203 (Albany)60601 (Chicago)60615 (Chicago)45211 (Cincinnati)33575 (Clearwater)75243 (Dallas)32018 (Daytona Beach)33441 (Deerfield Beach)48226 (Detroit)90029 (Hollywood)92714 (Irvine)90804 (Long Beach)11788 (Long Island)90018 (Los Angeles)70112 (New Orleans)10019 (New York)10580 (New York)92262 (Palm Springs)97213 (Portland)60018 (Rosemont)95054 (Santa Clara)20903 (Silver Spring)20005 (Washington)20019 (Washington)20037 (Washington)</pre></div> </pre></div> </div> <div class="refsect1 seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><a href="function.maxdb-prepare.html" class="function" rel="rdfs-seeAlso">maxdb_prepare()</a></li> <li class="member"><a href="function.maxdb-stmt-errno.html" class="function" rel="rdfs-seeAlso">maxdb_stmt_errno()</a></li> <li class="member"><a href="function.maxdb-stmt-error.html" class="function" rel="rdfs-seeAlso">maxdb_stmt_error()</a></li> <li class="member"><a href="function.maxdb-stmt-bind-result.html" class="function" rel="rdfs-seeAlso">maxdb_stmt_bind_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.maxdb-stmt-execute.html">maxdb_stmt_execute</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.maxdb-stmt-free-result.html">maxdb_stmt_free_result</a></div> <div class="up"><a href="ref.maxdb.html">MaxDB 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 + -