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

0 vote223 views1 answer
Php reindex array after unset
PHP
0 vote149 views1 answer
Syntax error, unexpected 'elseif' (T_ELSEIF)
PHP
2 votes160 views1 answer
Your composer dependencies require a php version ">= 7.3.0"
PHP
0 vote172 views1 answer
Laravel deleted controller still cached
PHP
0 vote287 views1 answer
Yii 1 clear cache
PHP Yii
0 vote162 views2 answers
Php qrscanner webcam
PHP
0 vote180 views1 answer
Laravel override eloquent all function
PHP Laravel
25 votes180 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP
0 vote197 views1 answer
Add code in header
PHP
0 vote148 views1 answer
What is carriage return in php
PHP