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

1 vote179 views1 answer
Where date laravel
PHP Laravel
2 votes158 views2 answers
Get all data eloquent laravel
PHP Laravel
1 vote221 views3 answers
Laravel validate change password
PHP Laravel
33 votes126 views8 answers
Laravel faker
PHP Laravel
2 votes137 views1 answer
How to use model method in controller in laravel
PHP Laravel
0 vote125 views1 answer
Laravel model refresh
PHP Laravel
1 vote170 views1 answer
Laravel active route check
PHP Laravel
9 votes158 views6 answers
Laravel ui auth
PHP Laravel
0 vote177 views1 answer
Display data from two dimensional array in vew laravel
PHP Laravel
0 vote175 views1 answer
Push to aws instance ssh without using laravel
PHP Laravel