/PHP/Laravel/Laravel db query log string replacements

Laravel db query log string replacements

DB::enableQueryLog();

# <!-- YOUR QUERY HERE --->
User::all();

$query = collect(DB::getQueryLog())->map(function($query){
  return str_replace_array('?', $query['bindings'], $query['query']);
})->join("\n");

dd($query); // Outputs: select * from `users`

Similar codes

1 vote264 views2 answers
Get unique values in laravel
PHP Laravel
18 votes268 views1 answer
Schema::default string laravel
PHP Laravel
1 vote265 views1 answer
Laravel routing controller get and post method
PHP Laravel
14 votes250 views4 answers
Laravel transactions eloquent
PHP Laravel
0 vote252 views1 answer
Laravel replace white space with dash
PHP Laravel
2 votes271 views3 answers
How get file size in laravel
PHP Laravel
3 votes244 views3 answers
Php artisan make services
PHP Laravel
12 votes282 views2 answers
Laravel query with trashed
PHP Laravel
3 votes246 views1 answer
Sum multiple fields separately in laravel
PHP Laravel
1 vote264 views1 answer
Laravel model increase the value by one
PHP Laravel