1#@!#!123s

: / opt / lampp / phpmyadmin / templates / table / structure /
Filename : row_stats_table.phtml
back
<table id="tablerowstats" class="data">
<caption class="tblHeaders"><?= __('Row statistics'); ?></caption>
<tbody>
    <?php if (isset($showtable['Row_format'])): ?>
        <tr>
        <th class="name"><?= __('Format'); ?></th>
        <?php if ($showtable['Row_format'] == 'Fixed'): ?>
            <td class="value"><?= __('static'); ?></td>
        <?php elseif ($showtable['Row_format'] == 'Dynamic'): ?>
            <td class="value"><?= __('dynamic'); ?></td>
        <?php else: ?>
            <td class="value"><?= $showtable['Row_format']; ?></td>
        <?php endif; ?>
        </tr>
    <?php endif; ?>

    <?php if (! empty($showtable['Create_options'])): ?>
        <tr>
        <th class="name"><?= __('Options'); ?></th>
        <?php if ($showtable['Create_options'] == 'partitioned'): ?>
            <td class="value"><?= __('partitioned'); ?></td>
        <?php else: ?>
            <td class="value"><?= $showtable['Create_options']; ?></td>
        <?php endif; ?>
        </tr>
    <?php endif; ?>

    <?php if (!empty($tbl_collation)): ?>
        <tr>
        <th class="name"><?= __('Collation'); ?></th>
        <td class="value">
            <dfn title="<?= PMA\libraries\Charsets::getCollationDescr($tbl_collation); ?>">
                <?= $tbl_collation; ?>
            </dfn>
        </td>
        </tr>
    <?php endif; ?>

    <?php if (!$is_innodb && isset($showtable['Rows'])): ?>
        <tr>
        <th class="name"><?= __('Rows'); ?></th>
        <td class="value"><?= PMA\libraries\Util::formatNumber($showtable['Rows'], 0); ?></td>
        </tr>
    <?php endif; ?>

    <?php if (!$is_innodb
        && isset($showtable['Avg_row_length'])
        && $showtable['Avg_row_length'] > 0
        ): ?>
        <?php list($avg_row_length_value, $avg_row_length_unit)
            = PMA\libraries\Util::formatByteDown($showtable['Avg_row_length'], 6, 1); ?>
        <tr>
        <th class="name"><?= __('Row length'); ?></th>
        <td class="value"><?= $avg_row_length_value , ' ' , $avg_row_length_unit; ?></td>
        </tr>
        <?php unset($avg_row_length_value, $avg_row_length_unit); ?>
    <?php endif; ?>

    <?php if (!$is_innodb
            && isset($showtable['Data_length'])
            && isset($showtable['Rows'])
            && $showtable['Rows'] > 0
            && $mergetable == false): ?>
        <tr>
        <th class="name"><?= __('Row size'); ?></th>
        <td class="value"><?= $avg_size , ' ' , $avg_unit; ?></td>
        </tr>
    <?php endif; ?>

    <?php if (isset($showtable['Auto_increment'])): ?>
        <tr>
        <th class="name"><?= __('Next autoindex'); ?></th>
        <td class="value"><?= PMA\libraries\Util::formatNumber($showtable['Auto_increment'], 0); ?></td>
        </tr>
    <?php endif; ?>

    <?php if (isset($showtable['Create_time'])): ?>
        <tr>
        <th class="name"><?= __('Creation'); ?></th>
        <td class="value"><?= PMA\libraries\Util::localisedDate(strtotime($showtable['Create_time'])); ?></td>
        </tr>
    <?php endif; ?>

    <?php if (isset($showtable['Update_time'])): ?>
        <tr>
        <th class="name"><?= __('Last update'); ?></th>
        <td class="value"><?= PMA\libraries\Util::localisedDate(strtotime($showtable['Update_time'])); ?></td>
        </tr>
    <?php endif; ?>

    <?php if (isset($showtable['Check_time'])): ?>
        <tr>
        <th class="name"><?= __('Last check'); ?></th>
        <td class="value"><?= PMA\libraries\Util::localisedDate(strtotime($showtable['Check_time'])); ?></td>
        </tr>
    <?php endif; ?>
</tbody>
</table>