/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

2 votes293 views1 answer
Custom rule laravel validation
PHP Laravel
2 votes270 views2 answers
Empty table in laravel
PHP Laravel
0 vote257 views1 answer
Cloudinary laravel
PHP Laravel
0 vote298 views1 answer
Validate user password laravel8
PHP Laravel
1 vote304 views1 answer
Laravel end date greater than start date validation
PHP Laravel
0 vote285 views1 answer
Use multiple pagination in same page laravel
PHP Laravel
0 vote318 views1 answer
How get last item in foreach in laravel
PHP Laravel
0 vote270 views2 answers
Laravel get average from a column
PHP Laravel
1 vote303 views1 answer
Laravel not finding asset files in public directory
PHP Laravel
0 vote290 views1 answer
Laravel add model to one to many relationship
PHP Laravel