/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

0 vote298 views1 answer
Pass array from controller laravel with compact
PHP Laravel
0 vote278 views2 answers
Laravel collection every
PHP Laravel
2 votes264 views1 answer
Path of app directory in controller laravel
PHP Laravel
0 vote246 views1 answer
Publish Spatie Laravel Permission
PHP Laravel
0 vote225 views1 answer
Field doesn't have default value laravel
PHP Laravel
2 votes218 views2 answers
Importing current year in laravel blade
PHP Laravel
7 votes302 views1 answer
Laravel if syntax
PHP Laravel
0 vote325 views1 answer
Laravel one session per user
PHP Laravel
3 votes312 views6 answers
Email verification laravel
PHP Laravel
1 vote239 views1 answer
'cross-env' is not recognized as an internal or external command, laravel
PHP Laravel