34 lines
1.1 KiB
PHP
34 lines
1.1 KiB
PHP
<?php
|
|
|
|
/** Expanded table indexes structure output
|
|
* @link https://www.adminer.org/plugins/#use
|
|
* @author Matthew Gamble, https://www.matthewgamble.net/
|
|
* @license https://www.apache.org/licenses/LICENSE-2.0 Apache License, Version 2.0
|
|
* @license https://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2 (one or other)
|
|
*/
|
|
class AdminerTableIndexesStructure {
|
|
|
|
/** Print table structure in tabular format
|
|
* @Param array data about all indexes on a table
|
|
* @return bool
|
|
*/
|
|
function tableIndexesPrint($indexes) {
|
|
echo "<table cellspacing='0'>\n";
|
|
echo "<thead><tr><th>" . lang('Name') . "<th>" . lang('Type') . "<th>" . lang('Columns') . "</thead>\n";
|
|
foreach ($indexes as $name => $index) {
|
|
echo "<tr><th>" . h($name) . "<td>" . $index['type'];
|
|
ksort($index["columns"]); // enforce correct columns order
|
|
$print = array();
|
|
foreach ($index["columns"] as $key => $val) {
|
|
$print[] = "<i>" . h($val) . "</i>"
|
|
. ($index["lengths"][$key] ? "(" . $index["lengths"][$key] . ")" : "")
|
|
. ($index["descs"][$key] ? " DESC" : "")
|
|
;
|
|
}
|
|
echo "<td>" . implode(", ", $print) . "\n";
|
|
}
|
|
echo "</table>\n";
|
|
return true;
|
|
}
|
|
}
|