/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

17 votes309 views5 answers
Wordpress debug mode
PHP
1 vote306 views1 answer
Php array merge skip diplicate
PHP
1 vote285 views1 answer
Php return loading message
PHP
0 vote328 views1 answer
How to pass write post method in lumen
PHP
1 vote348 views5 answers
Laravel jobs tutorial
PHP Laravel
18 votes328 views6 answers
Integer to string php
PHP
1 vote302 views1 answer
How to store an image in laravel directly from url
PHP
0 vote305 views1 answer
How to fix Undefined variable: product (View: C:\xampp\htdocs\ecommerce\resources\views\livewire\shop-component.blade.php)
PHP
0 vote315 views1 answer
How to create module in laravel
PHP
12 votes301 views3 answers
How to log object laravel logger
PHP