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

5 votes140 views6 answers
Laravel sort collection
PHP Laravel
0 vote135 views1 answer
Phpunit show progress during test
PHP
0 vote128 views1 answer
IP Authorization php code
PHP
0 vote141 views2 answers
Composer create project laravel with version
PHP Laravel
4 votes131 views2 answers
Ubuntu laravel storage permission
PHP
6 votes129 views2 answers
Dd laravel query
PHP
0 vote129 views1 answer
Laravel flutter save image in data
PHP Laravel
1 vote174 views2 answers
Laravel maximum execution time of 30 seconds exceeded
PHP
0 vote116 views1 answer
Digitalocean php as text
PHP
0 vote158 views2 answers
How to use flash message in laravel
PHP Laravel