/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

18 votes209 views1 answer
Laravel migation error
PHP Laravel
0 vote260 views2 answers
Send html from datatable in laravel
PHP Laravel
0 vote161 views1 answer
How convert the string to int in laravel function event
PHP Laravel
0 vote220 views1 answer
How to read laravel query string with dash
PHP Laravel
13 votes281 views6 answers
Find auth laravel
PHP Laravel
0 vote214 views2 answers
How change default value for enum colun in laravel
PHP Laravel
0 vote205 views1 answer
Laravel auth without vue or bootstrap
PHP Laravel
36 votes204 views6 answers
Laravel 8 foreign key migration
PHP Laravel
1 vote211 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
2 votes228 views4 answers
Laravel print query with parameters
PHP Laravel