CDbLogRoute写日志文件到MySQL数据库

一，配置文件

'log' => array(
    'class' => 'CLogRouter',
    'routes' => array(
        array(
            'class' => 'CFileLogRoute',
            'levels' => 'info, warning, error, profile, debug',
        ),
        
         array(
            'class'=>'CDbLogRoute',
            'connectionID'=>'db',
            'levels'=>'info, warning, error, profile, debug',
            'logTableName' => 'syslogs',
            'categories'=>'mail,web,',
         ),
    ),
)

二，创建数据库

CREATE TABLE `syslogs` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`level` VARCHAR(128) NULL DEFAULT NULL,
	`category` VARCHAR(128) NULL DEFAULT NULL,
	`logtime` INT(11) UNSIGNED NULL DEFAULT NULL,
	`message` TEXT NULL,
	PRIMARY KEY (`id`)
) COLLATE='utf8_general_ci' ENGINE=InnoDB AUTO_INCREMENT=1;

※将int型转换成date格式

select id, level , category , FROM_UNIXTIME(logtime), message , status from syslogs;

三，写日志

Yii::log("#######1", CLogger::LEVEL_ERROR, 'mail');
Yii::log("#######2", CLogger::LEVEL_INFO, 'web');
Yii::log("#######3", CLogger::LEVEL_PROFILE, 'mail');
Yii::log("#######4", CLogger::LEVEL_WARNING, 'web');
Yii::log("#######5", CLogger::LEVEL_WARNING, 'mail');