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 vote193 views1 answer
Laravel search data relationship
PHP Laravel
0 vote108 views2 answers
Php artisan app:name in laravel 6
PHP Laravel
-1 vote107 views4 answers
Include blade file in laravel
PHP Laravel
12 votes131 views5 answers
Laravel transactions
PHP Laravel
9 votes132 views3 answers
Laravel enum migration example
PHP Laravel
2 votes125 views3 answers
Laravel model particular column
PHP Laravel
0 vote154 views1 answer
Comparison of two tables in laravel using model
PHP Laravel
53 votes248 views6 answers
Laravel where in
PHP Laravel
0 vote108 views2 answers
Count with condition laravel
PHP Laravel
0 vote118 views1 answer
Laravel post request search query
PHP Laravel