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 htmlspecialchars($db); ?>" />
24 <input type
="hidden" name
="table" value
="<?php echo htmlspecialchars($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
/>
40 <input type
="radio" name
="what" value
="latex" id
="radio_dump_latex" />
41 <label
for="radio_dump_latex"><?php
echo $strLaTeX; ?
></label
>  
;  
;
42 <!-- for now we have only one environment supported
-->
43 <input type
="hidden" name
="environment" value
="longtable" />
45 <select name="environment">
46 <option value="longtable" selected><?php echo $strLaTeXMultipageTable; ?></option>
47 <option value="sideways"><?php echo $strLaTeXSidewaysTable; ?></option>
48 <option value="table"><?php echo $strLaTeXStandardTable; ?></option>
54 <input type
="radio" name
="what" value
="excel" id
="radio_dump_excel" />
55 <label
for="radio_dump_excel"><?php
echo $strStrucExcelCSV; ?
></label
> 
; 
;<br
/>
58 <input type
="radio" name
="what" value
="csv" id
="radio_dump_csv" />
59 <label
for="radio_dump_csv"><?php
echo $strStrucCSV;?
></label
> 
;:<br
/>
60  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsTerminatedBy; ?
> 
;
61 <input type
="text" name
="separator" size
="2" value
=";" class="textfield" /> 
; 
;<br
/>
62  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsEnclosedBy; ?
> 
;
63 <input type
="text" name
="enclosed" size
="1" value
=""" class="textfield" /> 
; 
;<br
/>
64  
; 
; 
; 
; 
; 
;<?php
echo $strFieldsEscapedBy; ?
> 
;
65 <input type
="text" name
="escaped" size
="2" value
="\" class="textfield
" /> <br />
66 <?php echo $strLinesTerminatedBy; ?>
67 <input type="text
" name="add_character
" size="2" value="<?php
echo ((PMA_whichCrlf() == "\n") ?
'\n' : '\r\n'); ?
>" class="textfield
" /> <br />
70 <input type="radio
" name="what
" value="xml
" id="radio_dump_xml
" />
71 <label for="radio_dump_xml
"><?php echo $strExportToXML; ?></label>
76 <!-- For structure -->
77 <?php echo $strStructure; ?><br />
79 <input type="checkbox
" name="drop
" value="1" id="checkbox_dump_drop
" />
80 <label for="checkbox_dump_drop
"><?php echo $strStrucDrop; ?></label><br />
82 // Add backquotes checkbox
83 if (PMA_MYSQL_INT_VERSION >= 32306) {
86 <input type="checkbox
" name="use_backquotes
" value="1" id="checkbox_dump_use_backquotes
" />
87 <label for="checkbox_dump_use_backquotes
"><?php echo $strUseBackquotes; ?></label><br />
89 } // end backquotes feature
94 <?php echo $strData; ?><br />
96 <input type="checkbox
" name="showcolumns
" value="yes
" id="checkbox_dump_showcolumns
" />
97 <label for="checkbox_dump_showcolumns
"><?php echo $strCompleteInserts; ?></label><br />
99 <input type="checkbox
" name="extended_ins
" value="yes
" id="checkbox_dump_extended_ins
" />
100 <label for="checkbox_dump_extended_ins
"><?php echo $strExtendedInserts; ?></label><br />
102 <?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
"; ?>
104 <!-- For CSV data -->
105 <?php echo $strStrucCSV; ?><br />
107 <input type="checkbox
" name="showcsvnames
" value="yes
" id="checkbox_dump_showcsvnames
" />
108 <label for="checkbox_dump_showcsvnames
"><?php echo $strPutColNames; ?></label>
113 <!-- Export to screen or to file -->
114 <td colspan="2" align="center
">
115 <input type="checkbox
" name="asfile
" value="sendit
" id="checkbox_dump_asfile
" onclick="return checkTransmitDump(this
.form
, 'transmit')" />
116 <label for="checkbox_dump_asfile
"><?php echo $strSend; ?></label>
119 if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
120 $temp_charset = reset($cfg['AvailableCharsets']);
121 echo "\n
" . ' , ' . $strCharsetOfFile . "\n
"
122 . ' <select name="charset_of_file
" size="1">' . "\n
"
123 . ' <option value="' . $temp_charset . '"';
124 if ($temp_charset == $charset) {
125 echo ' selected="selected
"';
127 echo '>' . $temp_charset . '</option>' . "\n
";
128 while ($temp_charset = next($cfg['AvailableCharsets'])) {
129 echo ' <option value="' . $temp_charset . '"';
130 if ($temp_charset == $charset) {
131 echo ' selected="selected
"';
133 echo '>' . $temp_charset . '</option>' . "\n
";
139 // zip, gzip and bzip2 encode features
140 if (PMA_PHP_INT_VERSION >= 40004) {
141 $is_zip = (isset($cfg['ZipDump']) && $cfg['ZipDump'] && @function_exists('gzcompress'));
142 $is_gzip = (isset($cfg['GZipDump']) && $cfg['GZipDump'] && @function_exists('gzencode'));
143 $is_bzip = (isset($cfg['BZipDump']) && $cfg['BZipDump'] && @function_exists('bzcompress'));
144 if ($is_zip || $is_gzip || $is_bzip) {
145 echo "\n
" . ' (' . "\n
";
148 <input type="checkbox
" name="zip
" value="zip
" id="checkbox_dump_zip
" onclick="return checkTransmitDump(this
.form
, 'zip')" />
149 <?php echo '<label for="checkbox_dump_zip
">' . $strZip . '</label>' . (($is_gzip || $is_bzip) ? ' ' : '') . "\n
"; ?>
155 <input type="checkbox
" name="gzip
" value="gzip
" id="checkbox_dump_gzip
" onclick="return checkTransmitDump(this
.form
, 'gzip')" />
156 <?php echo '<label for="checkbox_dump_gzip
">' . $strGzip . '</label>' . (($is_bzip) ? ' ' : '') . "\n
"; ?>
162 <input type="checkbox
" name="bzip
" value="bzip
" id="checkbox_dump_bzip
" onclick="return checkTransmitDump(this
.form
, 'bzip')" />
163 <?php echo '<label for="checkbox_dump_bzip
">' . $strBzip . '</label>' . "\n
"; ?>
175 // Encoding setting form appended by Y.Kawada
176 if (function_exists('PMA_set_enc_form')) {
179 <!-- Japanese encoding setting -->
180 <td colspan="2" align="center
">
182 echo PMA_set_enc_form(' ');
192 <td colspan="2" align="center
">
193 <input type="submit
" value="<?php
echo $strGo; ?
>" />
200 <a href="./Documentation
.html
#faqexport" target="documentation"><?php echo $strDocu; ?></a>
206 * Displays the footer
208 require('./footer.inc.php3');