Exemplo n.º 1
0
    // Displays the results in a table
    if (empty($disp_mode)) {
        // see the "PMA_setDisplayMode()" function in
        // libraries/display_tbl.lib.php
        $disp_mode = 'urdr111101';
    }
    // hide edit and delete links for information_schema
    if (PMA_MYSQL_INT_VERSION >= 50002 && $db == 'information_schema') {
        $disp_mode = 'nnnn110111';
    }
    PMA_displayTable($result, $disp_mode, $analyzed_sql);
    PMA_DBI_free_result($result);
    // BEGIN INDEX CHECK See if indexes should be checked.
    if (isset($query_type) && $query_type == 'check_tbl' && isset($selected) && is_array($selected)) {
        foreach ($selected as $idx => $tbl_name) {
            $check = PMA_check_indexes($tbl_name);
            if (!empty($check)) {
                ?>
<table border="0" cellpadding="2" cellspacing="0">
    <tr>
        <td class="tblHeaders" colspan="7"><?php 
                printf($strIndexWarningTable, urldecode($tbl_name));
                ?>
</td>
    </tr>
    <?php 
                echo $check;
                ?>
</table>
                <?php 
            }
Exemplo n.º 2
0
            $dontlimitchars = 0;
        }
        // hide edit and delete links for information_schema
        if (PMA_MYSQL_INT_VERSION >= 50002 && isset($db) && $db == 'information_schema') {
            $disp_mode = 'nnnn110111';
        }
        PMA_displayTable($result, $disp_mode, $analyzed_sql);
        PMA_DBI_free_result($result);
        // BEGIN INDEX CHECK See if indexes should be checked.
        if (isset($query_type) && $query_type == 'check_tbl' && isset($selected) && is_array($selected)) {
            foreach ($selected as $idx => $tbl_name) {
                $indexes = $indexes_info = $indexes_data = array();
                $tbl_ret_keys = PMA_get_indexes(urldecode($tbl_name), $err_url_0);
                PMA_extract_indexes($tbl_ret_keys, $indexes, $indexes_info, $indexes_data);
                $idx_collection = PMA_show_indexes(urldecode($tbl_name), $indexes, $indexes_info, $indexes_data, false);
                $check = PMA_check_indexes($idx_collection);
                if (!empty($check)) {
                    ?>
<table border="0" cellpadding="2" cellspacing="0">
    <tr>
        <td class="tblHeaders" colspan="7"><?php 
                    printf($strIndexWarningTable, urldecode($tbl_name));
                    ?>
</td>
    </tr>
    <?php 
                    echo $check;
                    ?>
</table>
                <?php 
                }
Exemplo n.º 3
0
        ?>
</th>
            <th colspan="2"><?php 
        echo $strAction;
        ?>
</th>
            <th colspan="2"><?php 
        echo $strField;
        ?>
</th>
        </tr>
        </thead>
        <tbody>
        <?php 
        $idx_collection = PMA_show_indexes($table, $indexes, $indexes_info, $indexes_data, true);
        echo PMA_check_indexes($ret_keys);
    } else {
        // none indexes
        echo '<tbody>' . '<tr><td colspan="7"><div class="warning">' . $strNoIndex . '</div></td></tr>' . "\n";
    }
    ?>

    <tr class="tblFooters"><td colspan="7">
    <?php 
    echo sprintf($strCreateIndex, '<input type="text" size="2" name="idx_num_fields" value="1" />');
    ?>
    <input type="submit" name="create_index" value="<?php 
    echo $strGo;
    ?>
"
        onclick="return checkFormElementInRange(this.form,