Laravel print builder

// query builder
$query = DB::table('table_name')->where('id', 1);
// binding replaced
$rawQuery = str_replace_array('?', $query->getBindings(), $query->toSql());
// for laravel 5.8^
$rawQuery = Str::replaceArray('?', $query->getBindings(), $query->toSql());
 
dd($rawSql); // "select * from `table_name` where `id` = 1";

Source: stackoverflow.com

Similar codes

0 vote217 views1 answer
Laravel replace white space with dash
PHP Laravel
0 vote212 views1 answer
Integrity constraint violation laravel socialite google login
PHP Laravel
0 vote210 views1 answer
Add auth middleware to route laravel
PHP Laravel
0 vote233 views1 answer
Laravel stack script
PHP Laravel
0 vote222 views1 answer
How to create compomemt in laravel livewire
PHP Laravel
0 vote248 views1 answer
Flash message laravel for incorrect password
PHP Laravel
23 votes218 views6 answers
Laravel 6 auth
PHP Laravel
12 votes247 views5 answers
Laravel transactions
PHP Laravel
1 vote213 views1 answer
Autoload file laravel
PHP Laravel
0 vote244 views1 answer
How run all seeder at once in laravel
PHP Laravel