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

6 votes214 views1 answer
Laravel route param blade
PHP Laravel
2 votes199 views1 answer
Laravel clear everything
PHP Laravel
1 vote289 views1 answer
Laravel profile migration tool
PHP Laravel
0 vote215 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP Laravel
8 votes206 views1 answer
Laravel show routes artisan
PHP Laravel
1 vote215 views1 answer
Laravel get last get request
PHP Laravel
0 vote228 views1 answer
Check the existing image in s3 laravel
PHP Laravel
0 vote229 views1 answer
How to conditional values in old value or edit new value with validsation faild to redirect back in laravel
PHP Laravel
0 vote231 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP Laravel
0 vote203 views1 answer
How to create table for every user in laravel
PHP Laravel