function.mysqli-report.html
来自「php的帮助文档,涉及到PHP的案例和基本语法,以及实际应用内容」· HTML 代码 · 共 144 行
HTML
144 行
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <title>Enables or disables internal report functions</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.mysqli-param-count.html">mysqli_param_count</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mysqli-rpl-parse-enabled.html">mysqli_rpl_parse_enabled</a></div> <div class="up"><a href="ref.mysqli.html">Aliases and deprecated Mysqli Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div><hr /><div id="function.mysqli-report" class="refentry"> <div class="refnamediv"> <h1 class="refname">mysqli_report</h1> <p class="verinfo">(PHP 5)</p><p class="refpurpose"><span class="refname">mysqli_report</span> — <span class="dc-title">Enables or disables internal report functions</span></p> </div> <div class="refsect1 description"> <h3 class="title">Description</h3> <div class="methodsynopsis dc-description"> <span class="type">bool</span> <span class="methodname"><b><b>mysqli_report</b></b></span> ( <span class="methodparam"><span class="type">int</span> <tt class="parameter">$flags</tt></span> )</div> <p class="para rdfs-comment"> <b>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 parameters"> <h3 class="title">Parameters</h3> <p class="para"> <dl> <dt> <span class="term"><i><tt class="parameter">flags</tt></i></span> <dd> <p class="para"> <table border="5"> <caption><b>Supported flags</b></caption> <colgroup> <thead valign="middle"> <tr valign="middle"> <th colspan="1">Name</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>MYSQLI_REPORT_OFF</tt></b></td> <td colspan="1" rowspan="1" align="left">Turns reporting off</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>MYSQLI_REPORT_ERROR</tt></b></td> <td colspan="1" rowspan="1" align="left">Report errors from mysqli function calls</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>MYSQLI_REPORT_STRICT</tt></b></td> <td colspan="1" rowspan="1" align="left">Report warnings from mysqli function calls</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>MYSQLI_REPORT_INDEX</tt></b></td> <td colspan="1" rowspan="1" align="left">Report if no index or bad index was used in a query</td> </tr> <tr valign="middle"> <td colspan="1" rowspan="1" align="left"><b><tt>MYSQLI_REPORT_ALL</tt></b></td> <td colspan="1" rowspan="1" align="left">Set all options (report all)</td> </tr> </tbody> </colgroup> </table> </p> </dd> </dt> </dl> </p> </div> <div class="refsect1 returnvalues"> <h3 class="title">Return Values</h3> <p class="para"> Returns <b><tt>TRUE</tt></b> on success or <b><tt>FALSE</tt></b> on failure. </p> </div> <div class="refsect1 examples"> <h3 class="title">Examples</h3> <p class="para"> <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 /></span><span style="color: #FF8000">/* activate reporting */<br /></span><span style="color: #0000BB">mysqli_report</span><span style="color: #007700">(</span><span style="color: #0000BB">MYSQLI_REPORT_ALL</span><span style="color: #007700">);<br /><br /></span><span style="color: #0000BB">$mysqli </span><span style="color: #007700">= new </span><span style="color: #0000BB">mysqli</span><span style="color: #007700">(</span><span style="color: #DD0000">"localhost"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_user"</span><span style="color: #007700">, </span><span style="color: #DD0000">"my_password"</span><span style="color: #007700">, </span><span style="color: #DD0000">"world"</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">mysqli_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">mysqli_connect_error</span><span style="color: #007700">());<br /> exit();<br />}<br /><br /></span><span style="color: #FF8000">/* this query should report an error */<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT Name FROM Nonexistingtable WHERE population > 50000"</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/* this query should report a warning */<br /></span><span style="color: #0000BB">$result </span><span style="color: #007700">= </span><span style="color: #0000BB">$mysqli</span><span style="color: #007700">-></span><span style="color: #0000BB">query</span><span style="color: #007700">(</span><span style="color: #DD0000">"SELECT Name FROM City WHERE population > 50000"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$result</span><span style="color: #007700">-></span><span style="color: #0000BB">close</span><span style="color: #007700">();<br /><br /></span><span style="color: #0000BB">$mysqli</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> </p> </div> <div class="refsect1 seealso"> <h3 class="title">See Also</h3> <p class="para"> <ul class="simplelist"> <li class="member"><a href="mysqli.debug.html" class="function" rel="rdfs-seeAlso">mysqli_debug()</a></li> <li class="member"><a href="mysqli.dump-debug-info.html" class="function" rel="rdfs-seeAlso">mysqli_dump_debug_info()</a></li> </ul> </p> </div></div><hr /><div style="text-align: center;"> <div class="prev" style="text-align: left; float: left;"><a href="function.mysqli-param-count.html">mysqli_param_count</a></div> <div class="next" style="text-align: right; float: right;"><a href="function.mysqli-rpl-parse-enabled.html">mysqli_rpl_parse_enabled</a></div> <div class="up"><a href="ref.mysqli.html">Aliases and deprecated Mysqli Functions</a></div> <div class="home"><a href="index.html">PHP Manual</a></div></div></body></html>⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?