/PHP/Laravel/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 vote192 views1 answer
Show user only those products which he hasn't buyed laravel eloquent
PHP Laravel
0 vote194 views1 answer
Mixed content laravel form target
PHP Laravel
2 votes180 views1 answer
Laravel model string primary key
PHP Laravel
0 vote194 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
0 vote184 views1 answer
Form validation nullable laravel
PHP Laravel
7 votes191 views4 answers
Laravel route namespace and prefix
PHP Laravel
1 vote176 views1 answer
Cart laravel
PHP Laravel
0 vote193 views1 answer
Laravel whereHas undefined variable
PHP Laravel
7 votes178 views6 answers
Set session in laravel
PHP Laravel
0 vote207 views1 answer
Calculate average in eager loading laravel
PHP Laravel