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 vote160 views2 answers
Laravel cronjob
PHP Laravel
0 vote139 views2 answers
Php catch fatal error
PHP
4 votes135 views1 answer
How to iterate through php array
PHP
2 votes167 views1 answer
Foreign key constraint is incorrectly formed laravel
PHP Laravel
-1 vote129 views1 answer
Laravel seo
PHP
-2 votes150 views6 answers
Convert an Array to a String in PHP
PHP
0 vote133 views1 answer
Php hide credit card middle numbers
PHP
0 vote170 views1 answer
Lazy loading in laravel
PHP
0 vote166 views2 answers
Mixed Content heroku laravel
PHP Laravel
0 vote133 views1 answer
Enque scripts from plugin
PHP