Print query in laravel
Created at 13-Mar-2021 ,
By samar
Print query in laravel
Good day, guys. In this post, we’ll look at how to solve the "Print query in laravel" programming puzzle.
-
--PATH app\Http\Controllers\<YourController.php>
$users = User::where('id', '=', 1)->dd(); // or $users = DB::table('users')->where('id', '=', 1)->dd();
DD method is used to print query in laravel. DD stands for the die and dump which is a built-in function used in laravel. DD method prints query information and then stops executing the script. -
--PATH app\Http\Controllers\<YourController.php>
$users = User::where('id', '=', 1)->toSql(); dd($users);
toSql() method gets the raw sql query. This method is good for quickly seeing the SQL query but It doesn't include the query bindings. You have to use the dd() method after toSql() to print the query in your controller file. -
--PATH app\Http\Controllers\<YourController.php>
$users = User::where('id', '=', 1)->dump(); // or $users = DB::table('users')->where('id', '=', 1)->dump();
Dump() method will print the query information but it does not stop the execution of the script. -
--PATH app\Http\Controllers\<YourController.php>
DB::enableQueryLog(); // Enable query log $employees = Employee::get(); $employeeDetails = EmployeeDetail::get(); dd(DB::getQueryLog()); // Show results of log
DB::enableQueryLog(); and dd(DB::getQueryLog()); are the methods which are used to print queries in laravel. You can enable query log using DB::enableQueryLog(); and after that you can get all queries logs using DB::getQueryLog() method. It will display all queries logs which are used after DB::enableQueryLog(); and before dd(DB::getQueryLog()) method. It also displays query bindings. You have to change the model name as per your requirements. -
--PATH app\Http\Controllers\<YourController.php>
DB::connection()->enableQueryLog(); $employeeDetail = EmployeeDetail::all(); echo '<pre>'; print_r(DB::getQueryLog()); die;
If you like what you are reading, please consider buying us a coffee ( or 2 ) as a token of appreciation.
Don't forget to share this article! Help us spread the word by clicking the share button below.
We appreciate your support and are committed to providing you valuable and informative content.
We are thankful for your never ending support.
Random Code Snippet Queries: Laravel
- Permanently delete a record in laravel
- How to return a column with different name in Laravel
- How to insert multiple rows in mysql using loop in laravel?
- Syntax error or access violation: 1072 Key column 'role_id' doesn't exist in table (SQL: alter table `users` add constraint `users_role_id_foreign` foreign key (`role_id`) references `roles` (`id`))
- Class 'App\Rules\Hash' not found in Laravel
- How to get laravel errors folder in views directory in laravel
- How to start websocket server in laravel
- How to get CSRF token in laravel controller
- How to run a specific seeder class in laravel
- How to get all route list
- Laravel 9 pagination with search filter
- How to check find method executed successfully in laravel
- Cast Array to an Object in Controller and then pass to view in laravel
- Laravel save object to database
- Method Illuminate\Database\Eloquent\Collection::appends does not exist
- Laravel delete all rows older than 30 days
- Automatically remove records using Prunable trait in Laravel
- How to avoid duplicate entries in pivot table in Laravel
- If no route matched route::fallback in laravel
- External link not working in laravel blade
- Non-static method App\Http\Helper::myFunction() should not be called statically
- How to pass query string with pagination in laravel
- Pass variable from blade to controller Laravel
- The POST method is not supported for this route. Supported methods: PUT.
- Pass value from controller to model in laravel