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

100 votes385 views6 answers
Replace in php
PHP
37 votes392 views4 answers
Foreign key in laravel migration
PHP Laravel
0 vote328 views1 answer
Syntax error, unexpected 'elseif' (T_ELSEIF)
PHP
1 vote312 views1 answer
Unable to call component method. Public method [gotoPage] not found on component
PHP
1 vote322 views1 answer
Laravel 8 plural singular
PHP
0 vote304 views2 answers
Laravel collection first
PHP
1 vote335 views1 answer
Php preg match space or start of string
PHP
0 vote383 views1 answer
Wordpress check shortcode exists
PHP Wordpress
-1 vote418 views1 answer
Wordpress popular posts query
PHP Wordpress
0 vote320 views1 answer
Laravel session has message
PHP