/PHP/Laravel/Laravel eloquent debug query

Laravel eloquent debug query

DB::enableQueryLog(); // Enable query log

// Your Eloquent query executed by using get()

dd(DB::getQueryLog()); // Show results of log

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 vote226 views1 answer
Laravel multiple orderby
PHP Laravel
0 vote198 views4 answers
Installing bootstrap on laravel8
PHP Laravel
1 vote163 views1 answer
Date format in laravel month name day name
PHP Laravel
0 vote197 views1 answer
Check Data Load More Laravel Livewire
PHP Laravel
24 votes162 views6 answers
Validation error message in laravel
PHP Laravel
0 vote176 views2 answers
Laravel collection sort by date
PHP Laravel
0 vote233 views1 answer
Count number of rows laravel controller
PHP Laravel
6 votes174 views4 answers
Laravel force delete
PHP Laravel
1 vote210 views1 answer
Laravel artisan progress bar
PHP Laravel
2 votes210 views1 answer
Create laravel project old version
PHP Laravel