[Sommaire] [Imprimer]

   1  <?php
   2  /* $Id: db_export.php 10390 2007-05-14 16:03:38Z lem9 $ */
   3  // vim: expandtab sw=4 ts=4 sts=4:
   4  /**
   5   * dumps a database
   6   *
   7   * @uses    libraries/db_common.inc.php
   8   * @uses    libraries/db_info.inc.php
   9   * @uses    libraries/display_export.lib.php
  10   * @uses    $tables     from libraries/db_info.inc.php
  11   */
  12  
  13  /**
  14   * Gets some core libraries
  15   */
  16  require_once ('./libraries/common.lib.php');
  17  
  18  $sub_part  = '_export';
  19  require_once ('./libraries/db_common.inc.php');
  20  $url_query .= '&amp;goto=db_export.php';
  21  require_once ('./libraries/db_info.inc.php');
  22  
  23  /**
  24   * Displays the form
  25   */
  26  $export_page_title = $strViewDumpDB;
  27  
  28  // exit if no tables in db found
  29  if ( $num_tables < 1 ) {
  30      echo '<div class="warning">' . $strNoTablesFound . '</div>';
  31      require ('./libraries/footer.inc.php');
  32      exit;
  33  } // end if
  34  
  35  $multi_values = '<div align="center"><select name="table_select[]" size="6" multiple="multiple">';
  36  $multi_values .= "\n";
  37  
  38  foreach ( $tables as $each_table ) {
  39      // ok we show also views
  40      //if ( PMA_MYSQL_INT_VERSION >= 50000 && is_null($each_table['Engine']) ) {
  41          // Don't offer to export views yet.
  42      //    continue;
  43      //}
  44      if ( ! empty( $unselectall )
  45        || ( isset( $tmp_select ) 
  46             && false !== strpos( $tmp_select, '|' . $each_table['Name'] . '|') ) ) {
  47          $is_selected = '';
  48      } else {
  49          $is_selected = ' selected="selected"';
  50      }
  51      $table_html   = htmlspecialchars( $each_table['Name'] );
  52      $multi_values .= '                <option value="' . $table_html . '"' 
  53          . $is_selected . '>' . $table_html . '</option>' . "\n";
  54  } // end for
  55  $multi_values .= "\n";
  56  $multi_values .= '</select></div>';
  57  
  58  $checkall_url = 'db_export.php?'
  59                . PMA_generate_common_url( $db )
  60                . '&amp;goto=db_export.php';
  61  
  62  $multi_values .= '<br />
  63          <a href="' . $checkall_url . '" onclick="setSelectOptions(\'dump\', \'table_select[]\', true); return false;">' . $strSelectAll . '</a>
  64          /
  65          <a href="' . $checkall_url . '&amp;unselectall=1" onclick="setSelectOptions(\'dump\', \'table_select[]\', false); return false;">' . $strUnselectAll . '</a>';
  66  
  67  $export_type = 'database';
  68  require_once ('./libraries/display_export.lib.php');
  69  
  70  /**
  71   * Displays the footer
  72   */
  73  require_once ('./libraries/footer.inc.php');
  74  ?>