<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>mysqli_use_result</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REL="HOME"
TITLE="PHP 手册"
HREF="index.html"><LINK
REL="UP"
TITLE="MySQLi 扩展库"
HREF="ref.mysqli.html"><LINK
REL="PREVIOUS"
TITLE="mysqli_thread_safe"
HREF="function.mysqli-thread-safe.html"><LINK
REL="NEXT"
TITLE="mysqli_warning_count"
HREF="function.mysqli-warning-count.html"><META
HTTP-EQUIV="Content-type"
CONTENT="text/html; charset=UTF-8"></HEAD
><BODY
CLASS="refentry"
BGCOLOR="#FFFFFF"
TEXT="#000000"
LINK="#0000FF"
VLINK="#840084"
ALINK="#0000FF"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>PHP 手册</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="function.mysqli-thread-safe.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="function.mysqli-warning-count.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="function.mysqli-use-result"
></A
>mysqli_use_result</H1
><DIV
CLASS="refnamediv"
><A
NAME="AEN143174"
></A
><P
> (PHP 5)</P
>mysqli_use_result<P
> (no version information, might be only in CVS)</P
>mysqli->use_result() -- Initiate a result set retrieval</DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN143178"
></A
><H2
>说明</H2
><P
>Procedural style:</P
>mysqli_result <B
CLASS="methodname"
>mysqli_use_result</B
> ( mysqli link )<BR
></BR
><P
>Object oriented style (method):</P
>class <B
CLASS="classname"
>mysqli</B
> { <BR
></BR
>mysqli_result <B
CLASS="methodname"
>use_result</B
> ( void )<BR
></BR
>}<P
> Used to initiate the retrieval of a result set from the last query
executed using the <A
HREF="function.mysqli-real-query.html"
><B
CLASS="function"
>mysqli_real_query()</B
></A
> function on the
database connection.
</P
><P
> Either this or the <A
HREF="function.mysqli-store-result.html"
><B
CLASS="function"
>mysqli_store_result()</B
></A
> function must
be called before the results of a query can be retrieved, and one or the
other must be called to prevent the next query on that database connection
from failing.
</P
><DIV
CLASS="note"
><BLOCKQUOTE
CLASS="note"
><P
><B
>注意: </B
>
The <B
CLASS="function"
>mysqli_use_result()</B
> function does not transfer
the entire result set from the database and hence cannot be used functions
such as <A
HREF="function.mysqli-data-seek.html"
><B
CLASS="function"
>mysqli_data_seek()</B
></A
> to move to a particular
row within the set. To use this functionality, the result set must be
stored using <A
HREF="function.mysqli-store-result.html"
><B
CLASS="function"
>mysqli_store_result()</B
></A
>. One should not
use <B
CLASS="function"
>mysqli_use_result()</B
> if a lot of processing on
the client side is performed, since this will tie up the server and
prevent other threads from updating any tables from which the data is
being fetched.
</P
></BLOCKQUOTE
></DIV
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN143205"
></A
><H2
>返回值</H2
><P
> Returns an unbuffered result object or <TT
CLASS="constant"
><B
>FALSE</B
></TT
> if an error occurred.
</P
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN143209"
></A
><H2
>范例</H2
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN143211"
></A
><P
><B
>例 1. Object oriented style</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br />$mysqli </font><font color="#007700">= new </font><font color="#0000BB">mysqli</font><font color="#007700">(</font><font color="#DD0000">"localhost"</font><font color="#007700">, </font><font color="#DD0000">"my_user"</font><font color="#007700">, </font><font color="#DD0000">"my_password"</font><font color="#007700">, </font><font color="#DD0000">"world"</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* check connection */<br /></font><font color="#007700">if (</font><font color="#0000BB">mysqli_connect_errno</font><font color="#007700">()) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"Connect failed: %s\n"</font><font color="#007700">, </font><font color="#0000BB">mysqli_connect_error</font><font color="#007700">());<br /> exit();<br />}<br /><br /></font><font color="#0000BB">$query </font><font color="#007700">= </font><font color="#DD0000">"SELECT CURRENT_USER();"</font><font color="#007700">;<br /></font><font color="#0000BB">$query </font><font color="#007700">.= </font><font color="#DD0000">"SELECT Name FROM City ORDER BY ID LIMIT 20, 5"</font><font color="#007700">;<br /><br /></font><font color="#FF8000">/* execute multi query */<br /></font><font color="#007700">if (</font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">multi_query</font><font color="#007700">(</font><font color="#0000BB">$query</font><font color="#007700">)) {<br /> do {<br /> </font><font color="#FF8000">/* store first result set */<br /> </font><font color="#007700">if (</font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">use_result</font><font color="#007700">()) {<br /> while (</font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">$result</font><font color="#007700">-></font><font color="#0000BB">fetch_row</font><font color="#007700">()) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"%s\n"</font><font color="#007700">, </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#0000BB">0</font><font color="#007700">]);<br /> }<br /> </font><font color="#0000BB">$result</font><font color="#007700">-></font><font color="#0000BB">close</font><font color="#007700">();<br /> }<br /> </font><font color="#FF8000">/* print divider */<br /> </font><font color="#007700">if (</font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">more_results</font><font color="#007700">()) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"-----------------\n"</font><font color="#007700">);<br /> }<br /> } while (</font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">next_result</font><font color="#007700">());<br />}<br /><br /></font><font color="#FF8000">/* close connection */<br /></font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">close</font><font color="#007700">();<br /></font><font color="#0000BB">?></font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
CLASS="EXAMPLE"
><TR
><TD
><DIV
CLASS="example"
><A
NAME="AEN143214"
></A
><P
><B
>例 2. Procedural style</B
></P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><code><font color="#000000">
<font color="#0000BB"><?php<br />$link </font><font color="#007700">= </font><font color="#0000BB">mysqli_connect</font><font color="#007700">(</font><font color="#DD0000">"localhost"</font><font color="#007700">, </font><font color="#DD0000">"my_user"</font><font color="#007700">, </font><font color="#DD0000">"my_password"</font><font color="#007700">, </font><font color="#DD0000">"world"</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* check connection */<br /></font><font color="#007700">if (</font><font color="#0000BB">mysqli_connect_errno</font><font color="#007700">()) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"Connect failed: %s\n"</font><font color="#007700">, </font><font color="#0000BB">mysqli_connect_error</font><font color="#007700">());<br /> exit();<br />}<br /><br /></font><font color="#0000BB">$query </font><font color="#007700">= </font><font color="#DD0000">"SELECT CURRENT_USER();"</font><font color="#007700">;<br /></font><font color="#0000BB">$query </font><font color="#007700">.= </font><font color="#DD0000">"SELECT Name FROM City ORDER BY ID LIMIT 20, 5"</font><font color="#007700">;<br /><br /></font><font color="#FF8000">/* execute multi query */<br /></font><font color="#007700">if (</font><font color="#0000BB">mysqli_multi_query</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">, </font><font color="#0000BB">$query</font><font color="#007700">)) {<br /> do {<br /> </font><font color="#FF8000">/* store first result set */<br /> </font><font color="#007700">if (</font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">mysqli_use_result</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">)) {<br /> while (</font><font color="#0000BB">$row </font><font color="#007700">= </font><font color="#0000BB">mysqli_fetch_row</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">)) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"%s\n"</font><font color="#007700">, </font><font color="#0000BB">$row</font><font color="#007700">[</font><font color="#0000BB">0</font><font color="#007700">]);<br /> }<br /> </font><font color="#0000BB">mysqli_free_result</font><font color="#007700">(</font><font color="#0000BB">$result</font><font color="#007700">);<br /> }<br /> </font><font color="#FF8000">/* print divider */<br /> </font><font color="#007700">if (</font><font color="#0000BB">mysqli_more_results</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">)) {<br /> </font><font color="#0000BB">printf</font><font color="#007700">(</font><font color="#DD0000">"-----------------\n"</font><font color="#007700">);<br /> }<br /> } while (</font><font color="#0000BB">mysqli_next_result</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">));<br />}<br /><br /></font><font color="#FF8000">/* close connection */<br /></font><font color="#0000BB">mysqli_close</font><font color="#007700">(</font><font color="#0000BB">$link</font><font color="#007700">);<br /></font><font color="#0000BB">?></font>
</font>
</code></TD
></TR
></TABLE
></DIV
></TD
></TR
></TABLE
><P
>上例将输出：</P
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
CELLPADDING="5"
><TR
><TD
><PRE
CLASS="screen"
>my_user@localhost
-----------------
Amersfoort
Maastricht
Dordrecht
Leiden
Haarlemmermeer</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="refsect1"
><A
NAME="AEN143219"
></A
><H2
>参见</H2
><P
> <P
></P
><TABLE
BORDER="0"
><TBODY
><TR
><TD
><A
HREF="function.mysqli-real-query.html"
><B
CLASS="function"
>mysqli_real_query()</B
></A
></TD
></TR
><TR
><TD
><A
HREF="function.mysqli-store-result.html"
><B
CLASS="function"
>mysqli_store_result()</B
></A
></TD
></TR
></TBODY
></TABLE
><P
></P
>
</P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="function.mysqli-thread-safe.html"
ACCESSKEY="P"
>上一页</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>起始页</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="function.mysqli-warning-count.html"
ACCESSKEY="N"
>下一页</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>mysqli_thread_safe</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ref.mysqli.html"
ACCESSKEY="U"
>上一级</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>mysqli_warning_count</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>
