/PHP/Laravel/Print query statement in laravel

Print query statement in laravel

Laravel print query with parameters

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

1

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);

0

Show query in laravel

Use the toSql() method on a QueryBuilder instance.

DB::table('users')->toSql()

0

Similar codes

23 votes148 views4 answers
Laravel carbon isoformat
PHP Laravel
12 votes240 views3 answers
Validation.required laravel
PHP Laravel
6 votes158 views2 answers
Generate application key laravel
PHP Laravel
3 votes160 views2 answers
Laravel check if laravel query is empty
PHP Laravel
2 votes168 views1 answer
Laravel model id string
PHP Laravel
0 vote147 views1 answer
Check for headers laravel
PHP Laravel
1 vote233 views2 answers
Get ip in laravel
PHP Laravel
0 vote153 views1 answer
Laravel request input default value
PHP Laravel
0 vote174 views1 answer
Laravel reload relationship
PHP Laravel
0 vote160 views1 answer
Laravel use npm package
PHP Laravel

Share