| 250 |
kaklik |
1 |
<?php |
|
|
2 |
/* $Id: db_datadict.php,v 2.23 2006/01/17 17:02:28 cybot_tm Exp $ */ |
|
|
3 |
|
|
|
4 |
|
|
|
5 |
/** |
|
|
6 |
* Gets the variables sent or posted to this script, then displays headers |
|
|
7 |
*/ |
|
|
8 |
require_once('./libraries/common.lib.php'); |
|
|
9 |
|
|
|
10 |
if (!isset($selected_tbl)) { |
|
|
11 |
require_once('./libraries/header.inc.php'); |
|
|
12 |
} |
|
|
13 |
|
|
|
14 |
|
|
|
15 |
/** |
|
|
16 |
* Gets the relations settings |
|
|
17 |
*/ |
|
|
18 |
require_once('./libraries/relation.lib.php'); |
|
|
19 |
require_once('./libraries/transformations.lib.php'); |
|
|
20 |
|
|
|
21 |
$cfgRelation = PMA_getRelationsParam(); |
|
|
22 |
|
|
|
23 |
/** |
|
|
24 |
* Check parameters |
|
|
25 |
*/ |
|
|
26 |
PMA_checkParameters(array('db')); |
|
|
27 |
|
|
|
28 |
/** |
|
|
29 |
* Defines the url to return to in case of error in a sql statement |
|
|
30 |
*/ |
|
|
31 |
if (isset($table)) { |
|
|
32 |
$err_url = 'tbl_properties.php?' . PMA_generate_common_url($db, $table); |
|
|
33 |
} else { |
|
|
34 |
$err_url = 'db_details.php?' . PMA_generate_common_url($db); |
|
|
35 |
} |
|
|
36 |
|
|
|
37 |
if ($cfgRelation['commwork']) { |
|
|
38 |
$comment = PMA_getComments($db); |
|
|
39 |
|
|
|
40 |
/** |
|
|
41 |
* Displays DB comment |
|
|
42 |
*/ |
|
|
43 |
if (is_array($comment)) { |
|
|
44 |
?> |
|
|
45 |
<p> <?php echo $strDBComment; ?> |
|
|
46 |
<i><?php echo htmlspecialchars( implode( ' ', $comment ) ); ?></i></p> |
|
|
47 |
<?php |
|
|
48 |
} // end if |
|
|
49 |
} |
|
|
50 |
|
|
|
51 |
/** |
|
|
52 |
* Selects the database and gets tables names |
|
|
53 |
*/ |
|
|
54 |
PMA_DBI_select_db($db); |
|
|
55 |
$rowset = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE); |
|
|
56 |
|
|
|
57 |
$count = 0; |
|
|
58 |
while ($row = PMA_DBI_fetch_assoc($rowset)) { |
|
|
59 |
$myfieldname = 'Tables_in_' . htmlspecialchars($db); |
|
|
60 |
$table = $row[$myfieldname]; |
|
|
61 |
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) { |
|
|
62 |
$comments = PMA_getComments($db, $table); |
|
|
63 |
} |
|
|
64 |
|
|
|
65 |
if ($count != 0) { |
|
|
66 |
echo '<div style="page-break-before: always;">' . "\n"; |
|
|
67 |
} else { |
|
|
68 |
echo '<div>' . "\n"; |
|
|
69 |
} |
|
|
70 |
|
|
|
71 |
echo '<h2>' . $table . '</h2>' . "\n"; |
|
|
72 |
|
|
|
73 |
/** |
|
|
74 |
* Gets table informations |
|
|
75 |
*/ |
|
|
76 |
// The 'show table' statement works correct since 3.23.03 |
|
|
77 |
$showtable = PMA_DBI_get_tables_full( $db, $table ); |
|
|
78 |
$num_rows = (isset($showtable[$table]['TABLE_ROWS']) ? $showtable[$table]['TABLE_ROWS'] : 0); |
|
|
79 |
$show_comment = (isset($showtable[$table]['TABLE_COMMENT']) ? $showtable[$table]['TABLE_COMMENT'] : ''); |
|
|
80 |
unset( $showtable ); |
|
|
81 |
|
|
|
82 |
|
|
|
83 |
/** |
|
|
84 |
* Gets table keys and retains them |
|
|
85 |
*/ |
|
|
86 |
|
|
|
87 |
PMA_DBI_select_db($db); |
|
|
88 |
$result = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';'); |
|
|
89 |
$primary = ''; |
|
|
90 |
$indexes = array(); |
|
|
91 |
$lastIndex = ''; |
|
|
92 |
$indexes_info = array(); |
|
|
93 |
$indexes_data = array(); |
|
|
94 |
$pk_array = array(); // will be use to emphasis prim. keys in the table |
|
|
95 |
// view |
|
|
96 |
while ($row = PMA_DBI_fetch_assoc($result)) { |
|
|
97 |
// Backups the list of primary keys |
|
|
98 |
if ($row['Key_name'] == 'PRIMARY') { |
|
|
99 |
$primary .= $row['Column_name'] . ', '; |
|
|
100 |
$pk_array[$row['Column_name']] = 1; |
|
|
101 |
} |
|
|
102 |
// Retains keys informations |
|
|
103 |
if ($row['Key_name'] != $lastIndex ){ |
|
|
104 |
$indexes[] = $row['Key_name']; |
|
|
105 |
$lastIndex = $row['Key_name']; |
|
|
106 |
} |
|
|
107 |
$indexes_info[$row['Key_name']]['Sequences'][] = $row['Seq_in_index']; |
|
|
108 |
$indexes_info[$row['Key_name']]['Non_unique'] = $row['Non_unique']; |
|
|
109 |
if (isset($row['Cardinality'])) { |
|
|
110 |
$indexes_info[$row['Key_name']]['Cardinality'] = $row['Cardinality']; |
|
|
111 |
} |
|
|
112 |
// I don't know what does following column mean.... |
|
|
113 |
// $indexes_info[$row['Key_name']]['Packed'] = $row['Packed']; |
|
|
114 |
|
|
|
115 |
$indexes_info[$row['Key_name']]['Comment'] = $row['Comment']; |
|
|
116 |
|
|
|
117 |
$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Column_name'] = $row['Column_name']; |
|
|
118 |
if (isset($row['Sub_part'])) { |
|
|
119 |
$indexes_data[$row['Key_name']][$row['Seq_in_index']]['Sub_part'] = $row['Sub_part']; |
|
|
120 |
} |
|
|
121 |
|
|
|
122 |
} // end while |
|
|
123 |
if ($result) { |
|
|
124 |
PMA_DBI_free_result($result); |
|
|
125 |
} |
|
|
126 |
|
|
|
127 |
|
|
|
128 |
/** |
|
|
129 |
* Gets fields properties |
|
|
130 |
*/ |
|
|
131 |
$result = PMA_DBI_query('SHOW FIELDS FROM ' . PMA_backquote($table) . ';', null, PMA_DBI_QUERY_STORE); |
|
|
132 |
$fields_cnt = PMA_DBI_num_rows($result); |
|
|
133 |
// Check if we can use Relations (Mike Beck) |
|
|
134 |
if (!empty($cfgRelation['relation'])) { |
|
|
135 |
// Find which tables are related with the current one and write it in |
|
|
136 |
// an array |
|
|
137 |
$res_rel = PMA_getForeigners($db, $table); |
|
|
138 |
|
|
|
139 |
if (count($res_rel) > 0) { |
|
|
140 |
$have_rel = TRUE; |
|
|
141 |
} else { |
|
|
142 |
$have_rel = FALSE; |
|
|
143 |
} |
|
|
144 |
} else { |
|
|
145 |
$have_rel = FALSE; |
|
|
146 |
} // end if |
|
|
147 |
|
|
|
148 |
|
|
|
149 |
/** |
|
|
150 |
* Displays the comments of the table if MySQL >= 3.23 |
|
|
151 |
*/ |
|
|
152 |
if (!empty($show_comment)) { |
|
|
153 |
echo $strTableComments . ': ' . $show_comment . '<br /><br />'; |
|
|
154 |
} |
|
|
155 |
|
|
|
156 |
/** |
|
|
157 |
* Displays the table structure |
|
|
158 |
*/ |
|
|
159 |
?> |
|
|
160 |
|
|
|
161 |
<table width="100%" class="print"> |
|
|
162 |
<tr><th width="50"><?php echo $strField; ?></th> |
|
|
163 |
<th width="80"><?php echo $strType; ?></th> |
|
|
164 |
<?php /* <th width="50"><?php echo $strAttr; ?></th>*/ ?> |
|
|
165 |
<th width="40"><?php echo $strNull; ?></th> |
|
|
166 |
<th width="70"><?php echo $strDefault; ?></th> |
|
|
167 |
<?php /* <th width="50"><?php echo $strExtra; ?></th>*/ ?> |
|
|
168 |
<?php |
|
|
169 |
if ($have_rel) { |
|
|
170 |
echo ' <th>' . $strLinksTo . '</th>' . "\n"; |
|
|
171 |
} |
|
|
172 |
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) { |
|
|
173 |
echo ' <th>' . $strComments . '</th>' . "\n"; |
|
|
174 |
} |
|
|
175 |
if ($cfgRelation['mimework']) { |
|
|
176 |
echo ' <th>MIME</th>' . "\n"; |
|
|
177 |
} |
|
|
178 |
?> |
|
|
179 |
</tr> |
|
|
180 |
<?php |
|
|
181 |
$odd_row = true; |
|
|
182 |
while ($row = PMA_DBI_fetch_assoc($result)) { |
|
|
183 |
|
|
|
184 |
$type = $row['Type']; |
|
|
185 |
// reformat mysql query output - staybyte - 9. June 2001 |
|
|
186 |
// loic1: set or enum types: slashes single quotes inside options |
|
|
187 |
if (preg_match('@^(set|enum)\((.+)\)$@i', $type, $tmp)) { |
|
|
188 |
$tmp[2] = substr(preg_replace('@([^,])\'\'@', '\\1\\\'', ',' . $tmp[2]), 1); |
|
|
189 |
$type = $tmp[1] . '(' . str_replace(',', ', ', $tmp[2]) . ')'; |
|
|
190 |
$type_nowrap = ''; |
|
|
191 |
|
|
|
192 |
$binary = 0; |
|
|
193 |
$unsigned = 0; |
|
|
194 |
$zerofill = 0; |
|
|
195 |
} else { |
|
|
196 |
$binary = stristr($row['Type'], 'binary'); |
|
|
197 |
$unsigned = stristr($row['Type'], 'unsigned'); |
|
|
198 |
$zerofill = stristr($row['Type'], 'zerofill'); |
|
|
199 |
$type_nowrap = ' nowrap="nowrap"'; |
|
|
200 |
$type = preg_replace('@BINARY@i', '', $type); |
|
|
201 |
$type = preg_replace('@ZEROFILL@i', '', $type); |
|
|
202 |
$type = preg_replace('@UNSIGNED@i', '', $type); |
|
|
203 |
if (empty($type)) { |
|
|
204 |
$type = ' '; |
|
|
205 |
} |
|
|
206 |
} |
|
|
207 |
$strAttribute = ' '; |
|
|
208 |
if ($binary) { |
|
|
209 |
$strAttribute = 'BINARY'; |
|
|
210 |
} |
|
|
211 |
if ($unsigned) { |
|
|
212 |
$strAttribute = 'UNSIGNED'; |
|
|
213 |
} |
|
|
214 |
if ($zerofill) { |
|
|
215 |
$strAttribute = 'UNSIGNED ZEROFILL'; |
|
|
216 |
} |
|
|
217 |
if (!isset($row['Default'])) { |
|
|
218 |
if ($row['Null'] != '' && $row['Null'] != 'NO') { |
|
|
219 |
$row['Default'] = '<i>NULL</i>'; |
|
|
220 |
} |
|
|
221 |
} else { |
|
|
222 |
$row['Default'] = htmlspecialchars($row['Default']); |
|
|
223 |
} |
|
|
224 |
$field_name = htmlspecialchars($row['Field']); |
|
|
225 |
?> |
|
|
226 |
<tr class="<?php echo $odd_row ? 'odd' : 'even'; $odd_row = ! $odd_row; ?>"> |
|
|
227 |
<td nowrap="nowrap"> |
|
|
228 |
<?php |
|
|
229 |
if (isset($pk_array[$row['Field']])) { |
|
|
230 |
echo '<u>' . $field_name . '</u>'; |
|
|
231 |
} else { |
|
|
232 |
echo $field_name; |
|
|
233 |
} |
|
|
234 |
?> |
|
|
235 |
</td> |
|
|
236 |
<td<?php echo $type_nowrap; ?> xml:lang="en" dir="ltr"><?php echo $type; ?></td> |
|
|
237 |
<?php /* <td<?php echo $type_nowrap; ?>><?php echo $strAttribute; ?></td>*/ ?> |
|
|
238 |
<td><?php echo (($row['Null'] == '' || $row['Null'] == 'NO') ? $strNo : $strYes); ?></td> |
|
|
239 |
<td nowrap="nowrap"><?php if (isset($row['Default'])) { echo $row['Default']; } ?></td> |
|
|
240 |
<?php /* <td<?php echo $type_nowrap; ?>><?php echo $row['Extra']; ?></td>*/ ?> |
|
|
241 |
<?php |
|
|
242 |
if ($have_rel) { |
|
|
243 |
echo ' <td>'; |
|
|
244 |
if (isset($res_rel[$field_name])) { |
|
|
245 |
echo htmlspecialchars($res_rel[$field_name]['foreign_table'] . ' -> ' . $res_rel[$field_name]['foreign_field']); |
|
|
246 |
} |
|
|
247 |
echo '</td>' . "\n"; |
|
|
248 |
} |
|
|
249 |
if ($cfgRelation['commwork'] || PMA_MYSQL_INT_VERSION >= 40100) { |
|
|
250 |
echo ' <td>'; |
|
|
251 |
if (isset($comments[$field_name])) { |
|
|
252 |
echo htmlspecialchars($comments[$field_name]); |
|
|
253 |
} |
|
|
254 |
echo '</td>' . "\n"; |
|
|
255 |
} |
|
|
256 |
if ($cfgRelation['mimework']) { |
|
|
257 |
$mime_map = PMA_getMIME($db, $table, true); |
|
|
258 |
|
|
|
259 |
echo ' <td>'; |
|
|
260 |
if (isset($mime_map[$field_name])) { |
|
|
261 |
echo htmlspecialchars(str_replace('_', '/', $mime_map[$field_name]['mimetype'])); |
|
|
262 |
} |
|
|
263 |
echo '</td>' . "\n"; |
|
|
264 |
} |
|
|
265 |
?> |
|
|
266 |
</tr> |
|
|
267 |
<?php |
|
|
268 |
} // end while |
|
|
269 |
PMA_DBI_free_result( $result ); |
|
|
270 |
$count++; |
|
|
271 |
?> |
|
|
272 |
</table> |
|
|
273 |
</div> |
|
|
274 |
<?php |
|
|
275 |
} //ends main while |
|
|
276 |
|
|
|
277 |
/** |
|
|
278 |
* Displays the footer |
|
|
279 |
*/ |
|
|
280 |
?> |
|
|
281 |
<script type="text/javascript" language="javascript"> |
|
|
282 |
//<![CDATA[ |
|
|
283 |
function printPage() |
|
|
284 |
{ |
|
|
285 |
document.getElementById('print').style.visibility = 'hidden'; |
|
|
286 |
// Do print the page |
|
|
287 |
if (typeof(window.print) != 'undefined') { |
|
|
288 |
window.print(); |
|
|
289 |
} |
|
|
290 |
document.getElementById('print').style.visibility = ''; |
|
|
291 |
} |
|
|
292 |
//]]> |
|
|
293 |
</script> |
|
|
294 |
<?php |
|
|
295 |
echo '<br /><br /><input type="button" id="print" value="' . $strPrint . '" onclick="printPage()" />'; |
|
|
296 |
|
|
|
297 |
require_once('./libraries/footer.inc.php'); |
|
|
298 |
?> |