Differences

This shows you the differences between two versions of the page.

--- v5:reference:logging [2021/03/24 21:50] – mnewnham
+++ v5:reference:logging [2024/01/09 11:14] (current) – Remove duplicated information described under Debug Mode dregad
@@ Line 1: / Line 1: @@
 ====== Logging ======
-ADOdb provides an internal debugging system that exposes the SQL commands used to execute a command, as well as other messages that can provide guidance when, for example, trying to establish a connection to the database. The earliest that debugging can be started is after instantiating the driver but before connection. In its simplest usage, debugging is enabled as follows:
-<code php>
+ADOdb provides an internal debugging system that exposes the executed SQL commands, as well as other messages that can help when troubleshooting errors when, for example, trying to establish a connection to the database or an SQL statement fails.
-include '/adodb-dir/adodb.inc.php';
-$db = newAdoConnection('mysqli');
+The earliest that debugging can be started is after instantiating the driver but before connection.
-/*
+===== Usage =====
-* Initialize debugging
-*/
-$db->debug = true;
-$db->connect('host','user','pass','database');
+Please refer to [[v5:userguide:debug]] for details on usage.
-</code>
-This might produce output something like:
-<code>
------<hr>
-(mysqli): select * from usersx
------<hr>
-Query: select * from usersx failed. Table 'db.usersx' doesn't exist
-: Table 'db.usersx' doesn't exist
-ADOConnection._Execute(select * from usersx, false)% line 1313, file: C:\dev\GitHub\ADOdb\adodb.inc.php
-ADOConnection.Execute(select * from usersx)% line   46, file: C:\dev\tests\test7.php
-</code>
-The output is suitable for viewing in a browser, with messages from the database driver as well as backtrace data if there are problems. Note that debugging can be switched on and off during code execution as required.
-===== Alternative Debugging Levels =====
-The following alternative levels are available. Each produces a slightly different output.
-^ Debug Level  ^ Description  ^
-|true         |Default as described above     |
-|-1           |The most minimal logging level. Formatted as the default option, but does not include backtrace data or any ADOdb debugging/logging messages            |
-|-99          |Adds ADOdb messages to the above format, but no backtrace data            |
-|99           |The logging equivalent of **true**            |
-|2            |Use the datalogging object as described below|
 ===== Overriding The Default Logging Function =====