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 vote366 views1 answer
Laravel log query for model (full)
PHP Laravel
1 vote356 views1 answer
Laravel storage check file exists
PHP Laravel
1 vote363 views2 answers
Fillable vs guarded laravel
PHP Laravel
0 vote386 views1 answer
User order by role spatie laravel
PHP Laravel
12 votes320 views6 answers
Laravel validation
PHP Laravel
1 vote358 views2 answers
How many users can a cron handle in laravel in single run
PHP Laravel
2 votes373 views1 answer
Laravel-ckeditor
PHP Laravel
3 votes377 views3 answers
Laravel clear table
PHP Laravel
5 votes329 views2 answers
Laravel collection chunk
PHP Laravel
0 vote383 views1 answer
Detect mobile device laravel
PHP Laravel