/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 vote334 views1 answer
How to select specific id in laravel using isset
PHP Laravel
0 vote378 views1 answer
Send emails with runtime configurations in laravelk
PHP Laravel
0 vote323 views1 answer
Adding field to array on condition laravel
PHP Laravel
3 votes341 views2 answers
How to use required_with in laravel to array element
PHP Laravel
6 votes333 views3 answers
Laravel ide helper
PHP Laravel
0 vote369 views1 answer
How To Clear Laravel.Log In Laravel?
PHP Laravel
0 vote308 views1 answer
Laravel where search like with space
PHP Laravel
0 vote334 views2 answers
Laravel form put method
PHP Laravel
53 votes418 views6 answers
Laravel run seed
PHP Laravel
4 votes340 views2 answers
How to rename a table element in laravel
PHP Laravel