include_once IA_ROOT . ‘/lib/log/PDOHandler.php‘;
use Monolog\Logger;
class PDOHandler extends AbstractProcessingHandler { private $initialized = false; private $pdo; private $statement; public function __construct(PDO $pdo, $level = Logger::DEBUG, $bubble = true) { $this->pdo = $pdo; parent::__construct($level, $bubble); } protected function write(array $record) { if (!$this->initialized) { $this->initialize(); } $this->statement->execute(array( ‘channel‘ => $record[‘channel‘], ‘level‘ => $record[‘level‘], ‘message‘ => $record[‘formatted‘], ‘time‘ => $record[‘datetime‘]->format(‘U‘), )); } private function initialize() { $this->pdo->exec( ‘CREATE TABLE IF NOT EXISTS monolog ‘ .‘(channel VARCHAR(255), level INTEGER, message LONGTEXT, time INTEGER UNSIGNED)‘ ); $this->statement = $this->pdo->prepare( ‘INSERT INTO monolog (channel, level, message, time) VALUES (:channel, :level, :message, :time)‘ ); $this->initialized = true; } }
$loger = new Logger(‘name‘);
$pdo = new PDO(‘mysql:host=xxxxx;dbname=weishop;charset=utf8‘, ‘username‘, ‘password‘);
$dd = new PDOHandler($pdo);
$loger->pushHandler($dd);
$loger->addInfo(‘My logger is now ready‘);
$loger->debug("debug info2222");
原文：http://www.cnblogs.com/anjuncc/p/5796292.html