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