Skip to content

Instantly share code, notes, and snippets.

@jaggy
Created August 3, 2016 03:40
Show Gist options
  • Save jaggy/107e9dc4f3d14973f8b59d1adaef9431 to your computer and use it in GitHub Desktop.
Save jaggy/107e9dc4f3d14973f8b59d1adaef9431 to your computer and use it in GitHub Desktop.
<?php
$storage = getcwd() . '/logs/sql.log';
$logger = new \Monolog\Logger('sql');
$logger->pushHandler(new \Monolog\Handler\StreamHandler($storage), \Monolog\Logger::WARNING);
$patters = $placeholders = [];
$query = $this->toSql();
$bindings = $this->getBindings();
preg_match_all('/\?/', $query, $placeholders, PREG_SET_ORDER);
$patterns = array_pad([], count($placeholders), '/\?/');
$query = preg_replace($patterns, $bindings, $query, $limit = 1);
$message = "\033[33m" . $query . "\033[0m";
$logger->warning($message);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment