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 vote127 views1 answer
Laravel bootstrap-auth setup
PHP Laravel
1 vote121 views1 answer
Laravel query select from table where id != to another table id
PHP Laravel
0 vote122 views3 answers
Laravel validation alphanumeric with spaces
PHP Laravel
0 vote130 views1 answer
How run all seeder at once in laravel
PHP Laravel
23 votes138 views6 answers
Laravel 8 route
PHP Laravel
0 vote128 views1 answer
Laravel collection flip
PHP Laravel
18 votes123 views1 answer
Laravel migation error
PHP Laravel
7 votes137 views3 answers
How to remove public from url in laravel 8
PHP Laravel
0 vote144 views1 answer
Pdf watermark dengan laravel
PHP Laravel
5 votes196 views2 answers
Laravel redirect with message to section
PHP Laravel