/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

-2 votes60 views1 answer
Laravel custom rule
PHP
3 votes101 views1 answer
Laravel throw function
PHP
0 vote89 views1 answer
Vault create/enable secret engine
PHP
1 vote103 views1 answer
Shorttime php
PHP
8 votes114 views5 answers
Laravel belongs to
PHP
0 vote103 views1 answer
Auth.php Class "\App\User" not found
PHP
22 votes138 views5 answers
Get logged user id laravel
PHP Laravel
2 votes151 views2 answers
Laravel read json file from storage
PHP Laravel
0 vote92 views2 answers
Php json request get value of an array element
PHP
4 votes212 views2 answers
Php sha512
PHP

Share