/PHP/Laravel get query in normal sql without bindings

Laravel get query in normal sql without bindings

/**
 * Combines SQL and its bindings
 *
 * @param \Eloquent $query
 * @return string
 */
public static function getEloquentSqlWithBindings($query)
{
    return vsprintf(str_replace('?', '%s', $query->toSql()), collect($query->getBindings())->map(function ($binding) {
        $binding = addslashes($binding);
        return is_numeric($binding) ? $binding : "'{$binding}'";
    })->toArray());
}

Source: stackoverflow.com

Similar codes

0 vote146 views1 answer
PHP (WordPress) - Increase Maximum Upload File Size
PHP Wordpress
0 vote118 views1 answer
Twig\Error\SyntaxError: Unknown "file_uri" function. Did you mean "file_url"?
PHP
0 vote191 views1 answer
Laravel job delay dispatch
PHP Laravel
0 vote124 views1 answer
Encryp with codeigniter 3
PHP
15 votes125 views3 answers
Laravel make model with migration 5.8
PHP
25 votes121 views2 answers
Clear cache without using composer in laravel 8
PHP
0 vote148 views1 answer
How to check if page is opened by bot
PHP
2 votes148 views1 answer
Laravel validate integer between
PHP Laravel
0 vote184 views1 answer
Laravel rule unique where
PHP Laravel
0 vote126 views1 answer
Switch php version ubuntu 20.04 site:stackoverflow.com
PHP