Laravel 4 – logging SQL queries

by

Here is what I am currently using for logging of sql queries. You should be able to drop this into your main routes file then add ‘log’ => true into your database config. 

if (Config::get('database.log', false))
{           
    Event::listen('illuminate.query', function($query, $bindings, $time, $name)
    {
        $data = compact('bindings', 'time', 'name');

        // Format binding data for sql insertion
        foreach ($bindings as $i => $binding)
        {   
            if ($binding instanceof \DateTime)
            {   
                $bindings[$i] = $binding->format('\'Y-m-d H:i:s\'');
            }
            else if (is_string($binding))
            {   
                $bindings[$i] = "'$binding'";
            }   
        }       

        // Insert bindings into query
        $query = str_replace(array('%', '?'), array('%%', '%s'), $query);
        $query = vsprintf($query, $bindings); 

        Log::info($query, $data);
    });
}

Thanks to Jeemusu answer for the bit about inserting the bindings into the prepared statement.

More Related Contents:

  1. Laravel 5.1, Return response to user, then excute some code [closed]
  2. Laravel – only a zero is saved to the database
  3. Post request in Laravel – Error – 419 Sorry, your session/ 419 your page has expired
  4. How Can I Remove “public/index.php” in the URL Generated Laravel?
  5. How to pass data to all views in Laravel 5?
  6. Laravel Check If Related Model Exists
  7. Laravel: PDOException: could not find driver
  8. Composer error: “PHP extension fileinfo is missing from your system”
  9. No Application Encryption Key Has Been Specified
  10. Laravel pagination pretty URL
  11. Laravel OrderBy relationship count
  12. How to change / Custom password field name for Laravel 4 and Laravel 5 user authentication [duplicate]
  13. Laravel: Using try…catch with DB::transaction()
  14. SQLSTATE[HY000] [2002] A connection attempt failed.. – When attempting to connect from Local to remote server
  15. Guzzle: handle 400 bad request
  16. Laravel mail: pass string instead of view
  17. Laravel – Database, Table and Column Naming Conventions?
  18. Prevent Browser’s Back Button Login After Logout in Laravel 5
  19. Call laravel controller via command line
  20. How to Merge Two Eloquent Collections?
  21. How to define a Laravel route with a parameter that contains a slash character
  22. Laravel – How to get current user in AppServiceProvider
  23. Laravel and view caching in development — can’t see changes right away
  24. The requested URL /ProjectName/users was not found on this server. Laravel
  25. Laravel / Intervention Image Class – class not found
  26. What’s the best way to localise a date on Laravel?
  27. Unresolvable dependency resolving [Parameter #0 [ $name ]]
  28. Optional parameter in the middle of a route
  29. Laravel /broadcasting/auth Always Fails With 403 Error
  30. Symfony\Component\HttpKernel\Exception\NotFoundHttpException Laravel

Leave a Comment