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

8 votes321 views4 answers
Codeigniter 4 redirect to home
PHP
33 votes403 views6 answers
Laravel carbon
PHP Laravel
0 vote280 views1 answer
How to use db more than 1 codeigiter 3
PHP
4 votes308 views2 answers
Php pdo last insert id
PHP
0 vote361 views1 answer
Laravel find model inside the same model
PHP Laravel
14 votes331 views2 answers
Get type of variable php
PHP
0 vote297 views1 answer
Add-basic-controller-imports
PHP
0 vote350 views2 answers
Wp colibri delete footer
PHP
0 vote334 views1 answer
Les étape d'integration du templates adminlte de Laravel pour application
PHP
0 vote327 views1 answer
Laravel collection pipe
PHP