ADOdb: Log Query

Like its name, log query used for record all query that ever request. So, you can monitor all activity that your web visitor do. Function for recording query activity is logSQL().

<?
include ("adodb/adodb.inc.php");
include ("adodb/toexport.inc.php");

$db = ADONewConnection('mysql');
$db->Connect('localhost','root','pass','employee');

$sql = "SELECT * FROM staff";
$db->LogSQL();
$rs  = &$db->Execute($sql);
echo "<Pre>";
echo rs2cvs($rs);
echo "</Pre>";
$db->LogSQL(false);
$db->Close();
?>

Data log you can find at table adodb_logsql. If not exist, ADOdb will create automatically for you.