Zend_Log plugin using Database and Filter

This example shows how to set up a logging feature in your application. You are able to control the level of logging.

Database initialisation

$db->query('CREATE TABLE `log` (
   `uid` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,  
   `timestamp` VARCHAR(64),
   `lvl` VARCHAR(6),
   `msg` VARCHAR(256));
');

config.ini

[general]
; Debugging Log level 0 - 7
logLevel = 7

MyPlugin_Logger class

class MyPlugin_Logger extends Zend_Controller_Plugin_Abstract
{
    /**
     * Set up logging
     */
    public function preDispatch(Zend_Controller_Request_Abstract $request)
    {
        $logLevel = intval(Zend_Registry::get('config')->general->logLevel);
        
        $db = Zend_Db::factory('PDO_SQLITE', array('dbname' => DB));
        
        $columnMapping = array(
            'timestamp' => 'timestamp',
            'lvl' => 'priorityName',
            'msg' => 'message'
        );
        
        $writer = new Zend_Log_Writer_Db($db, 'log', $columnMapping);
        
        $writer->addFilter(new Zend_Log_Filter_Priority($logLevel));

        Zend_Registry::set('logger', new Zend_Log($writer));
    }
}

Example usage

Zend_Registry::get('logger')->debug('Some Debug Trace!');
Zend_Registry::get('logger')->info('Informational message!');
...

Page Operations

Browse Space

Zend_Log plugin using Database and Filter

Labels

Database initialisation

config.ini

MyPlugin_Logger class

Example usage