Skip to content

Instantly share code, notes, and snippets.

@pedroufv

pedroufv/logger sql to laravel

Created November 30, 2018 19:45
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save pedroufv/42047060a9f7252a6afc905a65a35dd8 to your computer and use it in GitHub Desktop.
Save pedroufv/42047060a9f7252a6afc905a65a35dd8 to your computer and use it in GitHub Desktop.
Download ZIP
show all sql add this code in boot method of appServiceProvider
Raw
logger sql to laravel
DB::listen(function(QueryExecuted $query){
Logger(
vsprintf(str_replace('?', '%s', $query->sql), collect($query->bindings)->map(function($binding){
return is_numeric($binding) ? $binding : "'{$binding}'";
})->toArray())
);
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment