PHP MySQLi mysqli_debug() - System Debugging

mysqli_debug()

The mysqli_debug() function is used to perform debugging operations and record execution traces into a file.

EXAMPLE

<?php
// Enable debug and write to the trace.txt file
mysqli_debug("d:t:o,trace.txt");

$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

// NOTE: The mysqli_debug function creates a hidden trace.txt file 
// on the server at the very beginning. Once the connection is established successfully, a detailed 
// system log will be written to this file regarding every bit that traveled between PHP and the database.
if ($connection) {
    echo "System tracing is activated.";
    mysqli_close($connection);
}
?>

RESULT

The result will be displayed here...

The function accepts a string containing commands, such as "d:t:o,file.txt".

It logs data about function calls and system messages.

It is only useful for advanced users developing their own extensions.