laravel 使用事件监听sql

最新推荐文章于 2023-05-29 16:16:42 发布

channel_海峡

最新推荐文章于 2023-05-29 16:16:42 发布

阅读量456

点赞数

分类专栏： PHP框架 PHP

本文链接：https://blog.csdn.net/qq_31164125/article/details/117228099

版权

PHP 同时被 2 个专栏收录

41 篇文章 1 订阅

订阅专栏

PHP框架

31 篇文章 1 订阅

订阅专栏

创建监听

php artisan make:listener DbSqlListener

DbSqlListener.php

<?php

namespace App\Listeners;

use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Database\Events\QueryExecuted;
use Illuminate\Queue\InteractsWithQueue;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\DB;

class DbSqlListener
{
    /**
     * Create the event listener.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }

    /**
     * Handle the event.
     *
     * @param  object  $event
     * @return void
     */
    public function handle(QueryExecuted $event)
    {
        DB::listen(function (QueryExecuted $event){
            $sql = $event->sql;
            $bindings = $event->bindings;
            $time = $event->time;
            //给参数加引号
            $bindings = array_map(function ($binding){
                if(is_string($binding)){
                    return "'$binding'";
                }elseif($binding instanceof \DateTime){  //如果是时间类型，也要转换
                    return $binding->format("''Y-m-d H:i:s");
                }
                return $binding;
            },$bindings);
            $sql = str_replace('?','%s',$sql);
            $sql = sprintf($sql,...$bindings);
//            $sql = vsprintf($sql,$bindings); 方法二
//            dd($sql);
            Log::info('sql log',['sql'=>$sql,'time'=>$time]);
        });
    }
}

注册事件

EventServiceProvider.php

 protected $listen = [
        Registered::class => [
            SendEmailVerificationNotification::class,
        ],
        QueryExecuted::class =>[
          DbSqlListener::class  //注册事件监听sql日志
        ],

      
    ];

查看日志目录