tbl_export.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package phpMyAdmin
   6  */
   7
   8 /**
   9  *
  10  */
  11 require_once './libraries/common.inc.php';
  12
  13 $GLOBALS['js_include'][] = 'export.js';
  14
  15 /**
  16  * Gets tables informations and displays top links
  17  */
  18 require_once './libraries/tbl_common.php';
  19 $url_query .= '&amp;goto=tbl_export.php&amp;back=tbl_export.php';
  20 require_once './libraries/tbl_info.inc.php';
  21
  22 // Dump of a table
  23
  24 $export_page_title = __('View dump (schema) of table');
  25
  26 // When we have some query, we need to remove LIMIT from that and possibly
  27 // generate WHERE clause (if we are asked to export specific rows)
  28
  29 if (! empty($sql_query)) {
  30     // Parse query so we can work with tokens
  31     $parsed_sql = PMA_SQP_parse($sql_query);
  32     $analyzed_sql = PMA_SQP_analyze($parsed_sql);
  33
  34     // Need to generate WHERE clause?
  35     if (isset($where_clause)) {
  36         // Yes => rebuild query from scratch; this doesn't work with nested
  37         // selects :-(
  38         $sql_query = 'SELECT ';
  39
  40         if (isset($analyzed_sql[0]['queryflags']['distinct'])) {
  41             $sql_query .= ' DISTINCT ';
  42         }
  43
  44         $sql_query .= $analyzed_sql[0]['select_expr_clause'];
  45
  46         if (!empty($analyzed_sql[0]['from_clause'])) {
  47             $sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause'];
  48         }
  49
  50         $wheres = array();
  51
  52         if (isset($where_clause) && is_array($where_clause)
  53          && count($where_clause) > 0) {
  54             $wheres[] = '(' . implode(') OR (',$where_clause) . ')';
  55         }
  56
  57         if (!empty($analyzed_sql[0]['where_clause']))  {
  58             $wheres[] = $analyzed_sql[0]['where_clause'];
  59         }
  60
  61         if (count($wheres) > 0) {
  62             $sql_query .= ' WHERE (' . implode(') AND (', $wheres) . ')';
  63         }
  64
  65         if (!empty($analyzed_sql[0]['group_by_clause'])) {
  66             $sql_query .= ' GROUP BY ' . $analyzed_sql[0]['group_by_clause'];
  67         }
  68         if (!empty($analyzed_sql[0]['having_clause'])) {
  69             $sql_query .= ' HAVING ' . $analyzed_sql[0]['having_clause'];
  70         }
  71         if (!empty($analyzed_sql[0]['order_by_clause'])) {
  72             $sql_query .= ' ORDER BY ' . $analyzed_sql[0]['order_by_clause'];
  73         }
  74     } else {
  75         // Just crop LIMIT clause
  76         $sql_query = $analyzed_sql[0]['section_before_limit'] . $analyzed_sql[0]['section_after_limit'];
  77     }
  78     $message = PMA_Message::success();
  79 }
  80
  81 /**
  82  * Displays top menu links
  83  */
  84 require './libraries/tbl_links.inc.php';
  85
  86 $export_type = 'table';
  87 require_once './libraries/display_export.lib.php';
  88
  89
  90 /**
  91  * Displays the footer
  92  */
  93 require './libraries/footer.inc.php';
  94 ?>