Seems not clear but flags *could be combined*, as per other flags.
For example:
<?php
# wannabe noticed about all errors except those about indexes
$driver = new mysqli_driver();
$driver->report_mode = MYSQLI_REPORT_ALL & ~MYSQLI_REPORT_INDEX;
?>
mysqli_driver::$report_mode
mysqli_report
(PHP 5, PHP 7)
mysqli_driver::$report_mode -- mysqli_report — Enables or disables internal report functions
설명
객체 기반 형식
절차식 형식
A function helpful in improving queries during code development and testing. Depending on the flags, it reports errors from mysqli function calls or queries that don't use an index (or use a bad index).
인수
-
flags -
Supported flags Name Description MYSQLI_REPORT_OFFTurns reporting off MYSQLI_REPORT_ERRORReport errors from mysqli function calls MYSQLI_REPORT_STRICTThrow mysqli_sql_exception for errors instead of warnings MYSQLI_REPORT_INDEXReport if no index or bad index was used in a query MYSQLI_REPORT_ALLSet all options (report all)
반환값
성공 시 TRUE를, 실패 시 FALSE를 반환합니다.
변경점
| 버전 | 설명 |
|---|---|
| 5.3.4 | Changing the reporting mode is now be per-request, rather than per-process. |
| 5.2.15 | Changing the reporting mode is now be per-request, rather than per-process. |
예제
Example #1 객체 기반 형식
<?php
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* activate reporting */
$driver = new mysqli_driver();
$driver->report_mode = MYSQLI_REPORT_ALL;
try {
/* this query should report an error */
$result = $mysqli->query("SELECT Name FROM Nonexistingtable WHERE population > 50000");
/* this query should report a bad index */
$result = $mysqli->query("SELECT Name FROM City WHERE population > 50000");
$result->close();
$mysqli->close();
} catch (mysqli_sql_exception $e) {
echo $e->__toString();
}
?>
Example #2 절차식 형식
<?php
/* activate reporting */
mysqli_report(MYSQLI_REPORT_ALL);
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* this query should report an error */
$result = mysqli_query("SELECT Name FROM Nonexistingtable WHERE population > 50000");
/* this query should report a bad index */
$result = mysqli_query("SELECT Name FROM City WHERE population > 50000");
mysqli_free_result($result);
mysqli_close($link);
?>
참고
- mysqli_debug() - Performs debugging operations
- mysqli_dump_debug_info() - Dump debugging information into the log
- mysqli_sql_exception
- set_exception_handler() - Sets a user-defined exception handler function
- error_reporting() - Sets which PHP errors are reported
add a note
User Contributed Notes 2 notes
nineoclick (atsymbol) gmail (dot) com ¶
7 years ago
welfordmartin at gmail dot com ¶
4 years ago
As a recommendaton on memory management please don't use the objective way your creating an object to specify one property and thats all your doing with it, much more effective both for the parser and for memory to use the proccedual style for setting the report flag.
