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

10 votes293 views4 answers
Laravel create
PHP Laravel
9 votes267 views3 answers
Laravel enum migration
PHP Laravel
49 votes325 views6 answers
Laravel add column to existing table
PHP Laravel
4 votes274 views3 answers
Laravel use config
PHP Laravel
1 vote315 views2 answers
If null blade laravel
PHP Laravel
0 vote280 views2 answers
DB::raw update query in laravel
PHP Laravel
0 vote266 views2 answers
Laravel santum
PHP Laravel
1 vote269 views1 answer
Laravel export make comman
PHP Laravel
2 votes247 views2 answers
Laravel create migration file
PHP Laravel
7 votes273 views2 answers
How to start composer in laravel project on localhost
PHP Laravel