Jump to content

To logg all sql-statements with error


mstdmstdd

Recommended Posts

Hello,

 

  In laravel 5.4 adding lines in app/Providers/AppServiceProvider.php file:
 

public function boot()
{

if ($this->app->environment('local')) {
\DB::listen(function($query) {
$dbLog = new \Monolog\Logger('Query');
$dbLog->pushHandler(new \Monolog\Handler\RotatingFileHandler(storage_path('logs/Query.log'), 5, \Monolog\Logger::DEBUG));
$dbLog->info($query->sql, ['Bindings' => $query->bindings, 'Time' => $query->time]);
});
}
...

I made log of all successfull sql in file.

If there is a way to catch and write to this file all sql with errors and error description?

I know about laravel.log, but I would prefer to write all sql-statements successfull and with error.

Thanks!

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.