enum_editor.php

   1 <?php
   2
   3 /* vim: set expandtab sw=4 ts=4 sts=4: */
   4 /**
   5  * Displays a form for editing ENUM and SET values with more
   6  * space (as an alternative to doing it in tbl_alter.php).
   7  * This form is only for users with JavaScript disabled,
   8  * users with JavaScript enabled will see a jQuery dialog.
   9  *
  10  * @package PhpMyAdmin
  11  */
  12
  13 require_once './libraries/common.inc.php';
  14 require_once './libraries/header_http.inc.php';
  15 require_once './libraries/header_meta_style.inc.php';
  16 ?>
  17 </head>
  18 <body>
  19     <form action="enum_editor.php" method="get">
  20         <?php echo PMA_generate_common_hidden_inputs(); ?>
  21         <input type="hidden" name="field" value="<?php echo htmlspecialchars($_GET['field']); ?>" />
  22         <fieldset class="enum_editor_no_js">
  23         <legend><?php echo __('ENUM/SET editor'); ?></legend>
  24         <div class="enum_editor_no_js">
  25             <h3>
  26             <?php
  27                 if (empty($_GET['field'])) {
  28                     echo __('Values for a new column');
  29                 } else {
  30                     printf(__('Values for column %s'), '"' . htmlspecialchars($_GET['field']) . '"');
  31                 }
  32             ?>
  33             </h3>
  34             <p><?php echo PMA_getImage('s_info.png') . __('Enter each value in a separate field'); ?></p>
  35             <table id="values">
  36             <?php
  37                 // Get the enum values
  38                 $values = array();
  39                 // If the values are in an array
  40                 if (isset($_GET['values']) && is_array($_GET['values'])) {
  41                      // then this page was called from itself via the "Add a value", "Drop" or "Go" buttons
  42                     $values = $_GET['values'];
  43                     foreach ($values as $key => $value) {
  44                         $values[$key] = htmlentities($value);
  45                     }
  46                     // If the values are in a string
  47                 } elseif (isset($_GET['values']) && is_string($_GET['values'])) {
  48                     // then this page was called via a link from some external page
  49                     $values_string = htmlentities($_GET['values']);
  50                     // There is a JS port of the below parser in functions.js
  51                     // If you are fixing something here,
  52                     // you need to also update the JS port.
  53                     $values = array();
  54                     $in_string = false;
  55                     $buffer = '';
  56                     for ($i=0; $i<strlen($values_string); $i++) {
  57                         $curr = $values_string[$i];
  58                         $next = $i == strlen($values_string)-1 ? '' : $values_string[$i+1];
  59                         if (! $in_string && $curr == "'") {
  60                             $in_string = true;
  61                         } else if ($in_string && $curr == "\\" && $next == "\\") {
  62                             $buffer .= "&#92;";
  63                             $i++;
  64                         } else if ($in_string && $next == "'" && ($curr == "'" || $curr == "\\")) {
  65                             $buffer .= "&#39;";
  66                             $i++;
  67                         } else if ($in_string && $curr == "'") {
  68                             $in_string = false;
  69                             $values[] = $buffer;
  70                             $buffer = '';
  71                         } else if ($in_string) {
  72                              $buffer .= $curr;
  73                         }
  74                     }
  75                     if (strlen($buffer) > 0) {
  76                         // The leftovers in the buffer are the last value (if any)
  77                         $values[] = $buffer;
  78                     }
  79                 }
  80                 // Escape double quotes
  81                 foreach ($values as $key => $value) {
  82                     $values[$key] = str_replace('"', "&quote;", $value);
  83                 }
  84                 // If there are no values, maybe the user is about to make a
  85                 // new list so we add a few for him/her to get started with.
  86                 if (! count($values)
  87                     || (count($values) == 1 && strlen($values[0]) == 0)
  88                 ) {
  89                     array_push($values, '', '', '');
  90                 }
  91                 // Add an empty value, if there was a request to do so
  92                 if (! empty($_GET['add_field'])) {
  93                     $values[] = '';
  94                 }
  95                 // Remove a value, given a valid index, from the list
  96                 // of values, if there was a request to do so.
  97                 if (isset($_GET['drop']) && is_array($_GET['drop'])) {
  98                     foreach ($_GET['drop'] as $index => $value) {
  99                         if ((int)$index == $index
 100                             && $index > 0
 101                             && $index <= count($values)
 102                         ) {
 103                             unset($values[$index]);
 104                         }
 105                     }
 106                 }
 107                 // Display the values in text fields
 108                 $field_counter = 0;
 109                 foreach ($values as $value) {
 110                     $field_counter++;
 111                     echo sprintf(
 112                         '<tr><td><input class="text" type="text" size="30" value="%s" name="values[' . $field_counter . ']" />' . "\n",
 113                         $value
 114                     );
 115                     echo '</td><td>';
 116                     echo '<input class="drop" type="submit" value="' . __('Drop') . '" name="drop[' . $field_counter . ']" />' . "\n";
 117                     echo '</td></tr>' . "\n";
 118                 }
 119             ?>
 120                 <tr><td>
 121                     <input type="submit" class="submit" value="<?php echo __('Go'); ?>" />
 122                 </td><td>
 123                     <input type="submit" class="submit" name="add_field" value="<?php echo __('Add a value'); ?>" />
 124                 </td></tr>
 125             </table>
 126         </div>
 127         <hr class='enum_editor_no_js' />
 128         <div id="enum_editor_output">
 129         <h3><?php echo __('Output'); ?></h3>
 130         <p><?php echo PMA_getImage('s_info.png') . __('Copy and paste the joined values into the "Length/Values" field'); ?></p>
 131             <?php
 132                 // Escape quotes and slashes for usage with MySQL
 133                 foreach ($values as $key => $value) {
 134                     $values[$key]  = "'";
 135                     $values[$key] .= str_replace(
 136                         array("'", "\\", "&#39;", "&#92;"),
 137                         array("''", '\\\\', "''", '\\\\'),
 138                         $value
 139                     );
 140                     $values[$key] .= "'";
 141                 }
 142                 // Print out the values as a string
 143             ?>
 144             <textarea id="joined_values" cols="95" rows="5"><?php echo join(",", $values); ?></textarea>
 145         </div>
 146         </fieldset>
 147     </form>
 148 </body>
 149 </html>