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

-1 vote250 views1 answer
When to create a service in laravel
PHP Laravel
5 votes241 views2 answers
Created_at default value laravel
PHP Laravel
1 vote233 views2 answers
How set field after another field in migration in laravel
PHP Laravel
0 vote236 views3 answers
Laravel validation alphanumeric with spaces
PHP Laravel
0 vote214 views1 answer
Encryption key has not encrypted laravel
PHP Laravel
1 vote221 views2 answers
How add field to table by another migration in laravel
PHP Laravel
0 vote280 views1 answer
Laravel A row must be an array or a TableSeparator instance.
PHP Laravel
10 votes172 views2 answers
Laravel migration default value not working
PHP Laravel
1 vote239 views2 answers
Laravel required_with
PHP Laravel
0 vote241 views1 answer
Use backpack and laravel-permission to edit user roles
PHP Laravel