/PHP/Laravel/Laravel print query with parameters

Laravel print query with parameters

Laravel get query output

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

// Your Eloquent query executed by using get()

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

Source: stackoverflow.com

Laravel print query with parameters

$query = str_replace(array('?'), array('\'%s\''), $builder->toSql());
$query = vsprintf($query, $builder->getBindings());
dump($query);

Source: stackoverflow.com

Print query statement in laravel

DB::enableQueryLog();
$users = User::select("*")->get();
$quries = DB::getQueryLog();
dd($quries);
DB::table('users')->toSql();
dd($query);

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 vote331 views3 answers
Import faker in laravel
PHP Laravel
0 vote314 views1 answer
Add like and equal in same query in laravel
PHP Laravel
0 vote284 views1 answer
Creating default object from empty value laravel
PHP Laravel
12 votes300 views1 answer
Laravel model without timestamps
PHP Laravel
49 votes382 views6 answers
Join in laravel
PHP Laravel
7 votes278 views3 answers
Laravel get latest
PHP Laravel
31 votes275 views3 answers
Carbon laravel use
PHP Laravel
0 vote355 views1 answer
Laravel @extends
PHP Laravel
0 vote331 views1 answer
Referencing constant in config laravel
PHP Laravel
3 votes266 views2 answers
With function laravel
PHP Laravel