<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >mysqli_report</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_real_query" HREF="function.mysqli-real-query.html"><LINK REL="NEXT" TITLE="mysqli_rollback" HREF="function.mysqli-rollback.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-real-query.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.mysqli-rollback.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.mysqli-report" ></A >mysqli_report</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN141006" ></A ><P > (PHP 5)</P >mysqli_report -- Enables or disables internal report functions</DIV ><DIV CLASS="refsect1" ><A NAME="AEN141009" ></A ><H2 >说明</H2 >bool <B CLASS="methodname" >mysqli_report</B > ( int flags )<BR ></BR ><P > <B CLASS="function" >mysqli_report()</B > is a powerful function to improve your queries and code during development and testing phase. Depending on the flags it reports errors from mysqli function calls or queries which don't use an index (or use a bad index). </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN141019" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >flags</CODE ></DT ><DD ><P > <DIV CLASS="table" ><A NAME="AEN141028" ></A ><P ><B >表 1. Supported flags</B ></P ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Name</TH ><TH >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD ><TT CLASS="constant" ><B >MYSQLI_REPORT_OFF</B ></TT ></TD ><TD >Turns reporting off</TD ></TR ><TR ><TD ><TT CLASS="constant" ><B >MYSQLI_REPORT_ERROR</B ></TT ></TD ><TD >Report errors from mysqli function calls</TD ></TR ><TR ><TD ><TT CLASS="constant" ><B >MYSQLI_REPORT_STRICT</B ></TT ></TD ><TD >Report warnings from mysqli function calls</TD ></TR ><TR ><TD ><TT CLASS="constant" ><B >MYSQLI_REPORT_INDEX</B ></TT ></TD ><TD >Report if no index or bad index was used in a query</TD ></TR ><TR ><TD ><TT CLASS="constant" ><B >MYSQLI_REPORT_ALL</B ></TT ></TD ><TD >Set all options (report all)</TD ></TR ></TBODY ></TABLE ></DIV > </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN141056" ></A ><H2 >返回值</H2 ><P > 如果成功则返回 <TT CLASS="constant" ><B >TRUE</B ></TT >,失败则返回 <TT CLASS="constant" ><B >FALSE</B ></TT >。 </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN141061" ></A ><H2 >范例</H2 ><P > <TABLE WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" CLASS="EXAMPLE" ><TR ><TD ><DIV CLASS="example" ><A NAME="AEN141064" ></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 /></font><font color="#FF8000">/* activate reporting */<br /></font><font color="#0000BB">mysqli_report</font><font color="#007700">(</font><font color="#0000BB">MYSQLI_REPORT_ALL</font><font color="#007700">);<br /><br /></font><font color="#0000BB">$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="#FF8000">/* this query should report an error */<br /></font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">query</font><font color="#007700">(</font><font color="#DD0000">"SELECT Name FROM Nonexistingtable WHERE population > 50000"</font><font color="#007700">);<br /><br /></font><font color="#FF8000">/* this query should report a warning */<br /></font><font color="#0000BB">$result </font><font color="#007700">= </font><font color="#0000BB">$mysqli</font><font color="#007700">-></font><font color="#0000BB">query</font><font color="#007700">(</font><font color="#DD0000">"SELECT Name FROM City WHERE population > 50000"</font><font color="#007700">);<br /></font><font color="#0000BB">$result</font><font color="#007700">-></font><font color="#0000BB">close</font><font color="#007700">();<br /><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 > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN141067" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.mysqli-debug.html" ><B CLASS="function" >mysqli_debug()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.mysqli-dump-debug-info.html" ><B CLASS="function" >mysqli_dump_debug_info()</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-real-query.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-rollback.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >mysqli_real_query</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_rollback</TD ></TR ></TABLE ></DIV ></BODY ></HTML >