3 // vim: expandtab sw=4 ts=4 sts=4:
7 * Gets tables informations and displays top links
9 require('./tbl_properties_common.php3');
10 $url_query .= '&goto=tbl_properties_export.php3&back=tbl_properties_export.php3';
11 require('./tbl_properties_table_info.php3');
14 <!-- Dump of a table
-->
16 <?php
echo $strViewDump . "\n"; ?
>
19 <form method
="post" action
="tbl_dump.php3" name
="tbl_dump">
20 <input type
="hidden" name
="server" value
="<?php echo $server; ?>" />
21 <input type
="hidden" name
="lang" value
="<?php echo $lang; ?>" />
22 <input type
="hidden" name
="convcharset" value
="<?php echo $convcharset; ?>" />
23 <input type
="hidden" name
="db" value
="<?php echo $db; ?>" />
24 <input type
="hidden" name
="table" value
="<?php echo $table; ?>" />
25 <table cellpadding
="5" border
="2" align
="center">
28 <!-- Formats to export to
-->
31 <input type
="radio" name
="what" value
="structure" id
="radio_dump_structure" checked
="checked" />
32 <label
for="radio_dump_structure"><?php
echo $strStrucOnly; ?
></label
> 
; 
;<br
/>
33 <input type
="radio" name
="what" value
="data" id
="radio_dump_data" />
34 <label
for="radio_dump_data"><?php
echo $strStrucData; ?
></label
> 
; 
;<br
/>
35 <input type
="radio" name
="what" value
="dataonly" id
="radio_dump_dataonly" />
36 <label
for="radio_dump_dataonly"><?php
echo $strDataOnly; ?
></label
> 
; 
;<br
/>
39 <input type
="radio" name
="what" value
="excel" id
="radio_dump_excel" />
40 <label
for="radio_dump_excel"><?php
echo $strStrucExcelCSV; ?
></label
> 
; 
;<br
/>
43 <input type
="radio" name
="what" value
="csv" id
="radio_dump_csv" />
44 <label
for="radio_dump_csv"><?php
echo $strStrucCSV;?
></label
> 
;:<br
/>
45  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsTerminatedBy; ?
> 
;
46 <input type
="text" name
="separator" size
="2" value
=";" class="textfield" /> 
; 
;<br
/>
47  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsEnclosedBy; ?
> 
;
48 <input type
="text" name
="enclosed" size
="1" value
=""" class="textfield" /> 
; 
;<br
/>
49  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsEscapedBy; ?
> 
;
50 <input type
="text" name
="escaped" size
="2" value
="\" class="textfield
" /> <br />
51 <?php echo $strLinesTerminatedBy; ?>
52 <input type="text
" name="add_character
" size="2" value="<?php
echo ((PMA_whichCrlf() == "\n") ?
'\n' : '\r\n'); ?
>" class="textfield
" /> <br />
55 <input type="radio
" name="what
" value="xml
" id="radio_dump_xml
" />
56 <label for="radio_dump_xml
"><?php echo $strExportToXML; ?></label>
61 <!-- For structure -->
62 <?php echo $strStructure; ?><br />
64 <input type="checkbox
" name="drop
" value="1" id="checkbox_dump_drop
" />
65 <label for="checkbox_dump_drop
"><?php echo $strStrucDrop; ?></label><br />
67 // Add backquotes checkbox
68 if (PMA_MYSQL_INT_VERSION >= 32306) {
71 <input type="checkbox
" name="use_backquotes
" value="1" id="checkbox_dump_use_backquotes
" />
72 <label for="checkbox_dump_use_backquotes
"><?php echo $strUseBackquotes; ?></label><br />
74 } // end backquotes feature
79 <?php echo $strData; ?><br />
81 <input type="checkbox
" name="showcolumns
" value="yes
" id="checkbox_dump_showcolumns
" />
82 <label for="checkbox_dump_showcolumns
"><?php echo $strCompleteInserts; ?></label><br />
84 <input type="checkbox
" name="extended_ins
" value="yes
" id="checkbox_dump_extended_ins
" />
85 <label for="checkbox_dump_extended_ins
"><?php echo $strExtendedInserts; ?></label><br />
87 <?php echo sprintf($strDumpXRows , '<input type="text
" name="limit_to
" size="5" value="' . PMA_countRecords($db, $table, TRUE) . '" class="textfield
" style="vertical
-align
: middle
" onfocus="this
.select()" />' , '<input type="text
" name="limit_from
" value="0" size="5" class="textfield
" style="vertical
-align
: middle
" onfocus="this
.select()" />') . "\n
"; ?>
90 <?php echo $strStrucCSV; ?><br />
92 <input type="checkbox
" name="showcsvnames
" value="yes
" id="checkbox_dump_showcsvnames
" />
93 <label for="checkbox_dump_showcsvnames
"><?php echo $strPutColNames; ?></label>
98 <!-- Export to screen or to file -->
99 <td colspan="2" align="center
">
100 <input type="checkbox
" name="asfile
" value="sendit
" id="checkbox_dump_asfile
" onclick="return checkTransmitDump(this
.form
, 'transmit')" />
101 <label for="checkbox_dump_asfile
"><?php echo $strSend; ?></label>
104 if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
105 $temp_charset = reset($cfg['AvailableCharsets']);
106 echo "\n
" . ' , ' . $strCharsetOfFile . "\n
"
107 . ' <select name="charset_of_file
" size="1">' . "\n
"
108 . ' <option value="' . $temp_charset . '"';
109 if ($temp_charset == $charset) {
110 echo ' selected="selected
"';
112 echo '>' . $temp_charset . '</option>' . "\n
";
113 while ($temp_charset = next($cfg['AvailableCharsets'])) {
114 echo ' <option value="' . $temp_charset . '"';
115 if ($temp_charset == $charset) {
116 echo ' selected="selected
"';
118 echo '>' . $temp_charset . '</option>' . "\n
";
124 // zip, gzip and bzip2 encode features
125 if (PMA_PHP_INT_VERSION >= 40004) {
126 $is_zip = (isset($cfg['ZipDump']) && $cfg['ZipDump'] && @function_exists('gzcompress'));
127 $is_gzip = (isset($cfg['GZipDump']) && $cfg['GZipDump'] && @function_exists('gzencode'));
128 $is_bzip = (isset($cfg['BZipDump']) && $cfg['BZipDump'] && @function_exists('bzcompress'));
129 if ($is_zip || $is_gzip || $is_bzip) {
130 echo "\n
" . ' (' . "\n
";
133 <input type="checkbox
" name="zip
" value="zip
" id="checkbox_dump_zip
" onclick="return checkTransmitDump(this
.form
, 'zip')" />
134 <?php echo '<label for="checkbox_dump_zip
">' . $strZip . '</label>' . (($is_gzip || $is_bzip) ? ' ' : '') . "\n
"; ?>
140 <input type="checkbox
" name="gzip
" value="gzip
" id="checkbox_dump_gzip
" onclick="return checkTransmitDump(this
.form
, 'gzip')" />
141 <?php echo '<label for="checkbox_dump_gzip
">' . $strGzip . '</label>' . (($is_bzip) ? ' ' : '') . "\n
"; ?>
147 <input type="checkbox
" name="bzip
" value="bzip
" id="checkbox_dump_bzip
" onclick="return checkTransmitDump(this
.form
, 'bzip')" />
148 <?php echo '<label for="checkbox_dump_bzip
">' . $strBzip . '</label>' . "\n
"; ?>
160 // Encoding setting form appended by Y.Kawada
161 if (function_exists('PMA_set_enc_form')) {
164 <!-- Japanese encoding setting -->
165 <td colspan="2" align="center
">
167 echo PMA_set_enc_form(' ');
177 <td colspan="2" align="center
">
178 <input type="submit
" value="<?php
echo $strGo; ?
>" />
185 <a href="./Documentation
.html
#faqexport" target="documentation"><?php echo $strDocu; ?></a>
191 * Displays the footer
193 require('./footer.inc.php3');