ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools

Trace:
v5:userguide:debug

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
v5:userguide:debug [2023/04/08 15:48] – [Description] Remove reference to STDERR dregadv5:userguide:debug [2025/06/01 13:21] (current) – Remove square brackets in tags dregad
Line 9: Line 9:
 ===== Description ===== ===== Description =====
  
-Enabling debug mode makes the driver return copious amounts of debugging information from both ADOdb and the PHP driver itself. +Enabling debug mode makes the driver return debugging information from both ADOdb and the PHP driver itself. 
 + 
 +The output includes the executed SQL statement with parameters, as well as error messages and backtrace information if there are problems. 
 +It is suitable for viewing in a browser (see [[#formatting|Formatting section below]])  
 + 
 +See [[v5:reference:logging]] for details on how to capture and redirect output.
 ===== Usage ===== ===== Usage =====
  
Line 20: Line 25:
 include 'adodb.inc.php'; include 'adodb.inc.php';
 $conn = newAdoConnection('mysqli'); $conn = newAdoConnection('mysqli');
 +
 +# Here is the earliest point where Debug Mode can be set
 +
 $conn->connect($host, $user, $pass, 'database'); $conn->connect($host, $user, $pass, 'database');
 +
 +# Enable Debug mode
 $conn->debug = true; $conn->debug = true;
 +
 $recordSet = $conn->execute('SELECT * FROM product'); $recordSet = $conn->execute('SELECT * FROM product');
 </code> </code>
Line 97: Line 108:
   * Some drivers, the SQL server driver in particular, produce overwhelming volumes of debugging information.   * Some drivers, the SQL server driver in particular, produce overwhelming volumes of debugging information.
  
-{{tag>[debugging]}}+{{tag>debugging}}
v5/userguide/debug.1680961692.txt.gz · Last modified: by dregad