/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 vote336 views1 answer
WooCommerce Catalog Mode snippets
PHP
-1 vote326 views1 answer
Email php using html
PHP
0 vote285 views1 answer
Wordpress register_post_type capability gutenberg
PHP
0 vote462 views1 answer
Redirect wordpress core login
PHP Wordpress
1 vote324 views1 answer
Supervisor configuration for laravel queue
PHP
1 vote403 views2 answers
PHP-Curl
PHP
-1 vote385 views1 answer
Laravel Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on
PHP Laravel
1 vote317 views2 answers
How to create a logout button in wordpress
PHP
0 vote395 views1 answer
Required_unless laravel
PHP Laravel
6 votes350 views3 answers
Laravel ecommerce
PHP