If you need to debug your last mysql query in laravel 5.5 then you can do it simply by following example. We know laravel provide their own query builder So sometime we write big query or something big logic on laravel query builder. But it's give us error and you didn't get it properly then you need to run manually sql query to your phpmyadmin.
So here i will give you many example to get your last query in laravel 5.5, So let's simple see bellow example how it works.
Debug 1:
$users = DB::table("users")->toSql();
dd($query);
Debug 2:
DB::enableQueryLog();
$user = DB::table("users")->get();
$query = DB::getQueryLog();
dd($query);
Debug 3:
DB::enableQueryLog();
$user = DB::table("users")->get();
$query = DB::getQueryLog();
$query = end($query);
dd($query);
I hope you found your best solution....
Do you like below Tutorials ?
- PHP Laravel 5.5 - import export data into excel and csv using maatwebsite
- Laravel 7.x and 6.x create custom facade example from scratch
- Node JS - Get Real time online users counter using socket io example
- PHP Laravel 7.x and 6.x - Bootstrap Admin Theme Integration example from scratch
- MySQL Query - How to select records of today to next Sunday ?
- Laravel 7.x and 6.x - username custom validation example
- Laravel 5.5 - Import Extract zip file using chumper/zipper package
- PHP Laravel Set Custom Validation Error Messages Example