/PHP/Laravel/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 vote193 views2 answers
Check empty laravel blade
PHP Laravel
2 votes181 views2 answers
“In fortify.php line 134:Class 'Laravel\Fortify\Features' not found ” Code Answer’s
PHP Laravel
0 vote194 views1 answer
Laravel Your requirements could not be resolved to an installable set of packages.
PHP Laravel
0 vote183 views1 answer
Laravel curl request
PHP Laravel
-1 vote173 views2 answers
Laravel 5.6 orderby
PHP Laravel
1 vote296 views2 answers
Laravel print request data
PHP Laravel
0 vote206 views1 answer
Create auto image path folder in laravel 8
PHP Laravel
0 vote189 views1 answer
Laravel eloquent return array where
PHP Laravel
0 vote184 views1 answer
Access to this resource on the server is denied laravel
PHP Laravel
3 votes187 views1 answer
How validate array in laravel in request
PHP Laravel