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 space (as an alternative to doing it in tbl_alter.php)
   6  * This form is only for users with JavaScript disabled -- users with JavaScript enabled will see a different form
   7  * defined in tbl_properties.inc.php
   8  * @package phpMyAdmin
   9  */
  10
  11 require_once './libraries/common.inc.php';
  12 require_once './libraries/header_http.inc.php';
  13 require_once './libraries/header_meta_style.inc.php';
  14 ?>
  15
  16 </head>
  17
  18 <body>
  19     <form action="enum_editor.php" method="get">
  20         <div id="enum_editor_no_js">
  21             <h3><?php printf(__('Values for the column "%s"'), htmlspecialchars($_GET['field'])); ?></h3>
  22             <p><?php echo __('Enter each value in a separate field.'); ?></p>
  23             <div id="values">
  24             <?php
  25                 $values = array();
  26                 if (isset($_GET['values'])) { // This page was displayed when the "add a new value" link or the link in tbl_alter.php was clicked
  27                     $values = explode(',', urldecode($_GET['values']));
  28                 } elseif (isset($_GET['num_fields'])) { // This page was displayed from submitting this form
  29                     for ($field_num = 1; $field_num <= $_GET['num_fields']; $field_num++) {
  30                         $values[] = "'" . str_replace(array("'", '\\'), array("''", '\\\\'), $_GET['field' . $field_num]) . "'";
  31                     }
  32                 }
  33                 // Display the values in text fields, excluding empty strings
  34                 $field_counter = 0;
  35                 foreach ($values as $value) {
  36                     if (trim($value) != "") {
  37                         $field_counter++;
  38                         echo sprintf('<input type="text" size="30" value="%s" name="field' . $field_counter . '" />', htmlspecialchars(str_replace(array("''", '\\\\', "\\'"), array("'", '\\', "'"), substr($value, 1, -1))));
  39                     }
  40                 }
  41
  42                 $total_fields = $field_counter;
  43                 // If extra empty fields are added, display them
  44                 if (isset($_GET['extra_fields'])) {
  45                     $total_fields += $_GET['extra_fields'];
  46                     for ($i = $field_counter+1; $i <= $total_fields; $i++) {
  47                         echo '<input type="text" size="30" name="field' . $i . '"/>';
  48                     }
  49                 } else {
  50                     $_GET['extra_fields'] = 0;
  51                 }
  52
  53             ?>
  54             </div>
  55             <p>
  56                <a href="enum_editor.php<?php echo PMA_generate_common_url(array('field' => $_GET['field'], 'extra_fields' => $_GET['extra_fields'] + 1, 'values' => join(',', $values))); ?>">
  57 <?php echo __('+ Restart insertion and add a new value'); ?>
  58                </a>
  59             </p>
  60             <?php echo PMA_generate_common_hidden_inputs(); ?>
  61              <input type="hidden" name="field" value="<?php echo htmlspecialchars($_GET['field']); ?>" />
  62              <input type="hidden" name="num_fields" value="<?php echo $total_fields; ?>" />
  63              <input type="submit" value="<?php echo __('Go'); ?>" />
  64         </form>
  65
  66         <div id="enum_editor_output">
  67         <h3><?php echo __('Output'); ?></h3>
  68         <p><?php echo __('Copy and paste the joined values into the "Length/Values" field'); ?></p>
  69             <textarea id="joined_values" cols="95" rows="5"><?php echo htmlspecialchars(join(",", $values)); ?></textarea>
  70         </div>
  71     </div>
  72 </body>
  73 </html>