/PHP/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

3 votes260 views2 answers
How to rename a table element in laravel
PHP
0 vote285 views1 answer
Laravel routes return view in web.php
PHP Laravel
0 vote267 views2 answers
Use class in blade laravel
PHP
0 vote261 views1 answer
Codeigniter form validation datetime
PHP
0 vote264 views2 answers
Web scraping
PHP
1 vote261 views1 answer
Shorttime php
PHP
5 votes245 views1 answer
Php heredoc
PHP
0 vote259 views1 answer
Save image to custom meta box
PHP
0 vote281 views1 answer
Laravel in array blade
PHP
1 vote238 views2 answers
Insert data to table in wordpress 2
PHP