/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 vote396 views2 answers
Re migrate laravel
PHP Laravel
0 vote378 views1 answer
Trying to access variable outside laravel collection
PHP Laravel
22 votes354 views6 answers
Where like in laravel
PHP Laravel
0 vote445 views1 answer
How to take last entry in database in laravel Method Three
PHP Laravel
11 votes392 views3 answers
How to make validate error when password doesnt match with password confirm laravel
PHP Laravel
0 vote385 views1 answer
Laravel scheduler on shared hosting
PHP Laravel
0 vote384 views1 answer
How to install or setup sanctum for laravel api authentication
PHP Laravel
9 votes374 views3 answers
Laravel image validation
PHP Laravel
6 votes387 views6 answers
Laravel get current route url
PHP Laravel
0 vote333 views1 answer
RequestCriteria laravel
PHP Laravel