/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 vote309 views2 answers
Customize laravel pagination links
PHP Laravel
0 vote322 views1 answer
Laravel Facades\DB update
PHP Laravel
7 votes364 views4 answers
Many to many relationship laravel
PHP Laravel
0 vote321 views1 answer
Laravel migration folder
PHP Laravel
0 vote320 views1 answer
Laravel 6 use username on url
PHP Laravel
8 votes284 views1 answer
Laravel storage not found
PHP Laravel
1 vote365 views1 answer
Display summernonte data with string limit laravel
PHP Laravel
0 vote386 views2 answers
Declare variable in view for loop laravel
PHP Laravel
0 vote370 views1 answer
How to create module in laravel
PHP Laravel
5 votes283 views3 answers
Laravel destroy session
PHP Laravel