tbl_alter.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Gets some core libraries
   8  */
   9 require('./libraries/grab_globals.lib.php3');
  10 if (!isset($submit_mult)) {
  11     if (isset($submit)) {
  12         $js_to_run = 'functions.js';
  13     }
  14     include('./header.inc.php3');
  15 }
  16
  17
  18 /**
  19  * Defines the url to return to in case of error in a sql statement
  20  */
  21 $err_url = 'tbl_properties_structure.php3'
  22          . '?lang=' . $lang
  23          . '&amp;convcharset=' . $convcharset
  24          . '&amp;server=' . $server
  25          . '&amp;db=' . urlencode($db)
  26          . '&amp;table=' . urlencode($table);
  27
  28
  29 /**
  30  * Modifications have been submitted -> updates the table
  31  */
  32 if (isset($submit)) {
  33     $field_cnt = count($field_orig);
  34     for ($i = 0; $i < $field_cnt; $i++) {
  35         if (get_magic_quotes_gpc()) {
  36             $field_name[$i]    = stripslashes($field_name[$i]);
  37             $field_default[$i] = stripslashes($field_default[$i]);
  38             $field_length[$i]  = stripslashes($field_length[$i]);
  39         }
  40
  41         if (PMA_MYSQL_INT_VERSION < 32306) {
  42             PMA_checkReservedWords($field_name[$i], $err_url);
  43         }
  44
  45         // Some fields have been urlencoded or double quotes have been translated
  46         // to "&quot;" in tbl_properties.php3
  47         $field_orig[$i]     = urldecode($field_orig[$i]);
  48         if (strcmp(str_replace('"', '&quot;', $field_orig[$i]), $field_name[$i]) == 0) {
  49             $field_name[$i] = $field_orig[$i];
  50         }
  51         $field_default_orig[$i] = urldecode($field_default_orig[$i]);
  52         if (strcmp(str_replace('"', '&quot;', $field_default_orig[$i]), $field_default[$i]) == 0) {
  53             $field_default[$i]  = $field_default_orig[$i];
  54         }
  55         $field_length_orig[$i] = urldecode($field_length_orig[$i]);
  56         if (strcmp(str_replace('"', '&quot;', $field_length_orig[$i]), $field_length[$i]) == 0) {
  57             $field_length[$i] = $field_length_orig[$i];
  58         }
  59         if (!isset($query)) {
  60             $query = '';
  61         } else {
  62             $query .= ', CHANGE ';
  63         }
  64         $query .= PMA_backquote($field_orig[$i]) . ' ' . PMA_backquote($field_name[$i]) . ' ' . $field_type[$i];
  65         // Some field types shouldn't have lengths
  66         if ($field_length[$i] != ''
  67             && !eregi('^(DATE|DATETIME|TIME|TINYBLOB|TINYTEXT|BLOB|TEXT|MEDIUMBLOB|MEDIUMTEXT|LONGBLOB|LONGTEXT)$', $field_type[$i])) {
  68             $query .= '(' . $field_length[$i] . ')';
  69         }
  70         if ($field_attribute[$i] != '') {
  71             $query .= ' ' . $field_attribute[$i];
  72         }
  73         if ($field_default[$i] != '') {
  74             if (strtoupper($field_default[$i]) == 'NULL') {
  75                 $query .= ' DEFAULT NULL';
  76             } else {
  77                 $query .= ' DEFAULT \'' . PMA_sqlAddslashes($field_default[$i]) . '\'';
  78             }
  79         }
  80         if ($field_null[$i] != '') {
  81             $query .= ' ' . $field_null[$i];
  82         }
  83         if ($field_extra[$i] != '') {
  84             $query .= ' ' . $field_extra[$i];
  85         }
  86     } // end for
  87
  88     // To allow replication, we first select the db to use and then run queries
  89     // on this db.
  90     $sql_query     = 'USE ' . PMA_backquote($db);
  91     $result        = PMA_mysql_query($sql_query) or PMA_mysqlDie('', '', '', $err_url);
  92     // Optimization fix - 2 May 2001 - Robbat2
  93     $sql_query = 'ALTER TABLE ' . PMA_backquote($table) . ' CHANGE ' . $query;
  94     $result    = PMA_mysql_query($sql_query) or PMA_mysqlDie('', '', '', $err_url);
  95     $message   = $strTable . ' ' . htmlspecialchars($table) . ' ' . $strHasBeenAltered;
  96     $btnDrop   = 'Fake';
  97     include('./tbl_properties_structure.php3');
  98     exit();
  99 }
 100
 101
 102 /**
 103  * No modifications yet required -> displays the table fields
 104  */
 105 else {
 106     if (!isset($selected)) {
 107         $selected[]   = $field;
 108         $selected_cnt = 1;
 109     } else { // from a multiple submit
 110         $selected_cnt = count($selected);
 111     }
 112
 113     // TODO: optimize in case of multiple fields to modify
 114     for ($i = 0; $i < $selected_cnt; $i++) {
 115         if (!empty($submit_mult)) {
 116             $field = PMA_sqlAddslashes(urldecode($selected[$i]), TRUE);
 117         }
 118         else if (get_magic_quotes_gpc()) {
 119             $field = PMA_sqlAddslashes(stripslashes($selected[$i]), TRUE);
 120         }
 121         else {
 122             $field = PMA_sqlAddslashes($selected[$i], TRUE);
 123         }
 124         $local_query   = 'SHOW FIELDS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db) . " LIKE '$field'";
 125         $result        = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);
 126         $fields_meta[] = PMA_mysql_fetch_array($result);
 127         mysql_free_result($result);
 128     }
 129
 130     $num_fields  = count($fields_meta);
 131     $action      = 'tbl_alter.php3';
 132     include('./tbl_properties.inc.php3');
 133 }
 134
 135
 136 /**
 137  * Displays the footer
 138  */
 139 require('./footer.inc.php3');
 140 ?>