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 vote341 views1 answer
Laravel looping checking if last record has reached
PHP Laravel
5 votes311 views1 answer
Push key value array php
PHP
7 votes348 views1 answer
Rollback laravel transaction
PHP
6 votes334 views1 answer
Php exit foreach
PHP
1 vote364 views1 answer
Integer nullable laravel
PHP Laravel
4 votes363 views2 answers
Laravel sum column values
PHP Laravel
0 vote323 views1 answer
Password required wp
PHP
2 votes344 views1 answer
Set session after login with laravel
PHP
16 votes319 views4 answers
Laravel auth helper function
PHP Laravel
0 vote351 views1 answer
Get wordpress id
PHP Wordpress