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

3 votes164 views1 answer
Collection empty laravel
PHP Laravel
0 vote176 views1 answer
Hint extension in visual studio code for laravel
PHP Laravel
0 vote125 views1 answer
Laravel eloquent mass assignments
PHP Laravel
0 vote193 views1 answer
Laravel mix disable notifications
PHP Laravel
0 vote182 views1 answer
Laravel seed timestamps columns
PHP Laravel
0 vote183 views2 answers
Convert string to array laravel
PHP Laravel
21 votes177 views6 answers
Laravel route parameters
PHP Laravel
0 vote172 views1 answer
Setup cron on macos for laravel
PHP Laravel
2 votes197 views2 answers
How to show limited text in laravel on page
PHP Laravel
0 vote172 views1 answer
Laravel: get last id
PHP Laravel