/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

5 votes98 views1 answer
Bootstrap blade pagination
PHP Laravel
2 votes121 views1 answer
Migrations required field laravel
PHP Laravel
4 votes105 views2 answers
Laravel blade errors all
PHP
18 votes110 views2 answers
Reload page in php
PHP
0 vote111 views1 answer
Php check if type is mysqli_result
PHP
0 vote139 views1 answer
Deactivate auto update wordpress plugins
PHP Wordpress
3 votes108 views3 answers
Class 'App\Http\Controllers\Auth' not found
PHP
4 votes120 views3 answers
Php array_slice
PHP
0 vote105 views1 answer
How to perform form inpot in laravel 8 and export database
PHP
2 votes112 views4 answers
Get first day of current month php
PHP