thinkphp获取数据表中的字段信息和数据表的信息

  //所有字段信息
        $field_list = Db::query('SHOW FULL COLUMNS FROM `' . $table_name . '`');
        //表信息
        $table_info = Db::query('SHOW TABLE STATUS LIKE ' . "'" . $table_name . "'");
        $table_info = $table_info[0];
        //表名
        $data['table']['name'] = $table_info['Name'];
        //表中文名
        $data['table']['cn_name'] = $table_info['Comment'];