1<?php $this->extends('layout.php', ['title' => 'Admin :: Database status']) ?>
2
3<?php $this->start('content') ?>
4
5<?php $this->include('pages/admin/menu.php', ['action' => $action]); ?>
6
7<p>Running MySQL <b><?= $this->e($mysqlVersion); ?></b></p>
8
9<h3>Number of rows:</h3>
10
11<table>
12    <tbody>
13        <tr class="bug_header">
14            <th>Table</th>
15            <th>Rows</th>
16        </tr>
17        <?php foreach ($numberOfRowsPerTable as $tableName => $numberOfRows): ?>
18            <tr>
19                <td class="bug_bg0"><?= $this->e($tableName); ?></td>
20                <td class="bug_bg1"><?= $this->e($numberOfRows); ?></td>
21            </tr>
22        <?php endforeach ?>
23    </tbody>
24</table>
25
26<h3>Table status:</h3>
27
28<table>
29    <tbody>
30        <tr class="bug_header">
31            <th>Name</th>
32            <th>Engine</th>
33            <th>Version</th>
34            <th>Row_format</th>
35            <th>Rows</th>
36            <th>Avg_row_length</th>
37            <th>Data_length</th>
38            <th>Max_data_length</th>
39            <th>Index_length</th>
40            <th>Data_free</th>
41            <th>Auto_increment</th>
42            <th>Create_time</th>
43            <th>Update_time</th>
44            <th>Check_time</th>
45            <th>Collation</th>
46            <th>Checksum</th>
47            <th>Create_options</th>
48            <th>Comment</th>
49        </tr>
50        <?php foreach ($statusPerTable as $tableStatus): ?>
51            <tr>
52                <td class="bug_bg0"><?= $this->e($tableStatus['Name']); ?></td>
53                <td class="bug_bg1"><?= $this->e($tableStatus['Engine']); ?></td>
54                <td class="bug_bg0"><?= $tableStatus['Version']; ?></td>
55                <td class="bug_bg1"><?= $this->e($tableStatus['Row_format']); ?></td>
56                <td class="bug_bg0"><?= $tableStatus['Rows']; ?></td>
57                <td class="bug_bg1"><?= $tableStatus['Avg_row_length']; ?></td>
58                <td class="bug_bg0"><?= $tableStatus['Data_length']; ?></td>
59                <td class="bug_bg1"><?= $tableStatus['Max_data_length']; ?></td>
60                <td class="bug_bg0"><?= $tableStatus['Index_length']; ?></td>
61                <td class="bug_bg1"><?= $tableStatus['Data_free']; ?></td>
62                <td class="bug_bg0"><?= $tableStatus['Auto_increment']; ?></td>
63                <td class="bug_bg1"><?= $this->e($tableStatus['Create_time']); ?></td>
64                <td class="bug_bg0"><?= $this->e($tableStatus['Update_time']?:''); ?></td>
65                <td class="bug_bg1"><?php echo $tableStatus['Check_time'] ? $this->e($tableStatus['Check_time']) : ''; ?></td>
66                <td class="bug_bg0"><?= $this->e($tableStatus['Collation']); ?></td>
67                <td class="bug_bg1"><?php echo $tableStatus['Checksum'] ? $this->e($tableStatus['Checksum']) : ''; ?></td>
68                <td class="bug_bg0"><?= $this->e($tableStatus['Create_options']); ?></td>
69                <td class="bug_bg1"><?= $this->e($tableStatus['Comment']); ?></td>
70            </tr>
71        <?php endforeach ?>
72    </tbody>
73</table>
74
75<?php $this->end('content') ?>
76