获取原始sql 获取数组键值和值

madianding

已于 2024-04-16 17:17:41 修改

阅读量65

点赞数 1

文章标签： sql android java

于 2024-04-13 22:46:55 首次发布

本文链接：https://blog.csdn.net/madianding/article/details/137727672

版权

获取原始sql
$query = (clone $builder)->where('user_id', $userId);
//        $sqlWithBindings = str_replace_array('?', $query->getBindings(), $query->toSql());
        MineLog::debug($query->getBindings());
        MineLog::debug($query->toSql());

DB::connection()->enableQueryLog();
dd(DB::getQueryLog())
        $a = end($queries);
        $tmp = str_replace('?', '"'.'%s'.'"', $a["query"]);
        Log::debug($tmp);
        Log::debug($a['bindings']);

获取数组键值和值
        $keys = array_keys($data);
        if ($keys[0]) $this->task->update(['order' => $data[$keys[0]]], $keys[0]);
        if ($keys[1]) $this->task->update(['order' => $data[$keys[1]]], $keys[1]);