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

16 votes215 views6 answers
Laravel redirect back
PHP Laravel
8 votes264 views5 answers
Laravel route is current route
PHP Laravel
0 vote213 views1 answer
Select max id laravel
PHP Laravel
0 vote202 views1 answer
Create if not exist laravel
PHP Laravel
0 vote251 views3 answers
Permissions for laravel deployment
PHP Laravel
0 vote197 views1 answer
How to use union and intersection in laravel query
PHP Laravel
3 votes205 views2 answers
Laravel find by field
PHP Laravel
0 vote262 views1 answer
Laravel db query log string replacements
PHP Laravel
0 vote196 views1 answer
Country code validation in laravel
PHP Laravel
1 vote214 views2 answers
Page expire in laravel
PHP Laravel