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

18 votes145 views5 answers
If statement in laravel blade
PHP Laravel
7 votes148 views6 answers
Laravel validation unique email
PHP Laravel
2 votes151 views2 answers
Laravel 5.8 cors
PHP Laravel
23 votes169 views6 answers
Laravel 8 route
PHP Laravel
7 votes153 views4 answers
Laravel blade uppercase
PHP Laravel
0 vote154 views1 answer
Check if any field update laravel
PHP Laravel
7 votes146 views2 answers
How to start composer in laravel project on localhost
PHP Laravel
3 votes154 views1 answer
Run laravel cron job on cpanel
PHP Laravel
1 vote158 views1 answer
Laravel websockets onclose
PHP Laravel
2 votes157 views1 answer
Return back in blade laravel
PHP Laravel