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

2 votes254 views1 answer
Laravel commands to refresh env file
PHP Laravel
4 votes236 views1 answer
Use str laravel
PHP Laravel
22 votes284 views2 answers
Where status is null sql in laravel
PHP Laravel
0 vote225 views1 answer
Laravel php 8 ububtu
PHP
0 vote234 views1 answer
Never return type - PHP 8.1
PHP
2 votes294 views2 answers
Get_boundary_post wordpress
PHP Wordpress
1 vote239 views1 answer
Is curl faster than file_get_contents php
PHP
0 vote245 views1 answer
Show sender name laravel
PHP
1 vote243 views4 answers
In_array validation laravel
PHP Laravel
0 vote233 views1 answer
General error: 1390 Prepared statement contains too many placeholders
PHP