ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:performance:invalidsql

invalidSql

Syntax
string invalidSql()

Description

The function invalidSql() returns a list of invalid SQL statements collected by the performance monitor logSql feature, formatted as an HTML table.

Usage

/*
* Connection to DB2 database
*/
 
$perf = newPerfMonitor($db);
 
/*
 * Enable logging
*/
$db->logSql();
 
/*
 * Execute invalid SQL statement
*/
$SQL = "SELECT * FROM act where actno > 'A'";
 
$db->execute($SQL);
 
 
$h = $perf->invalidSql();

Output

v5/performance/invalidsql.txt · Last modified: 2024/03/21 16:16 by dregad