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 vote341 views1 answer
Laravel latest
PHP Laravel
6 votes405 views2 answers
Laravel debugbar disable in production
PHP Laravel
0 vote359 views1 answer
Laravel create pivot migration
PHP Laravel
0 vote370 views1 answer
Laravel collection nth method
PHP Laravel
4 votes354 views1 answer
Use str laravel
PHP Laravel
0 vote370 views1 answer
Laravel count data wise
PHP Laravel
1 vote337 views2 answers
{{count laravel
PHP Laravel
13 votes368 views6 answers
Laravel count
PHP Laravel
7 votes368 views3 answers
Laravel random query
PHP Laravel
1 vote392 views4 answers
Laravel queue timeout
PHP Laravel