一：在配置文件的log組件中配置dbtarget
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
'log' => [ 'tracelevel' => yii_debug ? 3 : 0, 'targets' => [ [ 'class' => 'yii\log\filetarget', 'levels' => ['error', 'warning'], ], 'test' => [ 'class' => 'yii\log\dbtarget',//datarget類 'logtable' => '{{%test_log}}',//日志表 'levels' => ['error', 'info', 'warning'],//日志等級 ], ],], |
二：生成日志表
在項目目錄下執行如下命令生成日志表
|
1
|
php yii migrate --migrationpath=@yii/log/migrations/ |
三：使用日志
在需要使用日志的地方使用
|
1
|
yii::info() |
四：自定義dbtarget日志
1：首先創建一個自定義的日志表
(1)在項目目錄下執行
|
1
|
php yii migrate/create create_test_log |
(2)：在創建的migrate文件下編寫創建數據庫的遷移腳本
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
<?phpuse yii\db\migration;/** * class m200720_091126_create_test_log */class m200720_091126_create_test_log extends migration{ /** * {@inheritdoc} */ public function safeup() { $this->createtable('{{%test_log}}', [ 'id' => $this->bigprimarykey(), 'level' => $this->integer()->notnull()->comment('日志等級'), 'category' => $this->string(100)->notnull()->comment('分類名稱'), 'prefix' => $this->text(), 'route' => $this->string(100)->notnull()->comment('路由'), 'method' => $this->string(20)->notnull()->comment('請求方式'), 'app' => $this->string(20)->comment('請求應用'), 'module' => $this->string(20)->comment('請求模塊'), 'request' => $this->text()->comment('請求參數'), 'status' => $this->string(10)->notnull()->comment('狀態碼'), 'message' => $this->text()->comment('日志內容'), 'request_at' => $this->double()->notnull()->comment('請求時間'), 'ip' => $this->string(63)->comment('請求ip'), ], 'character set utf8mb4 collate utf8mb4_unicode_ci engine=innodb comment=\'請求日志表\''); //增加索引 $this->createindex('idx_log_level', '{{%test_log}}', 'level'); $this->createindex('idx_log_category', '{{%test_log}}', 'category'); $this->createindex('idx_log_route', '{{%test_log}}', 'route'); $this->createindex('idx_log_method', '{{%test_log}}', 'method'); $this->createindex('idx_log_status', '{{%test_log}}', 'status'); } /** * @inheritdoc */ public function safedown() { $this->droptable('{{%test_log}}'); }} |
(3)：執行如下命令生成dbtarget日志表
|
1
|
php yii migrate |
2：編寫一個dbtarget類來繼承yiilogdbtarget類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
|
<?phpnamespace app\components;use yii;use yii\helpers\vardumper;use yii\log\logruntimeexception;use yii\web\httpexception;use yii\web\request;/** * dbtarget stores log messages in a database table. * * @see yii\log\dbtarget * * @author wangjian * @since 1.0 */class dbtarget extends \yii\log\dbtarget{ /** * @inheritdoc */ public $categories = [ 'application', 'yii\web\httpexception:*', ]; /** * @inheritdoc */ public $except = [ // 'yii\web\httpexception:404', ]; /** * @inheritdoc */ public $logvars = ['_get', '_post']; /** * @var string 用戶組件id */ public $usercomponentid = 'user'; /** * @inheritdoc */ public function collect($messages, $final) { $this->messages = array_merge($this->messages, static::filtermessages($messages, $this->getlevels(), $this->categories, $this->except)); $count = count($this->messages); if ($count > 0 && ($final || $this->exportinterval > 0 && $count >= $this->exportinterval)) { $oldexportinterval = $this->exportinterval; $this->exportinterval = 0; $this->export(); $this->exportinterval = $oldexportinterval; $this->messages = []; } } /** * @inheritdoc */ public function getmessageprefix($message) { if ($this->prefix !== null) { return call_user_func($this->prefix, $message); } if (yii::$app === null) { return ''; } $ip = $this->getip(); $ip = empty($ip) ? '-' : $ip; return "[$ip]"; } /** * @inheritdoc */ public function export() { if ($this->db->gettransaction()) { $this->db = clone $this->db; } $tablename = $this->db->quotetablename($this->logtable); $sql = "insert into $tablename ([[level]], [[category]], [[prefix]], [[route]], [[method]], [[app]], [[module]], [[request]], [[status]], [[message]], [[request_at]], [[ip]]) values (:level, :category, :prefix, :route, :method, :app, :module, :request, :status, :message, :request_at, :ip)"; $command = $this->db->createcommand($sql); $request = yii::$app->getrequest(); list($route, $params) = $request->resolve(); $method = $request->getmethod(); $module = yii::$app->controller->module->id; $route = str_replace("{$module}/", '', $route); foreach ($this->messages as $message) { list($text, $level, $category, $timestamp) = $message; $statuscode = 200; if (!is_string($text)) { if ($text instanceof \throwable || $text instanceof \exception) { $statuscode = $text instanceof httpexception ? $text->statuscode : 500; $text = $text->getmessage(); } else { $text = vardumper::export($text); } } if ($command->bindvalues([ ':level' => $level, ':category' => $category, ':prefix' => $this->getmessageprefix($message), ':route' => $route, ':method' => $method, ':app' => yii::$app->id, ':module' => $module, ':request' => $this->getcontextmessage(), ':status' => $statuscode, ':message' => $text, ':request_at' => $timestamp, ':ip' => $this->getip(), ])->execute() > 0) { continue; } throw new logruntimeexception('unable to export log through database!'); } } /** * 獲取當前ip */ protected function getip() { $request = yii::$app->getrequest(); return $request instanceof request ? $request->getuserip() : ''; }} |
3：在配置文件中將yiilogdbtarget類改成我們自定義的類
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
'log' => [ 'tracelevel' => yii_debug ? 3 : 0, 'targets' => [ [ 'class' => 'yii\log\filetarget', 'levels' => ['error', 'warning'], ], 'test' => [ 'class' => 'app\components\dbtarget', 'logtable' => '{{%test_log}}', 'levels' => ['error', 'info', 'warning'], ], ],], |
4：使用dbtarget日志
同樣的使用yii::info來記錄日志
到此這篇關于yii使用dbtarget實現日志功能的示例代碼的文章就介紹到這了,更多相關yii dbtarget 日志內容請搜索服務器之家以前的文章或繼續瀏覽下面的相關文章希望大家以后多多支持服務器之家！
原文鏈接：https://segmentfault.com/a/1190000023313633
