You can add this library as a local, per-project dependency to your project using Composer:
composer require pianzhou/monolog
CREATE TABLE IF NOT EXISTS `t_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`message` text NOT NULL,
`channel` varchar(20) NOT NULL,
`level_name` varchar(20) NOT NULL,
`level` smallint(6) NOT NULL,
`context` text NOT NULL,
`extra` text NOT NULL,
`datetime` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
COMMIT;
$dbHandler = new \Pianzhou\Monolog\Handler\DatabaseHandler(
new PDO('mysql:host=localhost;dbname=test', 'root', ''),
't_logs',
\Monolog\Logger::DEBUG,
true
);
$dbHandler->setFormatter(new \Pianzhou\Monolog\Formatter\TransformScalarFormatter());
$logger = new \Monolog\Logger('测试', [
$dbHandler,
]);
$logger->info('测试一下写入数据库');
$dbHandler = new \Pianzhou\Monolog\Handler\DatabaseHandler(
new Illuminate\Database\MySqlConnection(
new PDO('mysql:host=localhost;dbname=test', 'root', '')
),
't_logs',
\Monolog\Logger::DEBUG,
true
);
$dbHandler->setFormatter(new \Pianzhou\Monolog\Formatter\TransformScalarFormatter());
$logger = new \Monolog\Logger('测试', [
$dbHandler,
]);
$logger->info('测试一下写入数据库');
通过上面的demo,我们就可以很轻松的将日志文件记录到数据库中了。另外,如果使用BufferHandler批量化写入日志的话,DatabaseHandler会一次性批量化的将日志记录写入数据库,而不是一条条记录。
相关链接: