Example #1
0
 } else {
     if ($_POST['tablename'] == "") {
         echo $lang['specify_tbl'];
     } else {
         echo "<form action='?table=" . urlencode($_POST['tablename']) . "&amp;action=index_create&amp;confirm=1' method='post'>";
         $num = intval($_POST['numcolumns']);
         $query = "PRAGMA table_info(" . $db->quote_id($_POST['tablename']) . ")";
         $result = $db->selectArray($query);
         echo "<fieldset><legend>" . $lang['define_index'] . "</legend>";
         echo "<label for='index_name'>" . $lang['index_name'] . ":</label> <input type='text' name='name' id='index_name'/><br/>";
         echo "<label for='index_duplicate'>" . $lang['dup_val'] . ":</label>";
         echo "<select name='duplicate' id='index_duplicate'>";
         echo "<option value='yes'>" . $lang['allow'] . "</option>";
         echo "<option value='no'>" . $lang['not_allow'] . "</option>";
         echo "</select><br/>";
         if (version_compare($db->getSQLiteVersion(), '3.8.0') >= 0) {
             echo "<label for='index_where'>WHERE:</label> <input type='text' name='where' id='index_where'/> " . helpLink($lang['help10']);
         }
         echo "</fieldset>";
         echo "<br/>";
         echo "<fieldset><legend>" . $lang['define_in_col'] . "</legend>";
         for ($i = 0; $i < $num; $i++) {
             echo "<select name='" . $i . "_field'>";
             echo "<option value=''>--" . $lang['ignore'] . "--</option>";
             for ($j = 0; $j < sizeof($result); $j++) {
                 echo "<option value='" . htmlencode($result[$j][1]) . "'>" . htmlencode($result[$j][1]) . "</option>";
             }
             echo "</select> ";
             echo "<select name='" . $i . "_order'>";
             echo "<option value=''></option>";
             echo "<option value=' ASC'>" . $lang['asc'] . "</option>";