How to display queries to the database on the screen in laravel?

Question

Laravel

I watch lessons and there at the teacher the dump () function issues queries to the database on the screen. But I only have data. Can you please tell me how to enable this feature?

Answer 1

I check with Laravel Debugbar

Answer 2

Knee variant
For specific request

<?php

DB::enableQueryLog();

//Ваш код .....

$dump = DB::getQueryLog();
$bindings = $dump[0]['bindings'];
$query = $dump[0]['query'];
$query = str_replace('?','"?"',$query);
dump(str_replace_array('?',$bindings,$query));

For every request

//AppServiceProvider.php
<?php

//....

public function boot() {
    DB::listen(function($query) {
         $bindings = $query->bindings;
         $sql = $query->sql;
         $sql = str_replace('?','"?"',$sql);
         dump(str_replace_array( '?', $bindings, $sql)."{$query->time} sec");   
    });
}

Answer 3

put a telescope on yourself and look

Answer 4

dd($post), this is like the last example
$post->toSql(), this is to show as a query