display_export.lib.php

php绿色服务器,让大家试用greenamp

                        <label for="checkbox_sql_use_relation"><?php echo $strRelations; ?></label><br />
<?php
    } // end relation
    if (!empty($cfgRelation['commwork'])) {
?>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="sql_comments" value="yes" id="checkbox_sql_use_comments" <?php PMA_exportCheckboxCheck('sql_comments'); ?> style="vertical-align: middle" />
                        <label for="checkbox_sql_use_comments"><?php echo $strComments; ?></label><br />
<?php
    } // end comments
    if ($cfgRelation['mimework']) {
?>
                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="sql_mime" value="yes" id="checkbox_sql_use_mime" <?php PMA_exportCheckboxCheck('sql_mime'); ?> style="vertical-align: middle" />
                        <label for="checkbox_sql_use_mime"><?php echo $strMIME_MIMEtype; ?></label><br />
<?php
    } // end MIME
?>
                    </td>
                </tr>
<?php
} // end STRUCTURE
?>

                <!-- For data -->
                <tr>
                    <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                        <input type="checkbox" name="sql_data" value="data" id="checkbox_sql_data" <?php PMA_exportCheckboxCheck('sql_data'); ?> onclick="if (!this.checked &amp;&amp; (!getElement('checkbox_sql_structure') || !getElement('checkbox_sql_structure').checked)) return false; else return true;" style="vertical-align: middle" />
                        <label for="checkbox_sql_data"><b><?php echo $strData; ?>:</b></label><br />

                        &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" <?php PMA_exportCheckboxCheck('sql_columns'); ?> style="vertical-align: middle" />
                        <label for="checkbox_dump_showcolumns"><?php echo $strCompleteInserts; ?></label><br />

                        &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="extended_ins" value="yes" id="checkbox_dump_extended_ins" <?php PMA_exportCheckboxCheck('sql_extended'); ?> style="vertical-align: middle" />
                        <label for="checkbox_dump_extended_ins"><?php echo $strExtendedInserts; ?></label><br />

                        &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="delayed" value="yes" id="checkbox_dump_delayed" <?php PMA_exportCheckboxCheck('sql_delayed'); ?> style="vertical-align: middle" />
                        <label for="checkbox_dump_delayed"><?php echo $strDelayedInserts; ?></label><br />

                        &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="sql_ignore" value="yes" id="checkbox_dump_ignore" <?php PMA_exportCheckboxCheck('sql_ignore'); ?> style="vertical-align: middle" />
                        <label for="checkbox_dump_ignore"><?php echo $strIgnoreInserts; ?></label><br />

                        &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="hexforbinary" value="yes" id="checkbox_hexforbinary" <?php PMA_exportCheckboxCheck('sql_hex_for_binary'); ?> style="vertical-align: middle" />
                        <label for="checkbox_hexforbinary"><?php echo $strHexForBinary; ?></label><br />

                        <label for="select_sql_type"><?php echo $strSQLExportType; ?>:&nbsp;</label>
                        <select name="sql_type" id="select_sql_type" style="vertical-align: middle">
                            <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>
                    </td>
                </tr>
                </table>
            </div>
<?php
} // end SQL-OPTIONS
?>

            <!-- LaTeX options -->
            <div id="latex_options">
            <table width="400" border="0" cellpadding="3" cellspacing="1">
                <tr><th align="left"><?php echo $strLaTeXOptions; ?></th></tr>
                <tr>
                    <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                        <input type="checkbox" name="latex_caption" value="yes" id="checkbox_latex_show_caption" <?php PMA_exportCheckboxCheck('latex_caption'); ?> style="vertical-align: middle" />
                        <label for="checkbox_latex_show_caption"><?php echo $strLatexIncludeCaption; ?></label><br />
                    </td>
                </tr>

<?php if (!$hide_structure) { ?>
                <!-- For structure -->
                <tr>
                    <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                    <input type="checkbox" name="latex_structure" value="structure" id="checkbox_latex_structure" <?php PMA_exportCheckboxCheck('latex_structure'); ?> onclick="if (!this.checked &amp;&amp; !getElement('checkbox_latex_data').checked) return false; else return true;" style="vertical-align: middle" />
                    <label for="checkbox_latex_structure"><b><?php echo $strStructure; ?></b></label><br />
                    <table border="0" cellspacing="1" cellpadding="0">
                        <tr>
                            <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
                            <td><?php echo $strLatexCaption; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_structure_caption" size="30" value="<?php echo $strLatexStructure; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td><?php echo $strLatexContinuedCaption; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_structure_continued_caption" size="30" value="<?php echo $strLatexStructure . ' ' . $strLatexContinued; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td><?php echo $strLatexLabel; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_structure_label" size="30" value="<?php echo $cfg['Export']['latex_structure_label']; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                    </table>
<?php
    if (!empty($cfgRelation['relation'])) {
?>
                    &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="latex_relation" value="yes" id="checkbox_latex_use_relation" <?php PMA_exportCheckboxCheck('latex_relation'); ?> style="vertical-align: middle" />
                    <label for="checkbox_latex_use_relation"><?php echo $strRelations; ?></label><br />
<?php
    } // end relation
    if ($cfgRelation['commwork']) {
?>
                    &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="latex_comments" value="yes" id="checkbox_latex_use_comments" <?php PMA_exportCheckboxCheck('latex_comments'); ?> style="vertical-align: middle" />
                    <label for="checkbox_latex_use_comments"><?php echo $strComments; ?></label><br />
<?php
    } // end comments
    if ($cfgRelation['mimework']) {
?>
                    &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="latex_mime" value="yes" id="checkbox_latex_use_mime" <?php PMA_exportCheckboxCheck('latex_mime'); ?> style="vertical-align: middle" />
                    <label for="checkbox_latex_use_mime"><?php echo $strMIME_MIMEtype; ?></label><br />
<?php
    } // end MIME
?>
                </td>
            </tr>
<?php
} // end STRUCTURE
?>
            <!-- For data -->
            <tr>
                <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                    <input type="checkbox" name="latex_data" value="data" id="checkbox_latex_data" <?php PMA_exportCheckboxCheck('latex_data'); ?> onclick="if (!this.checked &amp;&amp; (!getElement('checkbox_latex_structure') || !getElement('checkbox_latex_structure').checked)) return false; else return true;" style="vertical-align: middle" />
                    <label for="checkbox_latex_data"><b><?php echo $strData; ?>:</b></label><br />
                    &nbsp;&nbsp;&nbsp;&nbsp;<input type="checkbox" name="latex_showcolumns" value="yes" id="ch_latex_showcolumns" <?php PMA_exportCheckboxCheck('latex_columns'); ?> style="vertical-align: middle" />
                    <label for="ch_latex_showcolumns"><?php echo $strColumnNames; ?></label><br />
                    <table border="0" cellspacing="1" cellpadding="0">
                        <tr>
                            <td>&nbsp;&nbsp;&nbsp;&nbsp;</td>
                            <td><?php echo $strLatexCaption; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_data_caption" size="30" value="<?php echo $strLatexContent; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td><?php echo $strLatexContinuedCaption; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_data_continued_caption" size="30" value="<?php echo $strLatexContent . ' ' . $strLatexContinued; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td><?php echo $strLatexLabel; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_data_label" size="30" value="<?php echo $cfg['Export']['latex_data_label']; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                        <tr>
                            <td>&nbsp;</td>
                            <td><?php echo $strReplaceNULLBy; ?>&nbsp;</td>
                            <td>
                                <input type="text" name="latex_replace_null" size="20" value="<?php echo $cfg['Export']['latex_null']; ?>" class="textfield" style="vertical-align: middle" />
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            </table>
            </div>

            <!-- CSV options -->
            <div id="csv_options">
            <table width="400" border="0" cellpadding="3" cellspacing="1">
                <tr><th align="left">
                    <?php echo $strCSVOptions; ?><input type="hidden" name="csv_data" value="csv_data" />
                </th></tr>
                <tr>
                    <td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                    <table border="0" cellspacing="1" cellpadding="0">
                    <tr>
                        <td>
                            <?php echo $strFieldsTerminatedBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="separator" size="2" value="<?php echo $cfg['Export']['csv_separator']; ?>" class="textfield" style="vertical-align: middle" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <?php echo $strFieldsEnclosedBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="enclosed" size="2" value="<?php echo $cfg['Export']['csv_enclosed']; ?>" class="textfield" style="vertical-align: middle" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <?php echo $strFieldsEscapedBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="escaped" size="2" value="<?php echo $cfg['Export']['csv_escaped']; ?>" class="textfield" style="vertical-align: middle" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <?php echo $strLinesTerminatedBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="add_character" size="2" value="<?php if ($cfg['Export']['csv_terminated'] == 'AUTO') echo ((PMA_whichCrlf() == "\n") ? '\n' : '\r\n'); else echo $cfg['Export']['csv_terminated']; ?>" class="textfield" style="vertical-align: middle" />
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <?php echo $strReplaceNULLBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="csv_replace_null" size="20" value="<?php echo $cfg['Export']['csv_null']; ?>" class="textfield" style="vertical-align: middle" />
                        </td>
                    </tr>
                </table>
                <input type="checkbox" name="showcsvnames" value="yes" id="checkbox_dump_showcsvnames" <?php PMA_exportCheckboxCheck('csv_columns'); ?> style="vertical-align: middle" />
                <label for="checkbox_dump_showcsvnames"><?php echo $strPutColNames; ?></label>
            </td>
        </tr>
        </table>
        </div>

        <!-- Excel options -->
        <div id="excel_options">
        <table width="400" border="0" cellpadding="3" cellspacing="1">
                <tr><th align="left">
                    <?php echo $strExcelOptions; ?>
                    <input type="hidden" name="excel_data" value="excel_data" />
                </th></tr>
                <tr><td bgcolor="<?php echo $cfg['BgcolorOne']; ?>">
                <table border="0" cellspacing="1" cellpadding="0">
                    <tr>
                        <td>
                            <?php echo $strReplaceNULLBy; ?>&nbsp;
                        </td>
                        <td>
                            <input type="text" name="excel_replace_null" size="20" value="<?php echo $cfg['Export']['excel_null']; ?>" class="textfield" style="vertical-align: middle" />