Skip to content

Instantly share code, notes, and snippets.

@syossan27
Created January 17, 2015 13:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save syossan27/59ffe19272a78963d623 to your computer and use it in GitHub Desktop.
Save syossan27/59ffe19272a78963d623 to your computer and use it in GitHub Desktop.
LogSql::useFiles(storage_path().'/logs/laravel_sql.log');
Event::listen('illuminate.query', function($query, $bindings, $time, $name)
{
$data = compact('bindings', 'time', 'name');
foreach ($bindings as $i => $binding)
{
if($binding instanceof \DateTime)
{
$bindings[$i] = $binding->format('\'Y-m-d H:i:s\'');
}elseif(is_string($binding)){
$bindings[$i] = "'$binding'";
}
}
$query = str_replace(array('%', '?'), array('%%', '%s'), $query);
$query = vsprintf($query, $bindings);
LogSql::info($query, $data);
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment