| 250 |
kaklik |
1 |
<?php |
|
|
2 |
/* $Id: db_printview.php,v 2.15.2.1 2006/04/27 09:43:13 cybot_tm Exp $ */ |
|
|
3 |
// vim: expandtab sw=4 ts=4 sts=4: |
|
|
4 |
|
|
|
5 |
require_once './libraries/common.lib.php'; |
|
|
6 |
|
|
|
7 |
/** |
|
|
8 |
* Gets the variables sent or posted to this script, then displays headers |
|
|
9 |
*/ |
|
|
10 |
$print_view = true; |
|
|
11 |
require_once './libraries/header.inc.php'; |
|
|
12 |
|
|
|
13 |
PMA_checkParameters(array('db')); |
|
|
14 |
|
|
|
15 |
/** |
|
|
16 |
* Defines the url to return to in case of error in a sql statement |
|
|
17 |
*/ |
|
|
18 |
$err_url = 'db_details.php?' . PMA_generate_common_url($db); |
|
|
19 |
|
|
|
20 |
/** |
|
|
21 |
* Settings for relations stuff |
|
|
22 |
*/ |
|
|
23 |
require_once './libraries/relation.lib.php'; |
|
|
24 |
$cfgRelation = PMA_getRelationsParam(); |
|
|
25 |
|
|
|
26 |
/** |
|
|
27 |
* Gets the list of the table in the current db and informations about these |
|
|
28 |
* tables if possible |
|
|
29 |
* |
|
|
30 |
* @todo merge this speedup _optionaly_ into PMA_DBI_get_tables_full() |
|
|
31 |
* |
|
|
32 |
// staybyte: speedup view on locked tables - 11 June 2001 |
|
|
33 |
// Special speedup for newer MySQL Versions (in 4.0 format changed) |
|
|
34 |
if ($cfg['SkipLockedTables'] == true) { |
|
|
35 |
$result = PMA_DBI_query('SHOW OPEN TABLES FROM ' . PMA_backquote($db) . ';'); |
|
|
36 |
// Blending out tables in use |
|
|
37 |
if ($result != false && PMA_DBI_num_rows($result) > 0) { |
|
|
38 |
while ($tmp = PMA_DBI_fetch_row($result)) { |
|
|
39 |
// if in use memorize tablename |
|
|
40 |
if (preg_match('@in_use=[1-9]+@i', $tmp[0])) { |
|
|
41 |
$sot_cache[$tmp[0]] = true; |
|
|
42 |
} |
|
|
43 |
} |
|
|
44 |
PMA_DBI_free_result($result); |
|
|
45 |
|
|
|
46 |
if (isset($sot_cache)) { |
|
|
47 |
$result = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE); |
|
|
48 |
if ($result != false && PMA_DBI_num_rows($result) > 0) { |
|
|
49 |
while ($tmp = PMA_DBI_fetch_row($result)) { |
|
|
50 |
if (!isset($sot_cache[$tmp[0]])) { |
|
|
51 |
$sts_result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ' LIKE \'' . addslashes($tmp[0]) . '\';'); |
|
|
52 |
$sts_tmp = PMA_DBI_fetch_assoc($sts_result); |
|
|
53 |
$tables[] = $sts_tmp; |
|
|
54 |
} else { // table in use |
|
|
55 |
$tables[] = array('Name' => $tmp[0]); |
|
|
56 |
} |
|
|
57 |
} |
|
|
58 |
PMA_DBI_free_result($result); |
|
|
59 |
$sot_ready = true; |
|
|
60 |
} |
|
|
61 |
} |
|
|
62 |
unset($tmp, $result); |
|
|
63 |
} |
|
|
64 |
} |
|
|
65 |
|
|
|
66 |
if (! isset($sot_ready)) { |
|
|
67 |
$result = PMA_DBI_query('SHOW TABLE STATUS FROM ' . PMA_backquote($db) . ';'); |
|
|
68 |
if (PMA_DBI_num_rows($result) > 0) { |
|
|
69 |
while ($sts_tmp = PMA_DBI_fetch_assoc($result)) { |
|
|
70 |
$tables[] = $sts_tmp; |
|
|
71 |
} |
|
|
72 |
PMA_DBI_free_result($result); |
|
|
73 |
unset($res); |
|
|
74 |
} |
|
|
75 |
} |
|
|
76 |
*/ |
|
|
77 |
|
|
|
78 |
/** |
|
|
79 |
* If there is at least one table, displays the printer friendly view, else |
|
|
80 |
* an error message |
|
|
81 |
*/ |
|
|
82 |
$tables = PMA_DBI_get_tables_full($db); |
|
|
83 |
$num_tables = count($tables); |
|
|
84 |
|
|
|
85 |
echo '<br />'; |
|
|
86 |
|
|
|
87 |
// 1. No table |
|
|
88 |
if ($num_tables == 0) { |
|
|
89 |
echo $strNoTablesFound; |
|
|
90 |
} |
|
|
91 |
// 2. Shows table informations on mysql >= 3.23.03 - staybyte - 11 June 2001 |
|
|
92 |
else { |
|
|
93 |
?> |
|
|
94 |
<table> |
|
|
95 |
<thead> |
|
|
96 |
<tr> |
|
|
97 |
<th><?php echo $strTable; ?></th> |
|
|
98 |
<th><?php echo $strRecords; ?></th> |
|
|
99 |
<th><?php echo $strType; ?></th> |
|
|
100 |
<?php |
|
|
101 |
if ($cfg['ShowStats']) { |
|
|
102 |
echo '<th>' . $strSize . '</th>'; |
|
|
103 |
} |
|
|
104 |
?> |
|
|
105 |
<th><?php echo $strComments; ?></th> |
|
|
106 |
</tr> |
|
|
107 |
</thead> |
|
|
108 |
<tbody> |
|
|
109 |
<?php |
|
|
110 |
$sum_entries = $sum_size = 0; |
|
|
111 |
$odd_row = true; |
|
|
112 |
foreach ($tables as $sts_data) { |
|
|
113 |
if (strtoupper($sts_data['ENGINE']) == 'MRG_MYISAM' |
|
|
114 |
|| strtoupper($sts_data['ENGINE']) == 'FEDERATED') { |
|
|
115 |
$merged_size = true; |
|
|
116 |
} else { |
|
|
117 |
$merged_size = false; |
|
|
118 |
} |
|
|
119 |
$sum_entries += $sts_data['TABLE_ROWS']; |
|
|
120 |
?> |
|
|
121 |
<tr class="<?php echo $odd_row ? 'odd' : 'even'; ?>"> |
|
|
122 |
<th> |
|
|
123 |
<?php echo htmlspecialchars($sts_data['TABLE_NAME']); ?> |
|
|
124 |
</th> |
|
|
125 |
<?php |
|
|
126 |
|
|
|
127 |
if (isset($sts_data['TABLE_ROWS'])) { |
|
|
128 |
?> |
|
|
129 |
<td align="right"> |
|
|
130 |
<?php |
|
|
131 |
if ($merged_size) { |
|
|
132 |
echo '<i>' . number_format($sts_data['TABLE_ROWS'], 0, $number_decimal_separator, $number_thousands_separator) . '</i>' . "\n"; |
|
|
133 |
} else { |
|
|
134 |
echo number_format($sts_data['TABLE_ROWS'], 0, $number_decimal_separator, $number_thousands_separator) . "\n"; |
|
|
135 |
} |
|
|
136 |
?> |
|
|
137 |
</td> |
|
|
138 |
<td nowrap="nowrap"> |
|
|
139 |
<?php echo $sts_data['ENGINE']; ?> |
|
|
140 |
</td> |
|
|
141 |
<?php |
|
|
142 |
if ($cfg['ShowStats']) { |
|
|
143 |
$tblsize = $sts_data['Data_length'] + $sts_data['Index_length']; |
|
|
144 |
$sum_size += $tblsize; |
|
|
145 |
list($formated_size, $unit) = PMA_formatByteDown($tblsize, 3, 1); |
|
|
146 |
?> |
|
|
147 |
<td align="right" nowrap="nowrap"> |
|
|
148 |
<?php echo $formated_size . ' ' . $unit; ?> |
|
|
149 |
</td> |
|
|
150 |
<?php |
|
|
151 |
} // end if |
|
|
152 |
} else { |
|
|
153 |
?> |
|
|
154 |
<td colspan="3" align="center"> |
|
|
155 |
<?php echo $strInUse; ?> |
|
|
156 |
</td> |
|
|
157 |
<?php |
|
|
158 |
} |
|
|
159 |
?> |
|
|
160 |
<td> |
|
|
161 |
<?php |
|
|
162 |
if (! empty($sts_data['Comment'])) { |
|
|
163 |
echo $sts_data['Comment']; |
|
|
164 |
$needs_break = '<br />'; |
|
|
165 |
} else { |
|
|
166 |
$needs_break = ''; |
|
|
167 |
} |
|
|
168 |
|
|
|
169 |
if (! empty($sts_data['Create_time']) |
|
|
170 |
|| ! empty($sts_data['Update_time']) |
|
|
171 |
|| ! empty($sts_data['Check_time'])) { |
|
|
172 |
echo $needs_break; |
|
|
173 |
?> |
|
|
174 |
<table width="100%"> |
|
|
175 |
<?php |
|
|
176 |
|
|
|
177 |
if (! empty($sts_data['Create_time'])) { |
|
|
178 |
?> |
|
|
179 |
<tr> |
|
|
180 |
<td align="right"><?php echo $strStatCreateTime . ': '; ?></td> |
|
|
181 |
<td align="right"><?php echo PMA_localisedDate(strtotime($sts_data['Create_time'])); ?></td> |
|
|
182 |
</tr> |
|
|
183 |
<?php |
|
|
184 |
} |
|
|
185 |
|
|
|
186 |
if (! empty($sts_data['Update_time'])) { |
|
|
187 |
?> |
|
|
188 |
<tr> |
|
|
189 |
<td align="right"><?php echo $strStatUpdateTime . ': '; ?></td> |
|
|
190 |
<td align="right"><?php echo PMA_localisedDate(strtotime($sts_data['Update_time'])); ?></td> |
|
|
191 |
</tr> |
|
|
192 |
<?php |
|
|
193 |
} |
|
|
194 |
|
|
|
195 |
if (! empty($sts_data['Check_time'])) { |
|
|
196 |
?> |
|
|
197 |
<tr> |
|
|
198 |
<td align="right"><?php echo $strStatCheckTime . ': '; ?></td> |
|
|
199 |
<td align="right"><?php echo PMA_localisedDate(strtotime($sts_data['Check_time'])); ?></td> |
|
|
200 |
</tr> |
|
|
201 |
<?php |
|
|
202 |
} |
|
|
203 |
?> |
|
|
204 |
</table> |
|
|
205 |
<?php |
|
|
206 |
} |
|
|
207 |
?> |
|
|
208 |
</td> |
|
|
209 |
</tr> |
|
|
210 |
<?php |
|
|
211 |
} |
|
|
212 |
?> |
|
|
213 |
<tr> |
|
|
214 |
<th align="center"> |
|
|
215 |
<?php echo sprintf($strTables, number_format($num_tables, 0, $number_decimal_separator, $number_thousands_separator)); ?> |
|
|
216 |
</th> |
|
|
217 |
<th align="right" nowrap="nowrap"> |
|
|
218 |
<?php echo number_format($sum_entries, 0, $number_decimal_separator, $number_thousands_separator); ?> |
|
|
219 |
</th> |
|
|
220 |
<th align="center"> |
|
|
221 |
-- |
|
|
222 |
</th> |
|
|
223 |
<?php |
|
|
224 |
if ($cfg['ShowStats']) { |
|
|
225 |
list($sum_formated, $unit) = PMA_formatByteDown($sum_size, 3, 1); |
|
|
226 |
?> |
|
|
227 |
<th align="right" nowrap="nowrap"> |
|
|
228 |
<?php echo $sum_formated . ' ' . $unit; ?> |
|
|
229 |
</th> |
|
|
230 |
<?php |
|
|
231 |
} |
|
|
232 |
?> |
|
|
233 |
<th> </th> |
|
|
234 |
</tr> |
|
|
235 |
</tbody> |
|
|
236 |
</table> |
|
|
237 |
<?php |
|
|
238 |
} |
|
|
239 |
|
|
|
240 |
/** |
|
|
241 |
* Displays the footer |
|
|
242 |
*/ |
|
|
243 |
?> |
|
|
244 |
|
|
|
245 |
<script type="text/javascript" language="javascript"> |
|
|
246 |
//<![CDATA[ |
|
|
247 |
function printPage() |
|
|
248 |
{ |
|
|
249 |
// Do print the page |
|
|
250 |
if (typeof(window.print) != 'undefined') { |
|
|
251 |
window.print(); |
|
|
252 |
} |
|
|
253 |
} |
|
|
254 |
//]]> |
|
|
255 |
</script> |
|
|
256 |
<br /><br /> |
|
|
257 |
|
|
|
258 |
<input type="button" class="print_ignore" |
|
|
259 |
id="print" value="<?php echo $strPrint; ?>" onclick="printPage()" /> |
|
|
260 |
|
|
|
261 |
<?php |
|
|
262 |
require_once './libraries/footer.inc.php'; |
|
|
263 |
?> |