mysqli::debug

    mysqli_debug

    (PHP 5, PHP 7, PHP 8)

    mysqli::debug -- mysqli_debug — Performs debugging operations

    Description

    Object-oriented style

    public mysqli::debug(string $options): true

    Procedural style

    mysqli_debug(string $options): true

    Performs debugging operations using the Fred Fish debugging library.

    Parameters

    options

    A string representing the debugging operation to perform

    The debug control string is a sequence of colon separated fields as follows: 

    <field_1>:<field_2>:<field_N>
    Each field consists of a mandatory flag character followed by an optional , and comma separated list of modifiers: flag[,modifier,modifier,...,modifier]

    Recognized Flag Characters
    options character Description
    O MYSQLND_DEBUG_FLUSH
    A/a MYSQLND_DEBUG_APPEND
    F MYSQLND_DEBUG_DUMP_FILE
    i MYSQLND_DEBUG_DUMP_PID
    L MYSQLND_DEBUG_DUMP_LINE
    m MYSQLND_DEBUG_TRACE_MEMORY_CALLS
    n MYSQLND_DEBUG_DUMP_LEVEL
    o output to file
    T MYSQLND_DEBUG_DUMP_TIME
    t MYSQLND_DEBUG_DUMP_TRACE
    x MYSQLND_DEBUG_PROFILE_CALLS

    Return Values

    Always returns true.

    Changelog

    Version Description
    8.0.0 This function now always returns true. Previously it returned false on failure.

    Examples

    Example #1 Generating a Trace File

    <?php

    /* Create a trace file in '/tmp/client.trace' on the local (client) machine: */
    mysqli_debug("d:t:o,/tmp/client.trace");

    ?>

    Notes

    Note:

    To use the mysqli_debug() function you must compile the MySQL client library to support debugging.

    See Also

    Found A Problem?

    Learn How To Improve This Page • Submit a Pull Request • Report a Bug
    ＋add a note

    User Contributed Notes 3 notes

    up
    29
    Peter
    11 years ago
    can there be more documenation with a small (but working) example script on how to use this ?Some issues  (Ive seen the "same" code example in dozens of tutorials):-( I'll use capitals for emphasis only)QUESTION: what does D:T:O mean ? UNEXPLAINED.QUESTION: Do we *ONLY* use these 3 lines in a self-contained script ? Does this log ALL future MYSQL commands ?QUESTION :- Do we put that one line just- immediately after we connect to MYSQL ?- before we connect to MYSQL ?- before our suspected error ?
    up
    6
    riversnowchang at gmail dot com
    7 years ago
    Here are the information about debug options on mysqli_debug()O,o:MYSQLND_DEBUG_FLUSHA,a:MYSQLND_DEBUG_APPENDF:MYSQLND_DEBUG_DUMP_FILEL:MYSQLND_DEBUG_DUMP_LINEm:MYSQLND_DEBUG_TRACE_MEMORY_CALLSn:MYSQLND_DEBUG_DUMP_LEVELo:output to fileT:MYSQLND_DEBUG_DUMP_TIMEt:MYSQLND_DEBUG_DUMP_TRACEx:MYSQLND_DEBUG_PROFILE_CALLSf:? still investigatingFor example, mysqli_debug("T:n:t:m:x:F:L:o,/tmp/client.trace");mysqlnd will write Time, Level, trace, memory calls, profile calls, File, Line to client.trace file.22:35:42.704501 ../mysqlnd_connection.c:  269   0:>mysqlnd_connection_init22:35:42.704538 ../mysqlnd_driver.c:   10   1:| >mysqlnd_driver::get_connection22:35:42.704549 ../mysqlnd_driver.c:   10   2:| | info : persistent=122:35:42.704558 ../mysqlnd_alloc.c:   21   2:| | >_mysqlnd_pecalloc22:35:42.704570 ../mysqlnd_alloc.c:   23   2:| | <_mysqlnd_pecalloc (total=3 own=3 in_calls=0)22:35:42.704602 ../mysqlnd_alloc.c:   21   2:| | >_mysqlnd_pecalloc22:35:42.704626 ../mysqlnd_alloc.c:   23   2:| | <_mysqlnd_pecalloc (total=2 own=2 in_calls=0)22:35:42.704650 ../mysqlnd_connection.c:   15   2:| | >mysqlnd_error_info_init22:35:42.704675 ../mysqlnd_connection.c:   10   3:| | | >mysqlnd_error_info::reset22:35:42.704697 ../mysqlnd_connection.c:   10   3:| | | <mysqlnd_error_info::reset (total=1 own=1 in_calls=0)22:35:42.704725 ../mysqlnd_connection.c:   16   2:| | <mysqlnd_error_info_init (total=51 own=50 in_calls=1)22:35:42.704744 ../mysqlnd_connection.c:   21   2:| | >mysqlnd_connection_state_initIf there is anything wrong, please let me know.
    up
    -1
    Domenic
    7 years ago
    Looks like this manual could be referred to:http://tiebing.blogspot.com.au/2011/10/cc-dbug-library.html(I haven't tested it)
    ＋add a note
    To Top