/PHP/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

0 vote159 views1 answer
Get session token in wp_login hook
PHP
51 votes220 views6 answers
Laravel run all seeders
PHP
0 vote185 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
13 votes176 views3 answers
Inplode php
PHP
0 vote156 views1 answer
Laavel relation through morph
PHP
5 votes234 views2 answers
Get app url in laravel
PHP Laravel
0 vote190 views1 answer
Laravel observer check if field changed
PHP Laravel
-1 vote151 views1 answer
Php search in object. array
PHP
-1 vote152 views2 answers
Php echo alert js
PHP
0 vote183 views1 answer
Wp create menu location
PHP

Share