display_export.lib.php

一个用PHP编写的

        <?php echo PMA_showMySQLDocu('manual_MySQL_Database_Administration',
            'Server_SQL_mode') . "\n";
    } ?>
<?php if ( $export_type == 'server' ) { /* For databases */ ?>
    <fieldset>
        <legend><?php echo $strDatabaseExportOptions; ?></legend>
        <input type="checkbox" name="drop_database" value="yes"
            id="checkbox_drop_database"
            <?php PMA_exportCheckboxCheck('sql_drop_database'); ?> />
        <label for="checkbox_drop_database">
            <?php echo $strAddDropDatabase; ?></label>
    </fieldset>
<?php } if ( ! $hide_structure ) { /* SQL structure */ ?>
    <fieldset>
        <legend>
            <input type="checkbox" name="sql_structure" value="structure"
                id="checkbox_sql_structure"
                <?php PMA_exportCheckboxCheck('sql_structure'); ?>
                onclick="
                    if (!this.checked &amp;&amp; !document.getElementById('checkbox_sql_data').checked)
                        return false;
                    else return true;" />
            <label for="checkbox_sql_structure">
                <?php echo $strStructure; ?></label>
        </legend>

        <input type="checkbox" name="drop" value="1" id="checkbox_dump_drop"
            <?php PMA_exportCheckboxCheck('sql_drop_table'); ?> />
        <label for="checkbox_dump_drop">
            <?php echo $strStrucDrop; ?></label><br />

        <input type="checkbox" name="if_not_exists" value="1"
            id="checkbox_dump_if_not_exists"
            <?php PMA_exportCheckboxCheck('sql_if_not_exists'); ?> />
        <label for="checkbox_dump_if_not_exists">
            <?php echo $strAddIfNotExists; ?></label><br />

        <input type="checkbox" name="sql_auto_increment" value="1"
            id="checkbox_auto_increment"
            <?php PMA_exportCheckboxCheck('sql_auto_increment'); ?> />
        <label for="checkbox_auto_increment">
            <?php echo $strAddAutoIncrement; ?></label><br />

        <input type="checkbox" name="use_backquotes" value="1"
            id="checkbox_dump_use_backquotes"
            <?php PMA_exportCheckboxCheck('sql_backquotes'); ?> />
        <label for="checkbox_dump_use_backquotes">
            <?php echo $strUseBackquotes; ?></label><br />

        <b><?php echo $strAddIntoComments; ?>:</b><br />

        <input type="checkbox" name="sql_dates" value="yes"
            id="checkbox_sql_dates"
            <?php PMA_exportCheckboxCheck('sql_dates'); ?> />
        <label for="checkbox_sql_dates">
            <?php echo $strCreationDates; ?></label><br />
<?php if (!empty($cfgRelation['relation'])) { ?>
        <input type="checkbox" name="sql_relation" value="yes"
            id="checkbox_sql_use_relation"
            <?php PMA_exportCheckboxCheck('sql_relation'); ?> />
        <label for="checkbox_sql_use_relation"><?php echo $strRelations; ?></label><br />
<?php } if (!empty($cfgRelation['commwork']) && PMA_MYSQL_INT_VERSION < 40100) { ?>
        <input type="checkbox" name="sql_comments" value="yes"
            id="checkbox_sql_use_comments"
            <?php PMA_exportCheckboxCheck('sql_comments'); ?> />
        <label for="checkbox_sql_use_comments"><?php echo $strComments; ?></label><br />
<?php } if ($cfgRelation['mimework']) { ?>
        <input type="checkbox" name="sql_mime" value="yes"
            id="checkbox_sql_use_mime"
            <?php PMA_exportCheckboxCheck('sql_mime'); ?> />
        <label for="checkbox_sql_use_mime"><?php echo $strMIME_MIMEtype; ?></label><br />
<?php } ?>
    </fieldset>
<?php
    } /* end SQL STRUCTURE */
/* SQL data */
?>
    <fieldset>
        <legend>
            <input type="checkbox" name="sql_data" value="data"
                id="checkbox_sql_data" <?php PMA_exportCheckboxCheck('sql_data'); ?>
                onclick="
                    if (!this.checked &amp;&amp; (!document.getElementById('checkbox_sql_structure') || !document.getElementById('checkbox_sql_structure').checked))
                        return false;
                    else return true;" />
            <label for="checkbox_sql_data">
                <?php echo $strData; ?></label>
        </legend>
        <input type="checkbox" name="showcolumns" value="yes"
            id="checkbox_dump_showcolumns"
            <?php PMA_exportCheckboxCheck('sql_columns'); ?> />
        <label for="checkbox_dump_showcolumns">
            <?php echo $strCompleteInserts; ?></label><br />

        <input type="checkbox" name="extended_ins" value="yes"
            id="checkbox_dump_extended_ins"
            <?php PMA_exportCheckboxCheck('sql_extended'); ?> />
        <label for="checkbox_dump_extended_ins">
            <?php echo $strExtendedInserts; ?></label><br />

        <label for="input_max_query_size">
            <?php echo $strMaximalQueryLength; ?>:</label>
        <input type="text" name="max_query_size" id="input_max_query_size"
            value="<?php echo $cfg['Export']['sql_max_query_size'];?>" /><br />

        <input type="checkbox" name="delayed" value="yes"
            id="checkbox_dump_delayed"
            <?php PMA_exportCheckboxCheck('sql_delayed'); ?> />
        <label for="checkbox_dump_delayed">
            <?php echo $strDelayedInserts; ?></label><br />

        <input type="checkbox" name="sql_ignore" value="yes"
            id="checkbox_dump_ignore"
            <?php PMA_exportCheckboxCheck('sql_ignore'); ?> />
        <label for="checkbox_dump_ignore">
            <?php echo $strIgnoreInserts; ?></label><br />

        <input type="checkbox" name="hexforbinary" value="yes"
            id="checkbox_hexforbinary"
            <?php PMA_exportCheckboxCheck('sql_hex_for_binary'); ?> />
        <label for="checkbox_hexforbinary">
            <?php echo $strHexForBinary; ?></label><br />

        <label for="select_sql_type">
            <?php echo $strSQLExportType; ?>:</label>
        <select name="sql_type" id="select_sql_type">
            <option value="insert"<?php echo $cfg['Export']['sql_type'] == 'insert' ? ' selected="selected"' : ''; ?>>INSERT</option>
            <option value="update"<?php echo $cfg['Export']['sql_type'] == 'update' ? ' selected="selected"' : ''; ?>>UPDATE</option>
            <option value="replace"<?php echo $cfg['Export']['sql_type'] == 'replace' ? ' selected="selected"' : ''; ?>>REPLACE</option>
        </select>
    </fieldset>
</fieldset>
    <?php
} // end SQL-OPTIONS
?>

<?php /* LaTeX options */ ?>
<fieldset id="latex_options">
    <legend><?php echo $strLaTeXOptions; ?></legend>

    <div class="formelementrow">
        <input type="checkbox" name="latex_caption" value="yes"
            id="checkbox_latex_show_caption"
            <?php PMA_exportCheckboxCheck('latex_caption'); ?> />
        <label for="checkbox_latex_show_caption">
            <?php echo $strLatexIncludeCaption; ?></label>
    </div>

<?php if ( ! $hide_structure ) { /* LaTeX structure */ ?>
    <fieldset>
        <legend>
            <input type="checkbox" name="latex_structure" value="structure"
                id="checkbox_latex_structure"
                <?php PMA_exportCheckboxCheck('latex_structure'); ?>
                onclick="
                    if (!this.checked &amp;&amp; !document.getElementById('checkbox_latex_data').checked)
                        return false;
                    else return true;" />
            <label for="checkbox_latex_structure">
                <?php echo $strStructure; ?></label>
        </legend>

        <table>
        <tr><td><label for="latex_structure_caption">
                    <?php echo $strLatexCaption; ?></label></td>
            <td><input type="text" name="latex_structure_caption" size="30"
                    value="<?php echo $strLatexStructure; ?>"
                    id="latex_structure_caption" />
            </td>
        </tr>
        <tr><td><label for="latex_structure_continued_caption">
                    <?php echo $strLatexContinuedCaption; ?></label></td>
            <td><input type="text" name="latex_structure_continued_caption"
                    value="<?php echo $strLatexStructure . ' ' . $strLatexContinued; ?>"
                    size="30" id="latex_structure_continued_caption" />
            </td>
        </tr>
        <tr><td><label for="latex_structure_label">
                    <?php echo $strLatexLabel; ?></label></td>
            <td><input type="text" name="latex_structure_label" size="30"
                    value="<?php echo $cfg['Export']['latex_structure_label']; ?>"
                    id="latex_structure_label" />
            </td>
        </tr>
        </table>

    <?php if ( ! empty( $cfgRelation['relation']) ) { ?>
        <input type="checkbox" name="latex_relation" value="yes"
            id="checkbox_latex_use_relation"
            <?php PMA_exportCheckboxCheck('latex_relation'); ?> />
        <label for="checkbox_latex_use_relation">
            <?php echo $strRelations; ?></label><br />
    <?php } if ( $cfgRelation['commwork'] ) { ?>
        <input type="checkbox" name="latex_comments" value="yes"
            id="checkbox_latex_use_comments"
            <?php PMA_exportCheckboxCheck('latex_comments'); ?> />
        <label for="checkbox_latex_use_comments">
            <?php echo $strComments; ?></label><br />
    <?php } if ( $cfgRelation['mimework'] ) { ?>
        <input type="checkbox" name="latex_mime" value="yes"
            id="checkbox_latex_use_mime"
            <?php PMA_exportCheckboxCheck('latex_mime'); ?> />
        <label for="checkbox_latex_use_mime">
            <?php echo $strMIME_MIMEtype; ?></label><br />
    <?php } ?>
    </fieldset>
    <?php
} // end LaTeX STRUCTURE
/* LaTeX data */
?>
    <fieldset>
        <legend>
            <input type="checkbox" name="latex_data" value="data"
                id="checkbox_latex_data"
                <?php PMA_exportCheckboxCheck('latex_data'); ?>
                onclick="
                    if (!this.checked &amp;&amp; (!document.getElementById('checkbox_latex_structure') || !document.getElementById('checkbox_latex_structure').checked))
                        return false;
                    else return true;" />
            <label for="checkbox_latex_data">
                <?php echo $strData; ?></label>
        </legend>
        <input type="checkbox" name="latex_showcolumns" value="yes"
            id="ch_latex_showcolumns"
            <?php PMA_exportCheckboxCheck('latex_columns'); ?> />
        <label for="ch_latex_showcolumns">
            <?php echo $strColumnNames; ?></label><br />
        <table>
        <tr><td><label for="latex_data_caption">
                    <?php echo $strLatexCaption; ?></label></td>
            <td><input type="text" name="latex_data_caption" size="30"
                    value="<?php echo $strLatexContent; ?>"
                    id="latex_data_caption" />
            </td>
        </tr>
        <tr><td><label for="latex_data_continued_caption">
                    <?php echo $strLatexContinuedCaption; ?></label></td>
            <td><input type="text" name="latex_data_continued_caption" size="30"
                    value="<?php echo $strLatexContent . ' ' . $strLatexContinued; ?>"
                    id="latex_data_continued_caption" />
            </td>
        </tr>
        <tr><td><label for="latex_data_label">
                    <?php echo $strLatexLabel; ?></label></td>
            <td><input type="text" name="latex_data_label" size="30"
                    value="<?php echo $cfg['Export']['latex_data_label']; ?>"
                    id="latex_data_label" />
            </td>
        </tr>
        <tr><td><label for="latex_replace_null">
                    <?php echo $strReplaceNULLBy; ?></label></td>
            <td><input type="text" name="latex_replace_null" size="20"
                    value="<?php echo $cfg['Export']['latex_null']; ?>"
                    id="latex_replace_null" />
            </td>
        </tr>
        </table>
    </fieldset>
</fieldset>

<?php /* CSV options */ ?>
<fieldset id="csv_options">
    <input type="hidden" name="csv_data" value="csv_data" />
    <legend><?php echo $strCSVOptions; ?></legend>

    <table>
    <tr><td><label for="export_separator">
                <?php echo $strFieldsTerminatedBy; ?></label></td>
        <td><input type="text" name="export_separator" size="2"
                id="export_separator"
                value="<?php echo $cfg['Export']['csv_separator']; ?>" />
        </td>
    </tr>
    <tr><td><label for="enclosed">
                <?php echo $strFieldsEnclosedBy; ?></label></td>
        <td><input type="text" name="enclosed" size="2"
                id="enclosed"
                value="<?php echo $cfg['Export']['csv_enclosed']; ?>" />
        </td>
    </tr>
    <tr><td><label for="escaped">
                <?php echo $strFieldsEscapedBy; ?></label></td>
        <td><input type="text" name="escaped" size="2"
                id="escaped"
                value="<?php echo $cfg['Export']['csv_escaped']; ?>" />
        </td>
    </tr>
    <tr><td><label for="add_character">
                <?php echo $strLinesTerminatedBy; ?></label></td>
        <td><input type="text" name="add_character" size="2"
                id="add_character"
                value="<?php if ($cfg['Export']['csv_terminated'] == 'AUTO') echo ((PMA_whichCrlf() == "\n") ? '\n' : '\r\n'); else echo $cfg['Export']['csv_terminated']; ?>" />
        </td>
    </tr>
    <tr><td><label for="csv_replace_null">
                <?php echo $strReplaceNULLBy; ?></label></td>
        <td><input type="text" name="csv_replace_null" size="20"
                id="csv_replace_null"
                value="<?php echo $cfg['Export']['csv_null']; ?>" />
        </td>
    </tr>
    </table>
    <input type="checkbox" name="showcsvnames" value="yes"
        id="checkbox_dump_showcsvnames"
        <?php PMA_exportCheckboxCheck('csv_columns'); ?>  />
    <label for="checkbox_dump_showcsvnames">
        <?php echo $strPutColNames; ?></label>
</fieldset>

<?php /* Excel options */ ?>
<fieldset id="excel_options">
    <input type="hidden" name="excel_data" value="excel_data" />