/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 vote144 views1 answer
Laravel eloquent save method return value
PHP Laravel
0 vote137 views2 answers
Laravel log could not be opened fix
PHP Laravel
2 votes171 views1 answer
Laravel how to test email testing
PHP Laravel
0 vote136 views1 answer
Laravel mail success or failure
PHP Laravel
0 vote139 views1 answer
Laravel array to string error
PHP Laravel
6 votes151 views2 answers
How to set tinyint default 0 laravel migration
PHP Laravel
31 votes136 views5 answers
How to make db seeder in laravel
PHP Laravel
10 votes156 views2 answers
Array to string conversion in laravel controller
PHP Laravel
0 vote151 views1 answer
Laravel firstorcreate with multiple parameters
PHP Laravel
4 votes143 views2 answers
Laravel eloquent sum column
PHP Laravel