//echo '<div class="span10">'; echo '<br />' . $_GET['database'] . '<i class=icon-backward></i> <a href=dbStructure.php?database=' . $_GET['database'] . ' target="right">' . $lang['back'] . '</a><br /><br />'; include_once 'templates/sql_query_navi.html'; echo "<br /><br />"; $transport = new TSocket(HOST, PORT); $protocol = new TBinaryProtocol($transport); $client = new ThriftHiveClient($protocol); $transport->open(); $sql = 'use `' . $_GET['database'] . '`'; //echo $sql.'<br /><br />'; $client->execute($sql); //$client->fetchOne(); $sql = 'desc formatted ' . $_GET['table']; $client->execute($sql); $array_desc_table = $client->fetchAll(); $array_desc_table_1 = $etc->GetTableDetail($array_desc_table, "1"); $array_desc_table_4 = @$etc->GetTableDetail($array_desc_table, "4"); if ($array_desc_table_4[0] != "") { $array_desc_desc = @array_merge($array_desc_table_1, $array_desc_table_4); } else { $array_desc_desc = $array_desc_table_1; } //get table description and explode the desc into a multi-dimensional array //��ȡ��˵�����������ά����$array_desc_desc $i = 0; while ('' != @$array_desc_desc[$i]) { $array_desc = explode(' ', $array_desc_desc[$i]); $array_desc_desc_col['name'][$i] = trim($array_desc[0]); $array_desc_desc_col['type'][$i] = trim($array_desc[1]); $array_desc_desc_col['comment'][$i] = trim($array_desc[2]); $i++;
die($lang['dieDatabaseChoose']); } else { $transport = new TSocket(HOST, PORT); $protocol = new TBinaryProtocol($transport); $client = new ThriftHiveClient($protocol); $transport->open(); $client->execute('use ' . $_GET['database']); echo '<div class="container">'; echo '<div class="span10">'; if (!@$_GET['table']) { die($lang['dieTableChoose']); } else { $sql = "desc formatted " . $_GET['table']; $client->execute($sql); $arr = $client->fetchAll(); $arr = $etc->GetTableDetail($arr, "2"); $j = 0; foreach ($arr as $k => $v) { $array_desc = explode(':', $v); $array_desc_desc['key'][$j] = trim($array_desc[0]); $array_desc_desc['value'][$j] = trim($array_desc[1]); if ($array_desc_desc['value'][$j] == 'MANAGED_TABLE' || $array_desc_desc['value'][$j] == 'INDEX_TABLE') { $tmp['key'] = $array_desc_desc['key'][$j]; $tmp['value'] = $array_desc_desc['value'][$j]; } $j++; } if ($tmp['value'] != "MANAGED_TABLE" && $tmp['value'] != "INDEX_TABLE") { die('<script>alert("' . $lang['notExternalTable'] . '");history.back();</script>'); } else { echo "<a href=dbStructure.php?database=" . $_GET['database'] . "><i class=icon-backward></i>" . $lang['back'] . "</a><br><br>";