Combine binding values into a raw SQL query in Laravel. Debugging in Laravel.

binder.php

<?php

//example:
$query = Foo::where('id', '=', 1)->where('name', '=', 'bar');

//would produce the following raw query: 
//select * from foo where id = ? and name = ?;

dd(vsprintf(str_replace('?', '%s', $query->toSql()), collect($query->getBindings())->map(function($binding){
    return is_numeric($binding) ? $binding : "'{$binding}'";
})->toArray()));

//result: 
//select * from foo where id = 1 and name = 'bar';

Thank @thonyx, it's saved my time a lot!

Thanks! It also worked for me!

works for me too, thanks bro!!

Thanks a lot! Here's a version without using the Laravel Collection:

return vsprintf(str_replace('?', '%s', $query->toSql()), array_map(function($binding) {
    return is_numeric($binding) ? $binding : "'{$binding}'";
}, $query->getBindings()));