phpmyadmin/tbl_row_action.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * handle row specifc actions like edit, delete, export
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 /**
  10  *
  11  */
  12 require_once 'libraries/common.inc.php';
  13 require_once 'libraries/mysql_charsets.lib.php';
  14
  15 /**
  16  * No rows were selected => show again the query and tell that user.
  17  */
  18 if (! PMA_isValid($_REQUEST['rows_to_delete'], 'array')
  19     && ! isset($_REQUEST['mult_btn'])
  20 ) {
  21     $disp_message = __('No rows selected');
  22     $disp_query = '';
  23     include 'sql.php';
  24     exit;
  25 }
  26
  27 if (isset($_REQUEST['submit_mult'])) {
  28     $submit_mult = $_REQUEST['submit_mult'];
  29     // workaround for IE problem:
  30 } elseif (isset($_REQUEST['submit_mult_delete_x'])) {
  31     $submit_mult = 'row_delete';
  32 } elseif (isset($_REQUEST['submit_mult_change_x'])) {
  33     $submit_mult = 'row_edit';
  34 } elseif (isset($_REQUEST['submit_mult_export_x'])) {
  35     $submit_mult = 'row_export';
  36 }
  37
  38 // If the 'Ask for confirmation' button was pressed, this can only come
  39 // from 'delete' mode, so we set it straight away.
  40 if (isset($_REQUEST['mult_btn'])) {
  41     $submit_mult = 'row_delete';
  42 }
  43
  44 switch($submit_mult) {
  45 case 'row_delete':
  46 case 'row_edit':
  47 case 'row_export':
  48     // leave as is
  49     break;
  50
  51 case 'export':
  52     $submit_mult = 'row_export';
  53     break;
  54
  55 case 'delete':
  56     $submit_mult = 'row_delete';
  57     break;
  58
  59 default:
  60 case 'edit':
  61     $submit_mult = 'row_edit';
  62     break;
  63 }
  64
  65 if (!empty($submit_mult)) {
  66     switch($submit_mult) {
  67     case 'row_edit':
  68         // As we got the rows to be edited from the
  69         // 'rows_to_delete' checkbox, we use the index of it as the
  70         // indicating WHERE clause. Then we build the array which is used
  71         // for the tbl_change.php script.
  72         $where_clause = array();
  73         foreach ($_REQUEST['rows_to_delete'] as $i => $i_where_clause) {
  74             $where_clause[] = urldecode($i_where_clause);
  75         }
  76
  77         $active_page = 'tbl_change.php';
  78         include 'tbl_change.php';
  79         break;
  80
  81     case 'row_export':
  82         // Needed to allow SQL export
  83         $single_table = true;
  84
  85         // As we got the rows to be exported from the
  86         // 'rows_to_delete' checkbox, we use the index of it as the
  87         // indicating WHERE clause. Then we build the array which is used
  88         // for the tbl_change.php script.
  89         $where_clause = array();
  90         foreach ($_REQUEST['rows_to_delete'] as $i => $i_where_clause) {
  91             $where_clause[] = urldecode($i_where_clause);
  92         }
  93
  94         $active_page = 'tbl_export.php';
  95         include 'tbl_export.php';
  96         break;
  97
  98     case 'row_delete':
  99     default:
 100         $action = 'tbl_row_action.php';
 101         $err_url = 'tbl_row_action.php'
 102             . PMA_generate_common_url($GLOBALS['url_params']);
 103         if (! isset($_REQUEST['mult_btn'])) {
 104             $original_sql_query = $sql_query;
 105             if (! empty($url_query)) {
 106                 $original_url_query = $url_query;
 107             }
 108         }
 109         include 'libraries/mult_submits.inc.php';
 110         $_url_params = $GLOBALS['url_params'];
 111         $_url_params['goto'] = 'tbl_sql.php';
 112         $url_query = PMA_generate_common_url($_url_params);
 113
 114
 115         /**
 116          * Show result of multi submit operation
 117          */
 118         // sql_query is not set when user does not confirm multi-delete
 119         if ((! empty($submit_mult) || isset($_REQUEST['mult_btn']))
 120             && ! empty($sql_query)
 121         ) {
 122             $disp_message = __('Your SQL query has been executed successfully');
 123             $disp_query = $sql_query;
 124         }
 125
 126         if (isset($original_sql_query)) {
 127             $sql_query = $original_sql_query;
 128         }
 129
 130         if (isset($original_url_query)) {
 131             $url_query = $original_url_query;
 132         }
 133
 134         // this is because sql.php could call tbl_structure
 135         // which would think it needs to call mult_submits.inc.php:
 136         unset($submit_mult, $_REQUEST['mult_btn']);
 137
 138         $active_page = 'sql.php';
 139         include 'sql.php';
 140         break;
 141     }
 142 }
 143 ?>