/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

0 vote341 views1 answer
Laravel password require one letter and one number
PHP Laravel
1 vote312 views1 answer
Forelse in laravel
PHP Laravel
1 vote338 views1 answer
Unless blade laravel
PHP Laravel
0 vote377 views3 answers
Writing into the database with one click laravel
PHP Laravel
0 vote375 views1 answer
How to call function in blade laravel
PHP Laravel
0 vote359 views1 answer
Laravel create table with model command line
PHP Laravel
1 vote401 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
0 vote356 views1 answer
Laravel import xml to database
PHP Laravel
25 votes353 views6 answers
Laravel where
PHP Laravel
32 votes357 views1 answer
How to count the characters in laravel
PHP Laravel