/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

-1 vote138 views3 answers
Fore install debian 10 php 7.3
PHP
1 vote122 views1 answer
Multiple submit button in php
PHP
0 vote130 views3 answers
Transfer file using file_get_content
PHP
12 votes126 views5 answers
Php filter array
PHP
2 votes223 views2 answers
Tmp cakephp name
PHP CakePHP
3 votes136 views2 answers
Laravel db exists
PHP
0 vote133 views1 answer
Check date php
PHP
1 vote160 views2 answers
String to carbon
PHP
0 vote153 views2 answers
Pluck only category name and id from model in laravel
PHP Laravel
0 vote127 views1 answer
Laravel ID Generator
PHP