Advertisement
quang4dev

Get Full SQL Query in Laravel

Jul 24th, 2015
324
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.40 KB | None | 0 0
  1. function logger() {
  2.     $queries = \Illuminate\Database\Capsule\Manager::getQueryLog();
  3.     $formattedQueries = [];
  4.     foreach( $queries as $query ) :
  5.         $prep = $query['query'];
  6.         foreach( $query['bindings'] as $binding ) :
  7.             $prep = preg_replace("#\?#", $binding, $prep, 1);
  8.         endforeach;
  9.         $formattedQueries[] = $prep;
  10.     endforeach;
  11.     return $formattedQueries;
  12. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement