/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 vote174 views2 answers
Php multiplei str
PHP
0 vote183 views1 answer
Filter array in php with passing extra params
PHP
18 votes167 views1 answer
Laravel migation error
PHP
0 vote193 views1 answer
Update First and Last Day of Previous Month with Carbon
PHP
0 vote206 views1 answer
Igaster\Laravel Theme\Exceptions\theme Already Exists
PHP Laravel
43 votes180 views2 answers
Get array length using php
PHP
0 vote212 views1 answer
Send notification php to PC
PHP
1 vote178 views1 answer
Must be an instance of Illuminate\\Http\\Request
PHP
0 vote179 views1 answer
Laravel eloquent relationships count
PHP
0 vote206 views1 answer
Like %% inside the string php
PHP