laravel打印完整sql语句
PHP ⋅
波波文 ⋅
1年前 ⋅
0 点赞 ⋅
1,661 阅读 ⋅
0 评论
DB::enableQueryLog(); // 开启查询日志
**
这里放入查询的sql
**
$queriesConf = DB::getQueryLog();//获取查询日志
if (!empty($queriesConf)) {
foreach ($queriesConf as &$query) {
foreach ($query['bindings'] as $i => $binding) {
if ($binding instanceof \DateTime) {
$query['bindings'][$i] = $binding->format('\'Y-m-d H:i:s\'');
} else {
if (is_string($binding)) {
$query['bindings'][$i] = "'$binding'";
}
}
}
$query['full_query'] = vsprintf(str_replace('?', '%s', $query['query']), $query['bindings']);
}
}