/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

0 vote343 views1 answer
Laravel move/rename file ftp
PHP Laravel
15 votes327 views3 answers
Laravel make model with migration 5.8
PHP Laravel
10 votes366 views3 answers
Check count in laravel
PHP Laravel
22 votes345 views5 answers
Get logged user id laravel
PHP Laravel
20 votes334 views6 answers
Laravel 8 make:auth
PHP Laravel
0 vote326 views1 answer
Diffforhumans laravel
PHP Laravel
2 votes338 views2 answers
Laravel read json file from storage
PHP Laravel
0 vote348 views1 answer
Show data from a table in laravel 8
PHP Laravel
3 votes333 views6 answers
Add to collection laravel
PHP Laravel
1 vote343 views2 answers
Laravel SPA cors
PHP Laravel

Share