/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 vote223 views1 answer
Laravel Validation check array size min and max
PHP Laravel
5 votes192 views2 answers
Laravel collection chunk
PHP Laravel
2 votes225 views2 answers
Check if date between two dates laravel eloquent
PHP Laravel
1 vote220 views1 answer
How to catch query exception in laravel 8
PHP Laravel
1 vote206 views2 answers
Laravel get data from request
PHP Laravel
3 votes225 views1 answer
How to named route resource laravel
PHP Laravel
1 vote213 views1 answer
AUTO_INCREMENT in laravel
PHP Laravel
0 vote186 views1 answer
Mysqldump is not recognized as an internal or external command laravel
PHP Laravel
7 votes208 views1 answer
Laravel eloquent date range
PHP Laravel
1 vote196 views1 answer
Npm watch laravel
PHP Laravel