db_details_export.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Gets some core libraries
   8  */
   9 $sub_part  = '_export';
  10 require('./db_details_common.php3');
  11 $url_query .= '&amp;goto=db_details_export.php3';
  12 require('./db_details_db_info.php3');
  13
  14
  15 /**
  16  * Displays the form
  17  */
  18 ?>
  19 <!-- Dump of a database -->
  20 <form method="post" action="tbl_dump.php3" name="db_dump">
  21     <?php echo $strViewDumpDB; ?><br />
  22     <table>
  23     <tr>
  24 <?php
  25 $colspan    = '';
  26 if ($num_tables > 1) {
  27     $colspan = ' colspan="2"';
  28     ?>
  29         <td>
  30             <select name="table_select[]" size="6" multiple="multiple">
  31     <?php
  32     $i = 0;
  33     echo "\n";
  34     $is_selected = (!empty($selectall) ? ' selected="selected"' : '');
  35     while ($i < $num_tables) {
  36         $table   = htmlspecialchars((PMA_MYSQL_INT_VERSION >= 32303) ? $tables[$i]['Name'] : $tables[$i]);
  37         echo '                <option value="' . $table . '"' . $is_selected . '>' . $table . '</option>' . "\n";
  38         $i++;
  39     } // end while
  40     ?>
  41             </select>
  42         </td>
  43     <?php
  44 } // end if
  45
  46 echo "\n";
  47 ?>
  48         <td valign="middle">
  49             <input type="radio" name="what" value="structure" id="radio_dump_structure" checked="checked" />
  50             <label for="radio_dump_structure"><?php echo $strStrucOnly; ?></label><br />
  51             <input type="radio" name="what" id="radio_dump_data" value="data" />
  52             <label for="radio_dump_data"><?php echo $strStrucData; ?></label><br />
  53             <input type="radio" name="what" id="radio_dump_dataonly" value="dataonly" />
  54             <label for="radio_dump_dataonly"><?php echo $strDataOnly; ?></label><br />
  55             <input type="radio" name="what" id="radio_dump_xml" value="xml" />
  56             <label for="radio_dump_xml"><?php echo $strExportToXML; ?></label><br />
  57             <input type="radio" name="what" value="latex" id="radio_dump_latex" />
  58             <label for="radio_dump_latex"><?php echo $strLaTeX; ?></label> &nbsp; &nbsp;
  59             <!-- for now we have only one environment supported -->
  60             <input type="hidden" name="environment" value="longtable" />
  61             <?php /*
  62             <select name="environment">
  63                 <option value="longtable" selected><?php echo $strLaTeXMultipageTable; ?></option>
  64                 <option value="sideways"><?php echo $strLaTeXSidewaysTable; ?></option>
  65                 <option value="table"><?php echo $strLaTeXStandardTable; ?></option>
  66             </select>
  67             */ ?>
  68
  69 <?php
  70 if ($num_tables > 1) {
  71     $checkall_url = 'db_details_export.php3?'
  72                   . PMA_generate_common_url($db)
  73                   . '&amp;goto=db_details_export.php3';
  74     ?>
  75             <br />
  76             <a href="<?php echo $checkall_url; ?>&amp;selectall=1#dumpdb" onclick="setSelectOptions('db_dump', 'table_select[]', true); return false;"><?php echo $strSelectAll; ?></a>
  77             &nbsp;/&nbsp;
  78             <a href="<?php echo $checkall_url; ?>#dumpdb" onclick="setSelectOptions('db_dump', 'table_select[]', false); return false;"><?php echo $strUnselectAll; ?></a>
  79     <?php
  80 }  // end if
  81 echo "\n";
  82 ?>
  83         </td>
  84     </tr>
  85     <tr>
  86         <td<?php echo $colspan; ?>>
  87             <input type="checkbox" name="drop" value="1" id="checkbox_dump_drop" />
  88             <label for="checkbox_dump_drop"><?php echo $strStrucDrop; ?></label>
  89         </td>
  90     </tr>
  91     <tr>
  92         <td<?php echo $colspan; ?>>
  93             <input type="checkbox" name="showcolumns" value="yes" id="checkbox_dump_showcolumns" />
  94             <label for="checkbox_dump_showcolumns"><?php echo $strCompleteInserts; ?></label>
  95         </td>
  96     </tr>
  97     <tr>
  98         <td<?php echo $colspan; ?>>
  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>
 101         </td>
 102     </tr>
 103 <?php
 104 // Add backquotes checkbox
 105 if (PMA_MYSQL_INT_VERSION >= 32306) {
 106     ?>
 107     <tr>
 108         <td<?php echo $colspan; ?>>
 109             <input type="checkbox" name="use_backquotes" value="1" id="checkbox_dump_use_backquotes" />
 110             <label for="checkbox_dump_use_backquotes"><?php echo $strUseBackquotes; ?></label>
 111         </td>
 112     </tr>
 113     <?php
 114 } // end backquotes feature
 115 echo "\n";
 116 ?>
 117     <tr>
 118         <td<?php echo $colspan; ?>>
 119             <input type="checkbox" name="asfile" value="sendit" id="checkbox_dump_asfile" onclick="return checkTransmitDump(this.form, 'transmit')" />
 120             <label for="checkbox_dump_asfile"><?php echo $strSend; ?></label>
 121 <?php
 122 // charset of file
 123 if ($cfg['AllowAnywhereRecoding'] && $allow_recoding) {
 124     $temp_charset = reset($cfg['AvailableCharsets']);
 125     echo "\n" . '            , ' . $strCharsetOfFile . "\n"
 126          . '            <select name="charset_of_file" size="1">' . "\n"
 127          . '                <option value="' . $temp_charset . '"';
 128     if ($temp_charset == $charset) {
 129         echo ' selected="selected"';
 130     }
 131     echo '>' . $temp_charset . '</option>' . "\n";
 132     while ($temp_charset = next($cfg['AvailableCharsets'])) {
 133         echo '                <option value="' . $temp_charset . '"';
 134         if ($temp_charset == $charset) {
 135             echo ' selected="selected"';
 136         }
 137         echo '>' . $temp_charset . '</option>' . "\n";
 138     } // end while
 139     echo '            </select>';
 140 } // end if
 141 echo "\n";
 142
 143 // zip, gzip and bzip2 encode features
 144 if (PMA_PHP_INT_VERSION >= 40004) {
 145     $is_zip  = (isset($cfg['ZipDump']) && $cfg['ZipDump'] && @function_exists('gzcompress'));
 146     $is_gzip = (isset($cfg['GZipDump']) && $cfg['GZipDump'] && @function_exists('gzencode'));
 147     $is_bzip = (isset($cfg['BZipDump']) && $cfg['BZipDump'] && @function_exists('bzcompress'));
 148     if ($is_zip || $is_gzip || $is_bzip) {
 149         echo "\n" . '                (' . "\n";
 150         if ($is_zip) {
 151             ?>
 152             <input type="checkbox" name="zip" value="zip" id="checkbox_dump_zip" onclick="return checkTransmitDump(this.form, 'zip')" />
 153             <?php
 154             echo '<label for="checkbox_dump_zip">' . $strZip . '</label>'
 155                  . (($is_gzip || $is_bzip) ? '&nbsp;' : '') . "\n";
 156         }
 157         if ($is_gzip) {
 158             echo "\n"
 159             ?>
 160             <input type="checkbox" name="gzip" value="gzip" id="checkbox_dump_gzip" onclick="return checkTransmitDump(this.form, 'gzip')" />
 161             <?php
 162             echo '<label for="checkbox_dump_gzip">' . $strGzip . '</label>'
 163                  . (($is_bzip) ? '&nbsp;' : '') . "\n";
 164         }
 165         if ($is_bzip) {
 166             echo "\n"
 167             ?>
 168             <input type="checkbox" name="bzip" value="bzip" id="checkbox_dump_bzip" onclick="return checkTransmitDump(this.form, 'bzip')" />
 169             <?php
 170             echo '<label for="checkbox_dump_bzip">' . $strBzip . '</label>' . "\n";
 171         }
 172         echo "\n" . '                )';
 173     }
 174 } // end *zip feature
 175 echo "\n";
 176
 177 // Encoding setting form appended by Y.Kawada
 178 if (function_exists('PMA_set_enc_form')) {
 179     echo '            <br />' . "\n"
 180          . PMA_set_enc_form('            ');
 181 }
 182 ?>
 183         </td>
 184     </tr>
 185     <tr>
 186         <td<?php echo $colspan; ?>>
 187             <input type="submit" value="<?php echo $strGo; ?>" />
 188         </td>
 189     </tr>
 190     </table>
 191     <?php echo PMA_generate_common_hidden_inputs($db); ?>
 192 </form>
 193
 194 <a href="./Documentation.html#faqexport" target="documentation"><?php echo $strDocu; ?></a>
 195
 196
 197 <?php
 198 /**
 199  * Displays the footer
 200  */
 201 require('./footer.inc.php3');
 202 ?>