/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

1 vote204 views1 answer
Laravel plural and singular
PHP Laravel
4 votes209 views3 answers
Php array_slice
PHP
0 vote211 views1 answer
Laravel Undefined index: token on reset
PHP Laravel
0 vote179 views0 answer
Laravel
PHP Laravel
32 votes181 views3 answers
Php remove item array
PHP
2 votes186 views2 answers
How make a variable global php
PHP
11 votes196 views3 answers
Laravel get last month records
PHP
0 vote254 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP Drupal
3 votes193 views5 answers
Php check if variable is int
PHP
10 votes213 views4 answers
In random order laravel
PHP

Share