2
/* $Id: display_export.lib.php 9791 2006-12-13 13:02:42Z lem9 $ */
3
// vim: expandtab sw=4 ts=4 sts=4:
5
require_once './libraries/Table.class.php';
7
// Get relations & co. status
8
require_once('./libraries/relation.lib.php');
9
$cfgRelation = PMA_getRelationsParam();
12
require_once('./libraries/file_listing.php');
13
require_once('./libraries/plugin_interface.lib.php');
15
function PMA_exportCheckboxCheck($str) {
16
if (isset($GLOBALS['cfg']['Export'][$str]) && $GLOBALS['cfg']['Export'][$str]) {
17
echo ' checked="checked"';
21
function PMA_exportIsActive($what, $val) {
22
if (isset($GLOBALS['cfg']['Export'][$what]) && $GLOBALS['cfg']['Export'][$what] == $val) {
23
echo ' checked="checked"';
27
/* Scan for plugins */
28
$export_list = PMA_getPlugins('./libraries/export/', array('export_type' => $export_type, 'single_table' => isset($single_table)));
30
/* Fail if we didn't find any plugin */
31
if (empty($export_list)) {
32
$GLOBALS['show_error_header'] = TRUE;
33
PMA_showMessage($strCanNotLoadExportPlugins);
34
unset($GLOBALS['show_error_header']);
35
require('./libraries/footer.inc.php');
39
<form method="post" action="export.php" name="dump">
42
if ($export_type == 'server') {
43
echo PMA_generate_common_hidden_inputs('', '', 1);
44
} elseif ($export_type == 'database') {
45
echo PMA_generate_common_hidden_inputs($db, '', 1);
47
echo PMA_generate_common_hidden_inputs($db, $table, 1);
50
// just to keep this value for possible next display of this form after saving on server
51
if (isset($single_table)) {
52
echo '<input type="hidden" name="single_table" value="TRUE" />' . "\n";
55
echo '<input type="hidden" name="export_type" value="' . $export_type . '" />' . "\n";
57
if (isset($sql_query)) {
58
echo '<input type="hidden" name="sql_query" value="' . htmlspecialchars($sql_query) . '" />' . "\n";
60
echo PMA_pluginGetJavascript($export_list);
62
<fieldset id="fieldsetexport">
63
<legend><?php echo $export_page_title; ?></legend>
67
* this table is needed to fix rendering in Opera <= 9 and Safari <= 2
68
* normaly just the two fieldset would have float: left
73
<div id="div_container_exportoptions">
74
<fieldset id="exportoptions">
75
<legend><?php echo $strExport; ?></legend>
77
<?php if ( ! empty( $multi_values ) ) { ?>
78
<div class="formelementrow">
79
<?php echo $multi_values; ?>
82
<?php echo PMA_pluginGetChoice('Export', 'what', $export_list, 'format'); ?>
88
<div id="div_container_sub_exportoptions">
89
<?php echo PMA_pluginGetOptions('Export', $export_list); ?>
93
<script type="text/javascript" language="javascript">
99
<?php if ( isset($table) && strlen($table) && ! isset( $num_tables ) ) { ?>
100
<div class="formelementrow">
102
echo sprintf( $strDumpXRows,
103
'<input type="text" name="limit_to" size="5" value="'
104
. ( isset( $unlim_num_rows ) ? $unlim_num_rows : PMA_Table::countRecords( $db, $table, TRUE ) )
105
. '" onfocus="this.select()" />',
106
'<input type="text" name="limit_from" value="0" size="5"'
107
.' onfocus="this.select()" /> ');
115
<input type="checkbox" name="asfile" value="sendit"
116
id="checkbox_dump_asfile" <?php PMA_exportCheckboxCheck('asfile'); ?> />
117
<label for="checkbox_dump_asfile"><?php echo $strSend; ?></label>
120
<?php if (isset($cfg['SaveDir']) && !empty($cfg['SaveDir'])) { ?>
121
<input type="checkbox" name="onserver" value="saveit"
122
id="checkbox_dump_onserver"
123
onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
124
<?php PMA_exportCheckboxCheck('onserver'); ?> />
125
<label for="checkbox_dump_onserver">
126
<?php echo sprintf($strSaveOnServer, htmlspecialchars(PMA_userDir($cfg['SaveDir']))); ?>
128
<input type="checkbox" name="onserverover" value="saveitover"
129
id="checkbox_dump_onserverover"
130
onclick="document.getElementById('checkbox_dump_onserver').checked = true;
131
document.getElementById('checkbox_dump_asfile').checked = true;"
132
<?php PMA_exportCheckboxCheck('onserver_overwrite'); ?> />
133
<label for="checkbox_dump_onserverover">
134
<?php echo $strOverwriteExisting; ?></label>
138
<label for="filename_template">
139
<?php echo $strFileNameTemplate; ?>
140
<sup>(1)</sup></label>:
141
<input type="text" name="filename_template" id="filename_template"
144
if ($export_type == 'database') {
145
if (isset($_COOKIE) && !empty($_COOKIE['pma_db_filename_template'])) {
146
echo $_COOKIE['pma_db_filename_template'];
148
echo $GLOBALS['cfg']['Export']['file_template_database'];
150
} elseif ($export_type == 'table') {
151
if (isset($_COOKIE) && !empty($_COOKIE['pma_table_filename_template'])) {
152
echo $_COOKIE['pma_table_filename_template'];
154
echo $GLOBALS['cfg']['Export']['file_template_table'];
157
if (isset($_COOKIE) && !empty($_COOKIE['pma_server_filename_template'])) {
158
echo $_COOKIE['pma_server_filename_template'];
160
echo $GLOBALS['cfg']['Export']['file_template_server'];
167
<input type="checkbox" name="remember_template"
168
id="checkbox_remember_template"
169
<?php PMA_exportCheckboxCheck('remember_file_template'); ?> />
170
<label for="checkbox_remember_template">
171
<?php echo $strFileNameTemplateRemember; ?></label>
174
<div class="formelementrow">
177
if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
178
echo ' <label for="select_charset_of_file">'
179
. $strCharsetOfFile . '</label>' . "\n";
181
$temp_charset = reset($cfg['AvailableCharsets']);
182
echo ' <select id="select_charset_of_file" name="charset_of_file" size="1">' . "\n";
183
foreach ($cfg['AvailableCharsets'] as $key => $temp_charset) {
184
echo ' <option value="' . $temp_charset . '"';
185
if ((empty($cfg['Export']['charset']) && $temp_charset == $charset)
186
|| $temp_charset == $cfg['Export']['charset']) {
187
echo ' selected="selected"';
189
echo '>' . $temp_charset . '</option>' . "\n";
197
// zip, gzip and bzip2 encode features
198
$is_zip = ( $cfg['ZipDump'] && @function_exists('gzcompress') );
199
$is_gzip = ( $cfg['GZipDump'] && @function_exists('gzencode') );
200
$is_bzip = ( $cfg['BZipDump'] && @function_exists('bzcompress') );
202
if ( $is_zip || $is_gzip || $is_bzip ) { ?>
203
<div class="formelementrow">
204
<?php echo $strCompression; ?>:
205
<input type="radio" name="compression" value="none"
206
id="radio_compression_none"
207
onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
208
<?php PMA_exportIsActive('compression', 'none'); ?> />
209
<label for="radio_compression_none"><?php echo $strNone; ?></label>
212
<input type="radio" name="compression" value="zip"
213
id="radio_compression_zip"
214
onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
215
<?php PMA_exportIsActive('compression', 'zip'); ?> />
216
<label for="radio_compression_zip"><?php echo $strZip; ?></label>
217
<?php } if ($is_gzip) { ?>
218
<input type="radio" name="compression" value="gzip"
219
id="radio_compression_gzip"
220
onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
221
<?php PMA_exportIsActive('compression', 'gzip'); ?> />
222
<label for="radio_compression_gzip"><?php echo $strGzip; ?></label>
223
<?php } if ($is_bzip) { ?>
224
<input type="radio" name="compression" value="bzip"
225
id="radio_compression_bzip"
226
onclick="document.getElementById('checkbox_dump_asfile').checked = true;"
227
<?php PMA_exportIsActive('compression', 'bzip2'); ?> />
228
<label for="radio_compression_bzip"><?php echo $strBzip; ?></label>
232
<input type="hidden" name="compression" value="none" />
236
<?php if (function_exists('PMA_set_enc_form')) { ?>
237
<!-- Encoding setting form appended by Y.Kawada -->
238
<!-- Japanese encoding setting -->
240
<?php echo PMA_set_enc_form(' '); ?>
244
<fieldset class="tblFooters">
245
<?php PMA_externalBug($GLOBALS['strSQLCompatibility'], 'mysql', '50027', '14515'); ?>
246
<input type="submit" value="<?php echo $strGo; ?>" id="buttonGo" />
251
<sup id="FileNameTemplateHelp">(1)</sup>
253
$trans = '__SERVER__/' . $strFileNameTemplateDescriptionServer;
254
if ($export_type == 'database' || $export_type == 'table') {
255
$trans .= ', __DB__/' . $strFileNameTemplateDescriptionDatabase;
257
if ($export_type == 'table') {
258
$trans .= ', __TABLE__/' . $strFileNameTemplateDescriptionTable;
260
echo sprintf($strFileNameTemplateDescription,
261
'<a href="http://www.php.net/strftime" target="documentation" title="'
262
. $strDocu . '">', '</a>', $trans); ?>