/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

1 vote390 views1 answer
Mysqli_query insert in laravel
PHP Laravel
1 vote381 views1 answer
Laravel end date greater than start date validation
PHP Laravel
1 vote389 views1 answer
Parametre grouping laravel quert
PHP Laravel
0 vote434 views1 answer
Laravel easy form
PHP Laravel
0 vote343 views1 answer
Pdf watermark dengan laravel
PHP Laravel
1 vote352 views1 answer
Laravel where equal
PHP Laravel
14 votes374 views2 answers
Laravel change value to intger
PHP Laravel
0 vote308 views1 answer
Php artisan queue start
PHP Laravel
13 votes323 views6 answers
Laravel delete
PHP Laravel
0 vote331 views1 answer
Laravel check if relationship has data
PHP Laravel