tbl_export.php

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