Example #1
0
    echo urlencode('DROP DATABASE ' . PMA_backquote($db));
    ?>
&amp;zero_rows=<?php 
    echo urlencode(sprintf($strDatabaseHasBeenDropped, htmlspecialchars(PMA_backquote($db))));
    ?>
&amp;goto=main.php&amp;back=db_details.php&amp;reload=1"
            onclick="return confirmLink(this, 'DROP DATABASE <?php 
    echo PMA_jsFormat($db);
    ?>
')">
            <?php 
    echo sprintf($strDropDB, htmlspecialchars($db));
    ?>
</a>
        <?php 
    echo PMA_showDocuShort('D/R/DROP_DATABASE.html') . "\n";
    ?>
    </li>
    <?php 
}
echo "\n";
?>

</ul>


<?php 
/**
 * Displays the footer
 */
echo "\n";
Example #2
0
        <tr>
            <td valign="baseline"><img src="<?php 
            echo $item_img;
            ?>
" width="7" height="7" alt="item" /></td>
            <td>
                <a href="user_details.php?<?php 
            echo $common_url_query;
            ?>
&amp;db=mysql&amp;table=user">
                    <?php 
            echo $strUsers;
            ?>
</a>&nbsp;
                <?php 
            echo PMA_showDocuShort('P/r/Privilege_system.html') . "\n";
            ?>
            </td>
        </tr>
            <?php 
            if (PMA_MYSQL_INT_VERSION >= 32303) {
                echo "\n";
                ?>
        <tr>
            <td valign="baseline"><img src="<?php 
                echo $item_img;
                ?>
" width="7" height="7" alt="item" /></td>
            <td>
                <a href="db_stats.php?<?php 
                echo $common_url_query;
        echo $strTableMaintenance;
        ?>
&nbsp;:&nbsp;
        <a href="sql.php?<?php 
        echo $url_query;
        ?>
&amp;sql_query=<?php 
        echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table));
        ?>
">
            <?php 
        echo $strOptimizeTable;
        ?>
</a>&nbsp;
        <?php 
        echo PMA_showDocuShort('O/P/OPTIMIZE_TABLE.html') . "\n";
        ?>
        </div>
    </li>
    <?php 
        echo "\n";
    }
}
// end 3.23.06 < MySQL < 3.23.22
// Referential integrity check
if (!empty($cfgServer['relation'])) {
    $local_query = 'SELECT src_column, dest_table, dest_column' . ' FROM ' . $cfgServer['relation'] . ' WHERE src_table =\'' . $table . '\';';
    // we need this mysql_select_db if the user has access to more than one db
    // and $db is not the last of the list, because PMA_availableDatabases()
    // has made a mysql_select_db() on the last one
    mysql_select_db($db);
Example #4
0
        <td><input type="text" name="column_name" /></td>
        <td><?php 
echo $strIfYouWish;
?>
</td>
    </tr>
<?php 
// 2002/2/22 appended by Y.Kawada: Kanji encoding convert controls
if (function_exists('PMA_set_enc_form')) {
    echo '    <tr>' . "\n" . '        <td>' . $strKanjiEncodConvert . '</td>' . "\n" . '        <td colspan=2>' . "\n" . PMA_set_enc_form('            ') . '        </td>' . "\n" . '    </tr>' . "\n";
}
// end if
?>
    <tr>
        <td colspan="3" align="center"><?php 
print PMA_showDocuShort('L/O/LOAD_DATA.html');
?>
</td>
    </tr>
    <tr>
        <td colspan="3" align="center">
            <input type="hidden" name="lang" value="<?php 
echo $lang;
?>
" />
            <input type="hidden" name="server" value="<?php 
echo $server;
?>
" />
            <input type="hidden" name="db" value="<?php 
echo $db;
Example #5
0
/**
 * Displays the page for "normal" operations
 *
 * @return  boolean  always true
 *
 * @global  string   the current language
 * @global  integer  the server to use (refers to the number in the
 *                   configuration file)
 *
 * @see     PMA_tablePrivileges()
 */
function PMA_normalOperations()
{
    global $lang, $server;
    ?>

<ul>

    <li>
        <div style="margin-bottom: 10px">
        <a href="user_details.php?lang=<?php 
    echo $lang;
    ?>
&amp;server=<?php 
    echo $server;
    ?>
&amp;db=mysql&amp;table=user&amp;mode=reload">
            <?php 
    echo $GLOBALS['strReloadMySQL'];
    ?>
</a>&nbsp;
        <?php 
    echo PMA_showDocuShort('F/L/FLUSH.html') . "\n";
    ?>
        </div>
    </li>

    <li>
        <form name="dbPrivForm" action="user_details.php" method="post">
            <?php 
    echo $GLOBALS['strCheckDbPriv'] . "\n";
    ?>
            <table>
            <tr>
                <td>
                    <?php 
    echo $GLOBALS['strDatabase'];
    ?>
&nbsp;:&nbsp;
                    <select name="db">
    <?php 
    echo "\n";
    $result = mysql_query('SHOW DATABASES');
    if (@mysql_num_rows($result)) {
        while ($row = mysql_fetch_row($result)) {
            echo '                        ';
            echo '<option value="' . str_replace('"', '&quot;', $row[0]) . '">' . htmlspecialchars($row[0]) . '</option>' . "\n";
        }
        // end while
    }
    // end if
    ?>
                    </select>
                    <input type="hidden" name="lang" value="<?php 
    echo $lang;
    ?>
" />
                    <input type="hidden" name="server" value="<?php 
    echo $server;
    ?>
" />
                    <input type="hidden" name="check" value="1" />
                    <input type="submit" value="<?php 
    echo $GLOBALS['strGo'];
    ?>
" />
                </td>
            </tr>
            </table>
        </form>
    </li>

    <li>
        <form action="user_details.php" method="post" name="addUserForm" onsubmit="return checkAddUser()">
            <?php 
    echo $GLOBALS['strAddUser'] . "\n";
    ?>
            <table>
            <tr>
                <td>
                    <input type="radio" name="anyhost" id="radio_anyhost0" checked="checked" />
                    <label for="radio_anyhost0"><?php 
    echo $GLOBALS['strAnyHost'];
    ?>
</label>
                </td>
                <td>&nbsp;</td>
                <td>
                    <input type="radio" name="anyhost" id="radio_anyhost1" />
                    <label for="radio_anyhost1"><?php 
    echo $GLOBALS['strHost'];
    ?>
</label>&nbsp;:&nbsp;
                </td>
                <td>
                    <input type="text" name="host" size="10" class="textfield" <?php 
    echo $GLOBALS['chg_evt_handler'];
    ?>
="this.form.anyhost[1].checked = true" />
                </td>
            </tr>
            <tr>
                <td>
                    <input type="radio" name="anyuser" id="radio_anyuser0" />
                    <label for="radio_anyuser0"><?php 
    echo $GLOBALS['strAnyUser'];
    ?>
</label>
                </td>
                <td>&nbsp;</td>
                <td>
                    <input type="radio" name="anyuser" id="radio_anyuser1" checked="checked" />
                    <label for="radio_anyuser1"><?php 
    echo $GLOBALS['strUserName'];
    ?>
</label>&nbsp;:&nbsp;
                </td>
                <td>
                    <input type="text" name="pma_user" size="10" class="textfield" <?php 
    echo $GLOBALS['chg_evt_handler'];
    ?>
="this.form.anyuser[1].checked = true" />
                </td>
            </tr>
            <tr>
                <td>
                    <input type="radio" name="nopass" value="1" id="radio_nopass1" onclick="pma_pw.value = ''; pma_pw2.value = ''; this.checked = true" />
                    <label for="radio_nopass1"><?php 
    echo $GLOBALS['strNoPassword'];
    ?>
</label>
                </td>
                <td>&nbsp;</td>
                <td>
                    <input type="radio" name="nopass" value="0" id="radio_nopass0" checked="checked" />
                    <label for="radio_nopass0"><?php 
    echo $GLOBALS['strPassword'];
    ?>
</label>&nbsp;:&nbsp;
                </td>
                <td>
                    <input type="password" name="pma_pw" size="10" class="textfield" <?php 
    echo $GLOBALS['chg_evt_handler'];
    ?>
="nopass[1].checked = true" />
                    &nbsp;&nbsp;
                    <?php 
    echo $GLOBALS['strReType'];
    ?>
&nbsp;:&nbsp;
                    <input type="password" name="pma_pw2" size="10" class="textfield" <?php 
    echo $GLOBALS['chg_evt_handler'];
    ?>
="nopass[1].checked = true" />
                </td>
            </tr>
            <tr>
                <td colspan="4">
                    <br />
                    <?php 
    echo $GLOBALS['strPrivileges'];
    ?>
&nbsp;:
                    <br />
                </td>
            </tr>
            </table>
    <?php 
    echo "\n";
    PMA_tablePrivileges('addUserForm');
    ?>
            <input type="hidden" name="lang" value="<?php 
    echo $lang;
    ?>
" />
            <input type="hidden" name="server" value="<?php 
    echo $server;
    ?>
" />
            <input type="submit" name="submit_addUser" value="<?php 
    echo $GLOBALS['strGo'];
    ?>
" />
        </form>
    </li>

</ul>
    <?php 
    return TRUE;
}
Example #6
0
        echo $strLimitNumRows . "\n";
        ?>
            <input type="text" size="4" name="session_max_rows" value="<?php 
        echo $cfgMaxRows;
        ?>
" class="textfield" />
            </div>
        </li>
        <li>
            <?php 
        echo $strAddSearchConditions;
        ?>
<br />
            <input type="text" name="where" class="textfield" />&nbsp;
            <?php 
        echo PMA_showDocuShort('F/u/Functions.html') . "\n";
        ?>
            <br /><br />
            <?php 
        echo '<i>' . $strOr . '</i> ' . $strDoAQuery;
        ?>
<br />
            <table border="<?php 
        echo $cfgBorder;
        ?>
">
            <tr>
                <th><?php 
        echo $strField;
        ?>
</th>
    </table>
    <br />
    <?php 
}
echo "\n";
// END - Table Type - 2 May 2001 - Robbat2
?>

<input type="submit" name="submit" value="<?php 
echo $strSave;
?>
" />
</form>

<table>
<tr>
    <td valign="top">*&nbsp;</td>
    <td>
        <?php 
echo $strSetEnumVal . "\n";
?>
    </td>
</tr>
</table>
<br />

<center><?php 
echo PMA_showDocuShort('C/R/CREATE_TABLE.html');
?>
</center>
Example #8
0
        <input type="hidden" name="server" value="<?php 
        echo $server;
        ?>
" />
        <input type="hidden" name="db" value="<?php 
        echo $db;
        ?>
" />
        <input type="hidden" name="table" value="<?php 
        echo $table;
        ?>
" />
    <?php 
        echo "\n";
        echo '        ' . $strIndexes . '&nbsp;:' . "\n";
        echo '        ' . PMA_showDocuShort('O/p/Optimising_Database_Structure.html') . '<br />' . "\n";
        if ($idx_cnt > 0) {
            ?>
        <table border="<?php 
            echo $cfgBorder;
            ?>
">
        <tr>
            <th><?php 
            echo $strKeyname;
            ?>
</th>
            <th><?php 
            echo $strType;
            ?>
</th>