php mysql打印sql语句_laravel（PHP）打印sql语句

(1)打开/app/Providers/AppServiceProvider.php文件

(2)boot函数加入下面的代码

public function boot()

{

DB::listen(

function ($sql) {

foreach ($sql->bindings as $i => $binding) {

if ($binding instanceof \DateTime) {

$sql->bindings[$i] = $binding->format('\'Y-m-d H:i:s\'');

} else {

if (is_string($binding)) {

$sql->bindings[$i] = "'$binding'";

}

}

}

// Insert bindings into query

$query = str_replace(array('%', '?'), array('%%', '%s'), $sql->sql);

$query = vsprintf($query, $sql->bindings);

// Save the query to file

$logFile = fopen(

storage_path('logs' . DIRECTORY_SEPARATOR . date('Y-m-d') . '_query.log'),

'a+'

);

fwrite($logFile, date('Y-m-d H:i:s') . ': ' . $query . PHP_EOL);

fclose($logFile);

}

);

}

(3)执行一次查库，则生成日志文件storage/logs/2020-08-21_query.log，如下图：