tbl_rename.php3

   1 <?php
   2 /* $Id$ */
   3
   4
   5 /**
   6  * Gets some core libraries
   7  */
   8 require('./libraries/grab_globals.lib.php3');
   9 $js_to_run = 'functions.js';
  10 require('./libraries/common.lib.php3');
  11
  12
  13 /**
  14  * Defines the url to return to in case of error in a sql statement
  15  */
  16 $err_url = 'tbl_properties.php3'
  17          . '?lang=' . $lang
  18          . '&amp;server=' . $server
  19          . '&amp;db=' . urlencode($db)
  20          . '&amp;table=' . urlencode($table);
  21
  22
  23 /**
  24  * A new name has been submitted -> do the work
  25  */
  26 if (isset($new_name) && trim($new_name) != '') {
  27     $old_name     = $table;
  28     $table        = $new_name;
  29     if (get_magic_quotes_gpc()) {
  30         $new_name = stripslashes($new_name);
  31     }
  32
  33     // Ensure the target is valid
  34     if (count($dblist) > 0 && PMA_isInto($db, $dblist) == -1) {
  35         exit();
  36     }
  37     if (PMA_MYSQL_INT_VERSION < 32306) {
  38         PMA_checkReservedWords($new_name, $err_url);
  39     }
  40
  41     include('./header.inc.php3');
  42     mysql_select_db($db);
  43     $sql_query = 'ALTER TABLE ' . PMA_backquote($old_name) . ' RENAME ' . PMA_backquote($new_name);
  44     $result    = mysql_query($sql_query) or PMA_mysqlDie('', '', '', $err_url);
  45     $message   = sprintf($strRenameTableOK, $old_name, $table);
  46     $reload    = 1;
  47 }
  48
  49
  50 /**
  51  * No new name for the table!
  52  */
  53 else {
  54     include('./header.inc.php3');
  55     PMA_mysqlDie($strTableEmpty, '', '', $err_url);
  56 }
  57
  58
  59 /**
  60  * Back to the calling script
  61  */
  62 require('./tbl_properties.php3');
  63 ?>