display_export.lib.php

一个用PHP编写的

    <legend><?php echo $strExcelOptions; ?></legend>

    <table>
    <tr><td><label for="excel_replace_null">
                <?php echo $strReplaceNULLBy; ?></label>
        </td>
        <td><input type="text" name="excel_replace_null" size="20"
                id="excel_replace_null"
                value="<?php echo $cfg['Export']['excel_null']; ?>" />
        </td>
    </tr>
    <tr><td><label for="select_excel_edition">
                <?php echo $strExcelEdition; ?>:
            </label>
        </td>
        <td><select name="excel_edition" id="select_excel_edition">
                <option value="win"<?php echo $cfg['Export']['excel_edition'] == 'win' ? ' selected="selected"' : ''; ?>>Windows</option>
                <option value="mac"<?php echo $cfg['Export']['excel_edition'] == 'mac' ? ' selected="selected"' : ''; ?>>Excel 2003 / Macintosh</option>
            </select>
        </td>
    </tr>
    </table>

    <input type="checkbox" name="showexcelnames" value="yes"
        id="checkbox_dump_showexcelnames"
        <?php PMA_exportCheckboxCheck('excel_columns'); ?> />
    <label for="checkbox_dump_showexcelnames">
        <?php echo $strPutColNames; ?></label>
</fieldset>

<?php /* HTML Excel options */ ?>
<fieldset id="htmlexcel_options">
    <input type="hidden" name="htmlexcel_data" value="htmlexcel_data" />
    <legend><?php echo $strHTMLExcelOptions; ?></legend>

    <div class="formelementrow">
        <label for="htmlexcel_replace_null"><?php echo $strReplaceNULLBy; ?></label>
        <input type="text" name="htmlexcel_replace_null" size="20"
            value="<?php echo $cfg['Export']['htmlexcel_null']; ?>"
            id="htmlexcel_replace_null" />
    </div>

    <div class="formelementrow">
        <input type="checkbox" name="htmlexcel_shownames" value="yes"
            id="checkbox_dump_htmlexcel_shownames"
            <?php PMA_exportCheckboxCheck('htmlexcel_columns'); ?> />
        <label for="checkbox_dump_htmlexcel_shownames">
            <?php echo $strPutColNames; ?></label>
    </div>
</fieldset>

<?php /* HTML Word options */ ?>
<fieldset id="htmlword_options">
    <legend><?php echo $strHTMLWordOptions; ?></legend>

    <div class="formelementrow">
        <input type="checkbox" name="htmlword_structure" value="structure"
            id="checkbox_htmlword_structure"
            <?php PMA_exportCheckboxCheck('htmlword_structure'); ?>
            onclick="
                if (!this.checked &amp;&amp; (!document.getElementById('checkbox_htmlword_data') || !document.getElementById('checkbox_htmlword_data').checked))
                    return false;
                else return true;" />
        <label for="checkbox_htmlword_structure">
            <?php echo $strStructure; ?></label>
    </div>

    <fieldset>
        <legend>
            <input type="checkbox" name="htmlword_data" value="data"
                id="checkbox_htmlword_data"
                <?php PMA_exportCheckboxCheck('htmlword_data'); ?>
                onclick="
                    if (!this.checked &amp;&amp; (!document.getElementById('checkbox_htmlword_structure') || !document.getElementById('checkbox_htmlword_structure').checked))
                        return false;
                    else return true;" />
            <label for="checkbox_htmlword_data">
                <?php echo $strData; ?></label>
        </legend>

        <div class="formelementrow">
            <label for="htmlword_replace_null">
                <?php echo $strReplaceNULLBy; ?></label>
            <input id="htmlword_replace_null" type="text" size="20"
                name="htmlword_replace_null"
                value="<?php echo $cfg['Export']['htmlword_null']; ?>" />
        </div>

        <div class="formelementrow">
            <input type="checkbox" name="htmlword_shownames" value="yes"
                id="checkbox_dump_htmlword_shownames"
                <?php PMA_exportCheckboxCheck('htmlword_columns'); ?> />
            <label for="checkbox_dump_htmlword_shownames">
                <?php echo $strPutColNames; ?></label>
        </div>
    </fieldset>
</fieldset>

<?php if ( $xls ) { /* Native Excel options */ ?>
<fieldset id="xls_options">
    <input type="hidden" name="xls_data" value="xls_data" />
    <legend><?php echo $strExcelOptions; ?></legend>

    <div class="formelementrow">
        <label for="xls_replace_null"><?php echo $strReplaceNULLBy; ?></label>
        <input type="text" name="xls_replace_null" size="20"
            value="<?php echo $cfg['Export']['xls_null']; ?>"
            id="xls_replace_null" />
    </div>

    <div class="formelementrow">
        <input type="checkbox" name="xls_shownames" value="yes"
            id="checkbox_dump_xls_shownames"
            <?php PMA_exportCheckboxCheck('xls_columns'); ?> />
        <label for="checkbox_dump_xls_shownames">
            <?php echo $strPutColNames; ?></label>
    </div>
</fieldset>
<?php } /* end if ( $xls ) */ ?>

<?php /* PDF options */ ?>
<fieldset id="pdf_options">
    <input type="hidden" name="pdf_data" value="pdf_data" />
    <legend><?php echo $strPDFOptions; ?></legend>

    <div class="formelementrow">
        <label for="pdf_report_title"><?php echo $strPDFReportTitle; ?></label>
        <input type="text" name="pdf_report_title" size="50"
            value="<?php echo $cfg['Export']['pdf_report_title']; ?>"
            id="pdf_report_title" />
    </div>
</fieldset>

<fieldset id="none_options">
    <legend><?php echo $strXML; ?></legend>
    <?php echo $strNoOptions; ?>
    <input type="hidden" name="xml_data" value="xml_data" />
</fieldset>

</td></tr></table>

<script type="text/javascript" language="javascript">
//<![CDATA[
    show_checked_option();
//]]>
</script>

<?php if ( isset($table) && strlen($table) && ! isset( $num_tables ) ) { ?>
    <div class="formelementrow">
        <?php
        echo sprintf( $strDumpXRows,
            '<input type="text" name="limit_to" size="5" value="'
            . ( isset( $unlim_num_rows ) ? $unlim_num_rows : PMA_countRecords( $db, $table, TRUE ) )
            . '" onfocus="this.select()" />',
            '<input type="text" name="limit_from" value="0" size="5"'
            .' onfocus="this.select()" /> ');
        ?>
    </div>
<?php } ?>
</fieldset>

<fieldset>
    <legend>
        <input type="checkbox" name="asfile" value="sendit"
            id="checkbox_dump_asfile" <?php PMA_exportCheckboxCheck('asfile'); ?> />
        <label for="checkbox_dump_asfile"><?php echo $strSend; ?></label>
    </legend>

    <?php if (isset($cfg['SaveDir']) && !empty($cfg['SaveDir'])) { ?>
    <input type="checkbox" name="onserver" value="saveit"
        id="checkbox_dump_onserver"
        onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
        <?php PMA_exportCheckboxCheck('onserver'); ?> />
    <label for="checkbox_dump_onserver">
        <?php echo sprintf($strSaveOnServer, htmlspecialchars(PMA_userDir($cfg['SaveDir']))); ?>
    </label>,<br />
    <input type="checkbox" name="onserverover" value="saveitover"
        id="checkbox_dump_onserverover"
        onclick="document.getElementById('checkbox_dump_onserver').checked = true;
            document.getElementById('checkbox_dump_asfile').checked = true;"
        <?php PMA_exportCheckboxCheck('onserver_overwrite'); ?> />
    <label for="checkbox_dump_onserverover">
        <?php echo $strOverwriteExisting; ?></label>
    <br />
    <?php } ?>

    <label for="filename_template">
        <?php echo $strFileNameTemplate; ?>
        <sup>(1)</sup></label>:
    <input type="text" name="filename_template" id="filename_template"
    <?php
        echo ' value="';
        if ($export_type == 'database') {
            if (isset($_COOKIE) && !empty($_COOKIE['pma_db_filename_template'])) {
                echo $_COOKIE['pma_db_filename_template'];
            } else {
                echo $GLOBALS['cfg']['Export']['file_template_database'];
            }
        } elseif ($export_type == 'table') {
            if (isset($_COOKIE) && !empty($_COOKIE['pma_table_filename_template'])) {
                echo $_COOKIE['pma_table_filename_template'];
            } else {
                echo $GLOBALS['cfg']['Export']['file_template_table'];
            }
        } else {
            if (isset($_COOKIE) && !empty($_COOKIE['pma_server_filename_template'])) {
                echo $_COOKIE['pma_server_filename_template'];
            } else {
                echo $GLOBALS['cfg']['Export']['file_template_server'];
            }
        }
        echo '" />';
    ?>

    (
    <input type="checkbox" name="remember_template"
        id="checkbox_remember_template"
        <?php PMA_exportCheckboxCheck('remember_file_template'); ?> />
    <label for="checkbox_remember_template">
        <?php echo $strFileNameTemplateRemember; ?></label>
    )

    <div class="formelementrow">
    <?php
    // charset of file
    if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
        echo '        <label for="select_charset_of_file">'
            . $strCharsetOfFile . '</label>' . "\n";

        $temp_charset = reset($cfg['AvailableCharsets']);
        echo '        <select id="select_charset_of_file" name="charset_of_file" size="1">' . "\n";
        foreach ($cfg['AvailableCharsets'] as $key => $temp_charset) {
            echo '            <option value="' . $temp_charset . '"';
            if ((empty($cfg['Export']['charset']) && $temp_charset == $charset)
              || $temp_charset == $cfg['Export']['charset']) {
                echo ' selected="selected"';
            }
            echo '>' . $temp_charset . '</option>' . "\n";
        } // end foreach
        echo '        </select>';
    } // end if
    ?>
    </div>

<?php
// zip, gzip and bzip2 encode features
$is_zip  = ( $cfg['ZipDump']  && @function_exists('gzcompress') );
$is_gzip = ( $cfg['GZipDump'] && @function_exists('gzencode') );
$is_bzip = ( $cfg['BZipDump'] && @function_exists('bzcompress') );

if ( $is_zip || $is_gzip || $is_bzip ) { ?>
    <div class="formelementrow">
        <?php echo $strCompression; ?>:
        <input type="radio" name="compression" value="none"
            id="radio_compression_none"
            onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
            <?php PMA_exportIsActive('compression', 'none'); ?> />
        <label for="radio_compression_none"><?php echo $strNone; ?></label>
    <?php
    if ($is_zip) { ?>
        <input type="radio" name="compression" value="zip"
            id="radio_compression_zip"
            onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
            <?php PMA_exportIsActive('compression', 'zip'); ?> />
        <label for="radio_compression_zip"><?php echo $strZip; ?></label>
    <?php } if ($is_gzip) { ?>
        <input type="radio" name="compression" value="gzip"
            id="radio_compression_gzip"
            onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
            <?php PMA_exportIsActive('compression', 'gzip'); ?> />
        <label for="radio_compression_gzip"><?php echo $strGzip; ?></label>
    <?php } if ($is_bzip) { ?>
        <input type="radio" name="compression" value="bzip"
            id="radio_compression_bzip"
            onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
            <?php PMA_exportIsActive('compression', 'bzip2'); ?> />
        <label for="radio_compression_bzip"><?php echo $strBzip; ?></label>
    <?php } ?>
    </div>
<?php } else { ?>
    <input type="hidden" name="compression" value="none" />
<?php } ?>
</fieldset>

<?php if (function_exists('PMA_set_enc_form')) { ?>
<!-- Encoding setting form appended by Y.Kawada -->
<!-- Japanese encoding setting -->
<fieldset>
<?php echo PMA_set_enc_form('            '); ?>
</fieldset>
<?php } ?>

<fieldset class="tblFooters">
    <input type="submit" value="<?php echo $strGo; ?>" id="buttonGo" />
</fieldset>
</form>

<div class="notice">
    <sup id="FileNameTemplateHelp">(1)</sup>
    <?php
    $trans = '__SERVER__/' . $strFileNameTemplateDescriptionServer;
    if ($export_type == 'database' || $export_type == 'table') {
        $trans .= ', __DB__/' . $strFileNameTemplateDescriptionDatabase;
    }
    if ($export_type == 'table') {
        $trans .= ', __TABLE__/' . $strFileNameTemplateDescriptionTable;
    }
    echo sprintf($strFileNameTemplateDescription,
        '<a href="http://www.php.net/strftime" target="documentation" title="'
        . $strDocu . '">', '</a>', $trans); ?>
</div>