db-index.php

<?php

//* Tämä skripti käyttää slave-tietokantapalvelinta *//
$useslave = 1;

require "inc/parametrit.inc";

echo "<table><tr><td valign='top' class='back'>";

$query  = "SHOW FULL TABLES FROM `$dbkanta` WHERE Table_Type = 'BASE TABLE'";
$result =  pupe_query($query);

while ($row=mysqli_fetch_array($result)) {
  echo "<a href='$PHP_SELF?table=$row[0]'>$row[0]</a><br>";
}

echo "</td><td class='back' valign='top'>";

if ($table!='') {
  $query  = "show index from $table";
  $fields =  pupe_query($query);

  echo "<b>$table</b> (<a href='db.php?table=$table'>table</a> - <a href='db-index.php?table=$table'>index</a>)<br><br>";

  echo "<table>";
  echo "<tr><th>Key_name</th><th>Seq_in_index</th><th>Column_name</th><th>Cardinality</th><th>Index_type</th></tr>";

  $boob = 1;

  while ($row=mysqli_fetch_array($fields)) {
    if ($row['Seq_in_index']==1 and $boob==0) {
      echo "<tr><td class='back' colspan='5'><hr noshade></td></tr>";
    }

    echo "<tr><td>$row[Key_name]</td><td>$row[Seq_in_index]</td><td>$row[Column_name]</td><td>$row[Cardinality]</td><td>$row[Index_type]</td></tr>";

    $boob = 0;
  }

  echo "</table>";
}

echo "</td></tr></table>";

require "inc/footer.inc";