Zend_Log_Writer_Db - Customising table columns

12. January
2010

Written by Miha

Zend offers different logging possibilities. I won't present them all.

The basic of logging possibilities is Zend_Log_Writer_Db which logs in database. By default there are timestamp, message, priority and priorityName entries. If you want to log your own entry that is you want some custom fields to be logged you have to deal with event array. To add a custom field use setEventItem() method.

$db; //was initialized sooner it holds our database adapter
$dbTableName; //initialized sooner, the name of our table
 
$columnMapping = array(
 'timestamp' => 'timestamp',
 'priorityName' => 'priorityName',
 'priorityLevel' => 'priority',
 'userIp' => 'userip',
 'userHost' => 'userhost',
 'message' => 'message'
 );
 
//register writer
$dbWriter = new Zend_Log_Writer_Db();
//register logger
$logger = new Zend_Log( $dbWriter );
 
//add custom params to log
$logger-><strong>setEventItem('userIp', $userIp);</strong>
$logger->setEventItem('userHost', $userHost;
 
$logger->log("something to log ...");

blog comments powered by Disqus

< Prev		Next >