/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 vote199 views1 answer
Clear from faild_jobs laravel
PHP
2 votes261 views2 answers
How to check php version codeigniter 3
PHP CodeIgniter
9 votes207 views7 answers
How to get plugin directory path in wordpress
PHP
0 vote213 views2 answers
Curl post laravel
PHP Laravel
0 vote194 views1 answer
Laravel request file empty
PHP
0 vote182 views2 answers
New static laravel
PHP
1 vote185 views1 answer
Get user with role laravel
PHP
1 vote224 views1 answer
Laravel Validation check array size min and max
PHP
0 vote187 views1 answer
Wocommerce product image
PHP
0 vote268 views1 answer
Eloquent limit vs take
PHP