libraries/mult_submits.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  * @package phpMyAdmin
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Prepares the work and runs some other scripts if required
  14  */
  15 if (! empty($submit_mult)
  16  && $submit_mult != $strWithChecked
  17  && (! empty($selected_db)
  18   || ! empty($selected_tbl)
  19   || ! empty($selected_fld)
  20   || ! empty($rows_to_delete))) {
  21     define('PMA_SUBMIT_MULT', 1);
  22     if (isset($selected_db) && !empty($selected_db)) {
  23         // coming from server database view - do something with selected databases
  24         $selected     = $selected_db;
  25         $what         = 'drop_db';
  26     } elseif (isset($selected_tbl) && !empty($selected_tbl)) {
  27         // coming from database structure view - do something with selected tables
  28         if ($submit_mult == $strPrintView) {
  29             require './tbl_printview.php';
  30         } else {
  31            $selected = $selected_tbl;
  32            switch ($submit_mult) {
  33                case 'drop_db':
  34                    $what = 'drop_db';
  35                    break;
  36                case $strDrop:
  37                    $what = 'drop_tbl';
  38                    break;
  39                case $strEmpty:
  40                    $what = 'empty_tbl';
  41                    break;
  42                case $strCheckTable:
  43                    unset($submit_mult);
  44                    $query_type = 'check_tbl';
  45                    $mult_btn   = $strYes;
  46                    break;
  47                case $strOptimizeTable:
  48                    unset($submit_mult);
  49                    $query_type = 'optimize_tbl';
  50                    $mult_btn   = $strYes;
  51                    break;
  52                case $strRepairTable:
  53                    unset($submit_mult);
  54                    $query_type = 'repair_tbl';
  55                    $mult_btn   = $strYes;
  56                    break;
  57                case $strAnalyzeTable:
  58                    unset($submit_mult);
  59                    $query_type = 'analyze_tbl';
  60                    $mult_btn   = $strYes;
  61                    break;
  62            } // end switch
  63         }
  64     } elseif (isset($selected_fld) && !empty($selected_fld)) {
  65         // coming from table structure view - do something with selected columns/fileds
  66         $selected     = $selected_fld;
  67         switch ($submit_mult) {
  68             case $strDrop:
  69                 $what     = 'drop_fld';
  70                 break;
  71             case $strPrimary:
  72                 // Gets table primary key
  73                 PMA_DBI_select_db($db);
  74                 $result      = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';');
  75                 $primary     = '';
  76                 while ($row = PMA_DBI_fetch_assoc($result)) {
  77                     // Backups the list of primary keys
  78                     if ($row['Key_name'] == 'PRIMARY') {
  79                         $primary .= $row['Column_name'] . ', ';
  80                     }
  81                 } // end while
  82                 PMA_DBI_free_result($result);
  83                 if (empty($primary)) {
  84                     // no primary key, so we can safely create new
  85                     unset($submit_mult);
  86                     $query_type = 'primary_fld';
  87                     $mult_btn   = $strYes;
  88                 } else {
  89                     // primary key exists, so lets as user
  90                     $what = 'primary_fld';
  91                 }
  92                 break;
  93             case $strIndex:
  94                 unset($submit_mult);
  95                 $query_type = 'index_fld';
  96                 $mult_btn   = $strYes;
  97                 break;
  98             case $strUnique:
  99                 unset($submit_mult);
 100                 $query_type = 'unique_fld';
 101                 $mult_btn   = $strYes;
 102                 break;
 103             case $strIdxFulltext:
 104                 unset($submit_mult);
 105                 $query_type = 'fulltext_fld';
 106                 $mult_btn   = $strYes;
 107                 break;
 108             case $strChange:
 109                 require './tbl_alter.php';
 110                 break;
 111             case $strBrowse:
 112                 // this should already be handled by tbl_structure.php
 113         }
 114     } else {
 115         // coming from borwsing - do something with selected rows
 116         $what = 'row_delete';
 117         $selected = $rows_to_delete;
 118     }
 119 } // end if
 120
 121
 122 /**
 123  * Displays the confirmation form if required
 124  */
 125 if (!empty($submit_mult) && !empty($what)) {
 126     $GLOBALS['js_include'][] = 'functions.js';
 127     unset($message);
 128
 129     require_once './libraries/header.inc.php';
 130     if (strlen($table)) {
 131         require './libraries/tbl_common.php';
 132         $url_query .= '&amp;goto=tbl_sql.php&amp;back=tbl_sql.php';
 133         require './libraries/tbl_info.inc.php';
 134         require_once './libraries/tbl_links.inc.php';
 135     } elseif (strlen($db)) {
 136         require './libraries/db_common.inc.php';
 137         require './libraries/db_info.inc.php';
 138     } else {
 139         require_once './libraries/server_common.inc.php';
 140         require_once './libraries/server_links.inc.php';
 141     }
 142
 143     // Builds the query
 144     $full_query     = '';
 145     if ($what == 'drop_tbl') {
 146         $full_query_views = '';
 147     }
 148     $selected_cnt   = count($selected);
 149     $i = 0;
 150     foreach ($selected AS $idx => $sval) {
 151         switch ($what) {
 152             case 'row_delete':
 153                 $full_query .= htmlspecialchars($sval)
 154                     . ';<br />';
 155                 break;
 156             case 'drop_db':
 157                 $full_query .= 'DROP DATABASE '
 158                     . PMA_backquote(htmlspecialchars($sval))
 159                     . ';<br />';
 160                 $reload = 1;
 161                 break;
 162
 163             case 'drop_tbl':
 164                 $current = $sval;
 165                 if (!empty($views) && in_array($current, $views)) {
 166                     $full_query_views .= (empty($full_query_views) ? 'DROP VIEW ' : ', ')
 167                         . PMA_backquote(htmlspecialchars($current));
 168                 } else {
 169                     $full_query .= (empty($full_query) ? 'DROP TABLE ' : ', ')
 170                         . PMA_backquote(htmlspecialchars($current));
 171                 }
 172                 break;
 173
 174             case 'empty_tbl':
 175                 $full_query .= 'TRUNCATE ';
 176                 $full_query .= PMA_backquote(htmlspecialchars($sval))
 177                             . ';<br />';
 178                 break;
 179
 180             case 'primary_fld':
 181                 if ($full_query == '') {
 182                     $full_query .= 'ALTER TABLE '
 183                         . PMA_backquote(htmlspecialchars($table))
 184                         . '<br />&nbsp;&nbsp;DROP PRIMARY KEY,'
 185                         . '<br />&nbsp;&nbsp; ADD PRIMARY KEY('
 186                         . '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 187                         . PMA_backquote(htmlspecialchars($sval))
 188                         . ',';
 189                 } else {
 190                     $full_query .= '<br />&nbsp;&nbsp;&nbsp;&nbsp; '
 191                         . PMA_backquote(htmlspecialchars($sval))
 192                         . ',';
 193                 }
 194                 if ($i == $selected_cnt-1) {
 195                     $full_query = preg_replace('@,$@', ');<br />', $full_query);
 196                 }
 197                 break;
 198
 199             case 'drop_fld':
 200                 if ($full_query == '') {
 201                     $full_query .= 'ALTER TABLE '
 202                         . PMA_backquote(htmlspecialchars($table));
 203                 }
 204                 $full_query .= '<br />&nbsp;&nbsp;DROP '
 205                     . PMA_backquote(htmlspecialchars($sval))
 206                     . ',';
 207                 if ($i == $selected_cnt - 1) {
 208                     $full_query = preg_replace('@,$@', ';<br />', $full_query);
 209                 }
 210                 break;
 211         } // end switch
 212         $i++;
 213     }
 214     if ($what == 'drop_tbl') {
 215         if (!empty($full_query)) {
 216             $full_query .= ';<br />' . "\n";
 217         }
 218         if (!empty($full_query_views)) {
 219             $full_query .= $full_query_views . ';<br />' . "\n";
 220         }
 221         unset($full_query_views);
 222     }
 223
 224     // Displays the confirmation form
 225     $_url_params = array(
 226         'query_type' => $what,
 227         'reload' => (! empty($reload) ? 1 : 0),
 228     );
 229     if (strpos(' ' . $action, 'db_') == 1) {
 230         $_url_params['db']= $db;
 231     } elseif (strpos(' ' . $action, 'tbl_') == 1 || $what == 'row_delete') {
 232         $_url_params['db']= $db;
 233         $_url_params['table']= $table;
 234     }
 235     foreach ($selected as $idx => $sval) {
 236         $_url_params['selected'][] = $sval;
 237     }
 238     if ($what == 'drop_tbl' && !empty($views)) {
 239         foreach ($views as $current) {
 240             $_url_params['views'][] = $current;
 241        }
 242     }
 243     if ($what == 'row_delete') {
 244         $_url_params['original_sql_query'] = $original_sql_query;
 245         $_url_params['original_url_query'] = $original_url_query;
 246     }
 247     ?>
 248 <form action="<?php echo $action; ?>" method="post">
 249     <?php
 250     echo PMA_generate_common_hidden_inputs($_url_params);
 251     ?>
 252 <fieldset class="confirmation">
 253     <legend><?php echo ($what == 'drop_db' ? $strDropDatabaseStrongWarning . '&nbsp;' : '') . $strDoYouReally; ?>:</legend>
 254     <tt><?php echo $full_query; ?></tt>
 255 </fieldset>
 256 <fieldset class="tblFooters">
 257     <input type="submit" name="mult_btn" value="<?php echo $strYes; ?>" id="buttonYes" />
 258     <input type="submit" name="mult_btn" value="<?php echo $strNo; ?>" id="buttonNo" />
 259 </fieldset>
 260     <?php
 261     require_once './libraries/footer.inc.php';
 262 } // end if
 263
 264
 265 /**
 266  * Executes the query - dropping rows, columns/fields, tables or dbs
 267  */
 268 elseif ($mult_btn == $strYes) {
 269
 270     if ($query_type == 'drop_db' || $query_type == 'drop_tbl' || $query_type == 'drop_fld') {
 271         require_once './libraries/relation_cleanup.lib.php';
 272     }
 273
 274     $sql_query      = '';
 275     if ($query_type == 'drop_tbl') {
 276         $sql_query_views = '';
 277     }
 278     $selected_cnt   = count($selected);
 279     $run_parts      = FALSE; // whether to run query after each pass
 280     $use_sql        = FALSE; // whether to include sql.php at the end (to display results)
 281
 282     if ($query_type == 'primary_fld') {
 283         // Gets table primary key
 284         PMA_DBI_select_db($db);
 285         $result      = PMA_DBI_query('SHOW KEYS FROM ' . PMA_backquote($table) . ';');
 286         $primary     = '';
 287         while ($row = PMA_DBI_fetch_assoc($result)) {
 288             // Backups the list of primary keys
 289             if ($row['Key_name'] == 'PRIMARY') {
 290                 $primary .= $row['Column_name'] . ', ';
 291             }
 292         } // end while
 293         PMA_DBI_free_result($result);
 294     }
 295
 296     $rebuild_database_list = false;
 297
 298     for ($i = 0; $i < $selected_cnt; $i++) {
 299         switch ($query_type) {
 300             case 'row_delete':
 301                 $a_query = $selected[$i];
 302                 $run_parts = TRUE;
 303                 break;
 304
 305             case 'drop_db':
 306                 PMA_relationsCleanupDatabase($selected[$i]);
 307                 $a_query   = 'DROP DATABASE '
 308                            . PMA_backquote($selected[$i]);
 309                 $reload    = 1;
 310                 $run_parts = TRUE;
 311                 $rebuild_database_list = true;
 312                 break;
 313
 314             case 'drop_tbl':
 315                 PMA_relationsCleanupTable($db, $selected[$i]);
 316                 $current = $selected[$i];
 317                 if (!empty($views) && in_array($current, $views)) {
 318                     $sql_query_views .= (empty($sql_query_views) ? 'DROP VIEW ' : ', ')
 319                               . PMA_backquote($current);
 320                 } else {
 321                     $sql_query .= (empty($sql_query) ? 'DROP TABLE ' : ', ')
 322                                . PMA_backquote($current);
 323                 }
 324                 $reload    = 1;
 325                 break;
 326
 327             case 'check_tbl':
 328                 $sql_query .= (empty($sql_query) ? 'CHECK TABLE ' : ', ')
 329                            . PMA_backquote($selected[$i]);
 330                 $use_sql    = TRUE;
 331                 break;
 332
 333             case 'optimize_tbl':
 334                 $sql_query .= (empty($sql_query) ? 'OPTIMIZE TABLE ' : ', ')
 335                            . PMA_backquote($selected[$i]);
 336                 $use_sql    = TRUE;
 337                 break;
 338
 339             case 'analyze_tbl':
 340                 $sql_query .= (empty($sql_query) ? 'ANALYZE TABLE ' : ', ')
 341                            . PMA_backquote($selected[$i]);
 342                 $use_sql    = TRUE;
 343                 break;
 344
 345             case 'repair_tbl':
 346                 $sql_query .= (empty($sql_query) ? 'REPAIR TABLE ' : ', ')
 347                            . PMA_backquote($selected[$i]);
 348                 $use_sql    = TRUE;
 349                 break;
 350
 351             case 'empty_tbl':
 352                 $a_query = 'TRUNCATE ';
 353                 $a_query .= PMA_backquote(htmlspecialchars($selected[$i]));
 354                 $run_parts = TRUE;
 355                 break;
 356
 357             case 'drop_fld':
 358                 PMA_relationsCleanupColumn($db, $table, $selected[$i]);
 359                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) : ',')
 360                            . ' DROP ' . PMA_backquote($selected[$i])
 361                            . (($i == $selected_cnt-1) ? ';' : '');
 362                 break;
 363
 364             case 'primary_fld':
 365                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) . (empty($primary) ? '' : ' DROP PRIMARY KEY,') . ' ADD PRIMARY KEY( ' : ', ')
 366                            . PMA_backquote($selected[$i])
 367                            . (($i == $selected_cnt-1) ? ');' : '');
 368                 break;
 369
 370             case 'index_fld':
 371                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) . ' ADD INDEX( ' : ', ')
 372                            . PMA_backquote($selected[$i])
 373                            . (($i == $selected_cnt-1) ? ');' : '');
 374                 break;
 375
 376             case 'unique_fld':
 377                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) . ' ADD UNIQUE( ' : ', ')
 378                            . PMA_backquote($selected[$i])
 379                            . (($i == $selected_cnt-1) ? ');' : '');
 380                 break;
 381
 382             case 'fulltext_fld':
 383                 $sql_query .= (empty($sql_query) ? 'ALTER TABLE ' . PMA_backquote($table) . ' ADD FULLTEXT( ' : ', ')
 384                            . PMA_backquote($selected[$i])
 385                            . (($i == $selected_cnt-1) ? ');' : '');
 386                 break;
 387         } // end switch
 388
 389         // All "DROP TABLE", "DROP FIELD", "OPTIMIZE TABLE" and "REPAIR TABLE"
 390         // statements will be run at once below
 391         if ($run_parts) {
 392             $sql_query .= $a_query . ';' . "\n";
 393             if ($query_type != 'drop_db') {
 394                 PMA_DBI_select_db($db);
 395             }
 396             $result = PMA_DBI_query($a_query);
 397         } // end if
 398     } // end for
 399
 400     if ($query_type == 'drop_tbl') {
 401         if (!empty($sql_query)) {
 402         $sql_query .= ';';
 403     } elseif (!empty($sql_query_views)) {
 404         $sql_query = $sql_query_views . ';';
 405             unset($sql_query_views);
 406         }
 407     }
 408
 409     if ($use_sql) {
 410         require './sql.php';
 411     } elseif (!$run_parts) {
 412         PMA_DBI_select_db($db);
 413         $result = PMA_DBI_try_query($sql_query);
 414         if ($result && !empty($sql_query_views)) {
 415             $sql_query .= ' ' . $sql_query_views . ';';
 416             $result = PMA_DBI_try_query($sql_query_views);
 417             unset($sql_query_views);
 418         }
 419
 420         if (! $result) {
 421             $message = PMA_Message::error(PMA_DBI_getError());
 422         }
 423     }
 424     if ($rebuild_database_list) {
 425         // avoid a problem with the database list navigator
 426         // when dropping a db from server_databases
 427         $GLOBALS['pma']->databases->build();
 428     }
 429 } else {
 430     $message = PMA_Message::success('strNoModification');
 431 }
 432 ?>