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

9 votes146 views4 answers
Convert laravel hash password online
PHP Laravel
3 votes112 views2 answers
Could not open input file: composer.phar
PHP
15 votes130 views3 answers
Laravel setup auth
PHP Laravel
3 votes107 views2 answers
Laravel db exists
PHP
37 votes165 views2 answers
Php generate random alphanumeric string
PHP
-1 vote117 views1 answer
Laravel list of tables
PHP Laravel
0 vote129 views2 answers
Laravel allow all fillable
PHP Laravel
0 vote115 views1 answer
Laravel get all users except role spatie
PHP
6 votes100 views2 answers
How to set tinyint default 0 laravel migration
PHP
2 votes162 views1 answer
Laravel difference between current time and created time
PHP Laravel