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.

Table of Content

PHP ADOdb Tutorial

ADOdb Intro
ADOdb Connection
ADOdb Select
ADOdb show tables
ADOdb show fields
ADOdb show db
ADOdb Caching
ADOdb Recordset
ADOdb Multi DB
ADOdb Dictionary
ADOdb Export
ADOdb Insert
ADOdb Replace
ADOdb Log
ADOdb Pivot Table
Creating Pivot Table
Query Pivot Table

Database Tutorial

Security Tutorial

Framework Tutorial

Template Tutorial

API Tutorial

Learn Facebook

JS Framework Tutorial

AJAX Tutorial

Web Services Tutorial

Package Post