Jump to content

To logg all sql-statements with error


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 post
Share on other sites
This thread is more than a year old.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • 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.