/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 vote349 views1 answer
Automatic Subdomain with PHP
PHP
5 votes333 views1 answer
Auto generate password in php
PHP
2 votes343 views2 answers
Php delete directory
PHP
2 votes393 views1 answer
Laravel model truncate
PHP Laravel
0 vote280 views1 answer
Fatal error: cannot redeclare
PHP
0 vote360 views1 answer
Don't have xdebgu ini file
PHP
0 vote359 views1 answer
Php if in database field exists, if exists update, if not create
PHP
0 vote322 views1 answer
Php get property with ~
PHP
0 vote377 views1 answer
Remove public or index file from url in laravel
PHP Laravel
1 vote356 views2 answers
Append variable to string php
PHP