laravel打印完整sql语句
PHP ⋅
波波 ⋅
1年前 ⋅
0 点赞 ⋅
2,393 阅读 ⋅
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']); }}