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 vote151 views3 answers
Laravel required if
PHP Laravel
1 vote139 views1 answer
Laravel 6 tymon/jwt-auth
PHP Laravel
22 votes131 views2 answers
Where status is null sql in laravel
PHP Laravel
0 vote135 views1 answer
Pusher-php-server laravel
PHP Laravel
1 vote189 views4 answers
Laravel flash message
PHP Laravel
1 vote139 views1 answer
Persian error laravel
PHP Laravel
0 vote139 views1 answer
Laravel faker value or null
PHP Laravel
0 vote135 views1 answer
Laravel collection median
PHP Laravel
6 votes137 views2 answers
Laravel route regex except
PHP Laravel
8 votes142 views3 answers
Check for an existing user laravel eloquent
PHP Laravel