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

15 votes188 views4 answers
Change existing migration laravel
PHP Laravel
2 votes201 views2 answers
Get users other than specific role laravel role spatie
PHP Laravel
0 vote211 views1 answer
Laravel use variable inside callback function
PHP Laravel
6 votes188 views1 answer
Insall laravel
PHP Laravel
1 vote191 views1 answer
Where year month laravel
PHP Laravel
0 vote198 views4 answers
How to host laravel project on local server
PHP Laravel
12 votes188 views2 answers
Laravel update from query
PHP Laravel
0 vote189 views1 answer
Laravel maintenance mode custom class
PHP Laravel
0 vote193 views1 answer
Laravel collection shuffle
PHP Laravel
0 vote199 views1 answer
Jwt auth laravel auth without password field
PHP Laravel