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 vote117 views2 answers
Laravel filesystem
PHP Laravel
5 votes161 views5 answers
Laravel file permissions
PHP Laravel
46 votes144 views6 answers
Add new column in existing table in laravel migration
PHP Laravel
8 votes139 views6 answers
Laravel new project
PHP Laravel
51 votes174 views6 answers
Left join laravel
PHP Laravel
1 vote131 views1 answer
How change the languge of fie manager in laravel
PHP Laravel
49 votes179 views6 answers
Join in laravel
PHP Laravel
1 vote141 views1 answer
Limiting requests to controllers in laravel
PHP Laravel
0 vote152 views1 answer
Laravel collection reject
PHP Laravel
2 votes136 views1 answer
Laravel model string primary key
PHP Laravel