LaravelPackages.net
Acme Inc.
Toggle sidebar
loburets/laravel-query-printer

An easy way to print queries and query logs in Laravel

5
0
v0.1.2
About loburets/laravel-query-printer

loburets/laravel-query-printer is a Laravel package for an easy way to print queries and query logs in laravel. It currently has 0 GitHub stars and 5 downloads on Packagist (latest version v0.1.2). Install it with composer require loburets/laravel-query-printer. Discover more Laravel packages by loburets or browse all Laravel packages to compare alternatives.

Last updated

πŸ–¨οΈ Laravel Query Printer

An easy way to print Laravel queries

πŸ“Œ Example

// Enable query log \DB::enableQueryLog(); // Use whatever queries you want to debug: User::where('email', '[email protected]')->where('verified', true)->first(); User::where('id', '<', '5')->get(); // See what the queries were executed \QueryPrinter::printQueryLog();

πŸ”Ή Output without this package:

Without Package

πŸ”Ή Output with this package:

With Package

Now you can simply copy and execute the query without struggling with bindings πŸ™Œ


πŸš€ Installation

composer require loburets/laravel-query-printer

For Laravel < 5.5, add the alias in config/app.php:

'QueryPrinter' => Loburets\LaravelQueryPrinter\Facade::class,

πŸ› οΈ Usage

βœ… Printing a Query Builder instance

You can print a query before execution:

// Build your query, but don't call ->first(), ->get() etc. So it is an instance of the Query Builder here: $query = \Model::where()->join()->etc(); // Print the generated SQL \QueryPrinter::print($query);

βœ… Printing executed queries from query logs

You can also print queries after they have been executed:

// Enable the Query log: \DB::enableQueryLog(); // Do any actions which you want to be logged: $results = \Model::where()->join()->etc()->get(); // Print all the executed queries \QueryPrinter::printQueryLog();

Now debugging Laravel queries is easier than ever! 🎯

Comments