tbl_properties_export.php3

   1 <?php
   2 /* $Id$ */
   3
   4
   5 /**
   6  * Gets tables informations and displays top links
   7  */
   8 require('./tbl_properties_common.php3');
   9 $sub_part = '_export';
  10 require('./tbl_properties_table_info.php3');
  11 ?>
  12
  13 <!-- Dump of a table -->
  14 <p align="center">
  15     <?php echo $strViewDump . "\n"; ?>
  16 </p>
  17
  18 <form method="post" action="tbl_dump.php3" name="tbl_dump">
  19     <input type="hidden" name="server" value="<?php echo $server; ?>" />
  20     <input type="hidden" name="lang" value="<?php echo $lang; ?>" />
  21     <input type="hidden" name="convcharset" value="<?php echo $convcharset; ?>" />
  22     <input type="hidden" name="db" value="<?php echo $db; ?>" />
  23     <input type="hidden" name="table" value="<?php echo $table; ?>" />
  24     <table cellpadding="5" border="2" align="center">
  25     <tr>
  26
  27         <!-- Formats to export to -->
  28         <td nowrap="nowrap">
  29             <!-- SQL -->
  30             <input type="radio" name="what" value="structure" id="radio_dump_structure" checked="checked" />
  31             <label for="radio_dump_structure"><?php echo $strStrucOnly; ?></label>&nbsp;&nbsp;<br />
  32             <input type="radio" name="what" value="data" id="radio_dump_data" />
  33             <label for="radio_dump_data"><?php echo $strStrucData; ?></label>&nbsp;&nbsp;<br />
  34             <input type="radio" name="what" value="dataonly" id="radio_dump_dataonly" />
  35             <label for="radio_dump_dataonly"><?php echo $strDataOnly; ?></label>&nbsp;&nbsp;<br />
  36             <br />
  37             <!-- Excel CSV -->
  38             <input type="radio" name="what" value="excel" id="radio_dump_excel" />
  39             <label for="radio_dump_excel"><?php echo $strStrucExcelCSV; ?></label>&nbsp;&nbsp;<br />
  40             <br />
  41             <!-- General CSV -->
  42             <input type="radio" name="what" value="csv" id="radio_dump_csv" />
  43             <label for="radio_dump_csv"><?php echo $strStrucCSV;?></label>&nbsp;:<br />
  44             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $strFieldsTerminatedBy; ?>&nbsp;
  45             <input type="text" name="separator" size="2" value=";" class="textfield" />&nbsp;&nbsp;<br />
  46             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $strFieldsEnclosedBy; ?>&nbsp;
  47             <input type="text" name="enclosed" size="1" value="&quot;" class="textfield" />&nbsp;&nbsp;<br />
  48             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $strFieldsEscapedBy; ?>&nbsp;
  49             <input type="text" name="escaped" size="2" value="\" class="textfield" />&nbsp;&nbsp;<br />
  50             &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $strLinesTerminatedBy; ?>&nbsp;
  51             <input type="text" name="add_character" size="2" value="<?php echo ((PMA_whichCrlf() == "\n") ? '\n' : '\r\n'); ?>" class="textfield" />&nbsp;&nbsp;<br />
  52             <br />
  53             <!-- XML -->
  54             <input type="radio" name="what" value="xml" id="radio_dump_xml" />
  55             <label for="radio_dump_xml"><?php echo $strExportToXML; ?></label>&nbsp;&nbsp;
  56         </td>
  57
  58         <!-- Options -->
  59         <td valign="middle">
  60             <!-- For structure -->
  61             <?php echo $strStructure; ?><br />
  62             &nbsp;&nbsp;
  63             <input type="checkbox" name="drop" value="1" id="checkbox_dump_drop" />
  64             <label for="checkbox_dump_drop"><?php echo $strStrucDrop; ?></label><br />
  65 <?php
  66 // Add backquotes checkbox
  67 if (PMA_MYSQL_INT_VERSION >= 32306) {
  68     ?>
  69             &nbsp;&nbsp;
  70             <input type="checkbox" name="use_backquotes" value="1" id="checkbox_dump_use_backquotes" />
  71             <label for="checkbox_dump_use_backquotes"><?php echo $strUseBackquotes; ?></label><br />
  72     <?php
  73 } // end backquotes feature
  74 echo "\n";
  75 ?>
  76             <br />
  77             <!-- For data -->
  78             <?php echo $strData; ?><br />
  79             &nbsp;&nbsp;
  80             <input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" />
  81             <label for="checkbox_dump_showcolumns"><?php echo $strCompleteInserts; ?></label><br />
  82             &nbsp;&nbsp;
  83             <input type="checkbox" name="extended_ins" value="yes" id="checkbox_dump_extended_ins" />
  84             <label for="checkbox_dump_extended_ins"><?php echo $strExtendedInserts; ?></label><br />
  85             &nbsp;&nbsp;
  86             <?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"; ?>
  87         </td>
  88     </tr>
  89
  90     <tr>
  91         <!-- Export to screen or to file -->
  92         <td colspan="2" align="center">
  93             <input type="checkbox" name="asfile" value="sendit" id="checkbox_dump_asfile" onclick="return checkTransmitDump(this.form, 'transmit')" />
  94             <label for="checkbox_dump_asfile"><?php echo $strSend; ?></label>
  95 <?php
  96 // zip, gzip and bzip2 encode features
  97 if (PMA_PHP_INT_VERSION >= 40004) {
  98     $is_zip  = (isset($cfg['ZipDump']) && $cfg['ZipDump'] && @function_exists('gzcompress'));
  99     $is_gzip = (isset($cfg['GZipDump']) && $cfg['GZipDump'] && @function_exists('gzencode'));
 100     $is_bzip = (isset($cfg['BZipDump']) && $cfg['BZipDump'] && @function_exists('bzcompress'));
 101     if ($is_zip || $is_gzip || $is_bzip) {
 102         echo "\n" . '            (' . "\n";
 103         if ($is_zip) {
 104             ?>
 105             <input type="checkbox" name="zip" value="zip" id="checkbox_dump_zip" onclick="return checkTransmitDump(this.form, 'zip')" />
 106             <?php echo '<label for="checkbox_dump_zip">' . $strZip . '</label>' . (($is_gzip || $is_bzip) ? '&nbsp;' : '') . "\n"; ?>
 107             <?php
 108         }
 109         if ($is_gzip) {
 110             echo "\n"
 111             ?>
 112             <input type="checkbox" name="gzip" value="gzip" id="checkbox_dump_gzip" onclick="return checkTransmitDump(this.form, 'gzip')" />
 113             <?php echo '<label for="checkbox_dump_gzip">' . $strGzip . '</label>' . (($is_bzip) ? '&nbsp;' : '') . "\n"; ?>
 114             <?php
 115         }
 116         if ($is_bzip) {
 117             echo "\n"
 118             ?>
 119             <input type="checkbox" name="bzip" value="bzip" id="checkbox_dump_bzip" onclick="return checkTransmitDump(this.form, 'bzip')" />
 120             <?php echo '<label for="checkbox_dump_bzip">' . $strBzip . '</label>' . "\n"; ?>
 121             <?php
 122         }
 123         echo "\n" . '            )';
 124     }
 125 }
 126 echo "\n";
 127 ?>
 128         </td>
 129     </tr>
 130
 131 <?php
 132 // Encoding setting form appended by Y.Kawada
 133 if (function_exists('PMA_set_enc_form')) {
 134     ?>
 135     <tr>
 136         <!-- Japanese encoding setting -->
 137         <td colspan="2" align="center">
 138     <?php
 139     echo PMA_set_enc_form('            ');
 140     ?>
 141         </td>
 142     </tr>
 143     <?php
 144 }
 145 echo "\n";
 146 ?>
 147
 148     <tr>
 149         <td colspan="2" align="center">
 150             <input type="submit" value="<?php echo $strGo; ?>" />
 151         </td>
 152     </tr>
 153     </table>
 154 </form>
 155
 156 <p align="center">
 157     <a href="./Documentation.html#faqexport" target="documentation"><?php echo $strDocu; ?></a>
 158 </p>
 159
 160
 161 <?php
 162 /**
 163  * Displays the footer
 164  */
 165 require('./footer.inc.php3');
 166 ?>