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

61 votes296 views6 answers
Cache clear in laravel
PHP Laravel
-2 votes170 views1 answer
Errno: 150 foreign key constraint is incorrectly formed laravel 8
PHP Laravel
1 vote245 views2 answers
Get current month laravel
PHP Laravel
1 vote137 views1 answer
Laravel insert or ignore
PHP Laravel
9 votes155 views4 answers
Laravel route pattern
PHP Laravel
1 vote143 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
51 votes289 views6 answers
Create model with controller laravel
PHP Laravel
0 vote134 views2 answers
Maatwebsite/excel package 5.2 laravel
PHP Laravel
18 votes142 views6 answers
Laravel unique validation
PHP Laravel
0 vote140 views1 answer
Les étape d'integration du templates adminlte de Laravel pour application
PHP Laravel