3 // vim: expandtab sw=4 ts=4 sts=4:
7 * Get the variables sent or posted to this script and displays the header
9 require('./libraries/grab_globals.lib.php3');
10 $js_to_run = 'tbl_change.js';
11 require('./header.inc.php3');
12 require('./libraries/relation.lib.php3'); // foreign keys
16 * Displays the query submitted and its result
18 if (!empty($disp_message)) {
21 $goto = 'tbl_properties.php3?'
22 . PMA_generate_common_url($db, $table)
23 . '&$show_query=1'
24 . '&sql_query=' . (isset($disp_query) ?
urlencode($disp_query) : '');
28 if (isset($sql_query)) {
29 $sql_query_cpy = $sql_query;
32 if (isset($disp_query)) {
33 $sql_query = $disp_query;
35 PMA_showMessage($disp_message);
36 if (isset($goto_cpy)) {
40 if (isset($sql_query_cpy)) {
41 $sql_query = $sql_query_cpy;
42 unset($sql_query_cpy);
48 * Defines the url to return to in case of error in a sql statement
51 $goto = 'db_details.php3';
53 if (!ereg('^(db_details|tbl_properties|tbl_select)', $goto)) {
54 $err_url = $goto . "?" . PMA_generate_common_url($db) . "&sql_query=" . urlencode($sql_query);
56 $err_url = $goto . '?'
57 . PMA_generate_common_url($db)
58 . ((ereg('^(tbl_properties|tbl_select)', $goto)) ?
'&table=' . urlencode($table) : '');
63 * Ensures db and table are valid, else moves to the "parent" script
65 require('./libraries/db_table_exists.lib.php3');
69 * Sets parameters for links and displays top menu
71 $url_query = PMA_generate_common_url($db, $table)
72 . '&goto=tbl_properties.php3';
74 require('./tbl_properties_table_info.php3');
79 * Get the list of the fields of the current table
81 PMA_mysql_select_db($db);
82 $table_def = PMA_mysql_query('SHOW FIELDS FROM ' . PMA_backquote($table));
83 if (isset($primary_key)) {
84 $local_query = 'SELECT * FROM ' . PMA_backquote($table) . ' WHERE ' . $primary_key;
85 $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);
86 $row = PMA_mysql_fetch_array($result);
93 $goto = 'tbl_properties.php3?'
94 . PMA_generate_common_url($db, $table)
95 . '&$show_query=1'
96 . '&sql_query=' . urlencode($local_query);
97 if (isset($sql_query)) {
98 $sql_query_cpy = $sql_query;
101 $sql_query = $local_query;
102 PMA_showMessage($strEmptyResultSet);
105 if (isset($sql_query_cpy)) {
106 $sql_query = $sql_query_cpy;
107 unset($sql_query_cpy);
109 } // end if (no record returned)
113 $local_query = 'SELECT * FROM ' . PMA_backquote($table) . ' LIMIT 1';
114 $result = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $err_url);
119 // retrieve keys into foreign fields, if any
120 $cfgRelation = PMA_getRelationsParam();
121 $foreigners = ($cfgRelation['relwork'] ?
PMA_getForeigners($db, $table) : FALSE);
127 // loic1: autocomplete feature of IE kills the "onchange" event handler and it
128 // must be replaced by the "onpropertychange" one in this case
129 $chg_evt_handler = (PMA_USR_BROWSER_AGENT
== 'IE' && PMA_USR_BROWSER_VER
>= 5)
132 // Had to put the URI because when hosted on an https server,
133 // some browsers send wrongly this form to the http server.
136 <?php
if ($cfg['CtrlArrowsMoving']) { ?
>
137 <!-- Set on key handler
for moving using by Ctrl+arrows
-->
138 <script type
="text/javascript" language
="javascript">
140 document
.onkeydown
= onKeyDownArrowsHandler
;
145 <!-- Change table properties form
-->
146 <form method
="post" action
="tbl_replace.php3" name
="insertForm" <?php
if ($is_upload) echo ' enctype="multipart/form-data"'; ?
>>
147 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
148 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
149 <input type
="hidden" name
="pos" value
="<?php echo isset($pos) ? $pos : 0; ?>" />
150 <input type
="hidden" name
="session_max_rows" value
="<?php echo isset($session_max_rows) ? $session_max_rows : ''; ?>" />
151 <input type
="hidden" name
="disp_direction" value
="<?php echo isset($disp_direction) ? $disp_direction : ''; ?>" />
152 <input type
="hidden" name
="repeat_cells" value
="<?php echo isset($repeat_cells) ? $repeat_cells : ''; ?>" />
153 <input type
="hidden" name
="dontlimitchars" value
="<?php echo (isset($dontlimitchars) ? $dontlimitchars : 0); ?>" />
154 <input type
="hidden" name
="err_url" value
="<?php echo urlencode($err_url); ?>" />
155 <input type
="hidden" name
="sql_query" value
="<?php echo isset($sql_query) ? urlencode($sql_query) : ''; ?>" />
157 if (isset($primary_key)) {
159 <input type
="hidden" name
="primary_key" value
="<?php echo urlencode($primary_key); ?>" />
165 <table border
="<?php echo $cfg['Border']; ?>">
167 <th
><?php
echo $strField; ?
></th
>
168 <th
><?php
echo $strType; ?
></th
>
170 if ($cfg['ShowFunctionFields']) {
171 echo ' <th>' . $strFunction . '</th>' . "\n";
174 <th
><?php
echo $strNull; ?
></th
>
175 <th
><?php
echo $strValue; ?
></th
>
179 if ($cfg['PropertiesIconic'] == true) {
180 // We need to copy the value or else the == 'both' check will always return true
181 $propicon = (string)$cfg['PropertiesIconic'];
183 if ($propicon == 'both') {
184 $iconic_spacer = '<nobr>';
189 $titles['Browse'] = $iconic_spacer . '<img width="12" height="13" src="images/button_browse.png" alt="' . $strBrowseForeignValues . '" title="' . $strBrowseForeignValues . '" border="0" />';
191 if ($propicon == 'both') {
192 $titles['Browse'] .= ' ' . $strBrowseForeignValues . '</nobr>';
195 $titles['Browse'] = $strBrowseForeignValues;
198 // Set if we passed the first timestamp field
200 $fields_cnt = mysql_num_rows($table_def);
202 // Set a flag here because the 'if' would not be valid in the loop
203 // if we set a value in some field
204 $insert_mode = (!isset($row) ?
TRUE : FALSE);
206 for ($i = 0; $i < $fields_cnt; $i++
) {
207 // Display the submit button after every 15 lines --swix
208 // (wanted to use an <a href="#bottom"> and <a name> instead,
209 // but it didn't worked because of the <base href>)
211 if ((($i %
15) == 0) && ($i != 0)) {
214 <th colspan
="5" align
="right">
215 <input type
="submit" value
="<?php echo $strGo; ?>" /> 
;
222 $row_table_def = PMA_mysql_fetch_array($table_def);
223 $row_table_def['True_Type'] = ereg_replace('\\(.*', '', $row_table_def['Type']);
224 $field = $row_table_def['Field'];
226 // garvin: possible workaround. If current field is numerical, do not try to
227 // access the result-array with its 'associative' key but with its numerical
229 if ((PMA_PHP_INT_VERSION
> 40000 && is_numeric($field)) ||
eregi('^[0-9]*$', $field)) {
235 // loic1: current date should not be set as default if the field is NULL
236 // for the current row
237 // lem9: but do not put here the current datetime if there is a default
238 // value (the real default value will be set in the
239 // Default value logic below)
240 if ($row_table_def['Type'] == 'datetime'
241 && (!isset($row_table_def['Default']))) {
244 $row[$rowfield] = date('Y-m-d H:i:s', time());
246 // UPDATE case with an empty and not NULL value under PHP4
247 else if (empty($row[$rowfield]) && function_exists('is_null')) {
248 $row[$rowfield] = (is_null($row[$rowfield]) ?
$row[$rowfield] : date('Y-m-d H:i:s', time()));
250 // UPDATE case with an empty value under PHP3
251 else if (empty($row[$rowfield])) {
252 $row[$rowfield] = date('Y-m-d H:i:s', time());
253 } // end if... else if... else if...
255 $len = (eregi('float|double', $row_table_def['Type']))
257 : @mysql_field_len
($result, $i);
258 $first_timestamp = 0;
260 $bgcolor = ($i %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
263 <td
<?php
echo ($cfg['LongtextDoubleTextarea'] && strstr($row_table_def['True_Type'], 'longtext') ?
'rowspan="2"' : ''); ?
> align
="center" bgcolor
="<?php echo $bgcolor; ?>"><?php
echo htmlspecialchars($field); ?
></td
>
268 $is_binary = eregi(' binary', $row_table_def['Type']);
269 $is_blob = eregi('blob', $row_table_def['Type']);
270 $is_char = eregi('char', $row_table_def['Type']);
271 switch ($row_table_def['True_Type']) {
281 if (!$timestamp_seen) { // can only occur once per table
283 $first_timestamp = 1;
285 $type = $row_table_def['Type'];
286 $type_nowrap = ' nowrap="nowrap"';
290 $type = $row_table_def['Type'];
291 $type_nowrap = ' nowrap="nowrap"';
295 <td align
="center" bgcolor
="<?php echo $bgcolor; ?>"<?php
echo $type_nowrap; ?
>>
301 // Prepares the field value
303 // loic1: null field value
304 if (!isset($row[$rowfield])) {
305 $row[$rowfield] = 'NULL';
307 $data = $row[$rowfield];
309 // loic1: special binary "characters"
310 if ($is_binary ||
$is_blob) {
311 $row[$rowfield] = str_replace("\x00", '\0', $row[$rowfield]);
312 $row[$rowfield] = str_replace("\x08", '\b', $row[$rowfield]);
313 $row[$rowfield] = str_replace("\x0a", '\n', $row[$rowfield]);
314 $row[$rowfield] = str_replace("\x0d", '\r', $row[$rowfield]);
315 $row[$rowfield] = str_replace("\x1a", '\Z', $row[$rowfield]);
317 $special_chars = htmlspecialchars($row[$rowfield]);
318 $data = $row[$rowfield];
319 } // end if... else...
320 // loic1: if a timestamp field value is not included in an update
321 // statement MySQL auto-update it to the current timestamp
322 $backup_field = ($row_table_def['True_Type'] == 'timestamp')
324 : '<input type="hidden" name="fields_prev[' . urlencode($field) . ']" value="' . urlencode($row[$rowfield]) . '" />';
326 // loic1: display default values
327 if (!isset($row_table_def['Default'])) {
328 $row_table_def['Default'] = '';
331 $data = $row_table_def['Default'];
333 $special_chars = htmlspecialchars($row_table_def['Default']);
337 // The function column
338 // -------------------
339 // Change by Bernard M. Piller <bernard@bmpsystems.com>
340 // We don't want binary data to be destroyed
341 // Note: from the MySQL manual: "BINARY doesn't affect how the column is
342 // stored or retrieved" so it does not mean that the contents is
344 if ($cfg['ShowFunctionFields']) {
345 if (($cfg['ProtectBinary'] && $is_blob)
346 ||
($cfg['ProtectBinary'] == 'all' && $is_binary)) {
347 echo ' <td align="center" bgcolor="'. $bgcolor . '">' . $strBinary . '</td>' . "\n";
348 } else if (strstr($row_table_def['True_Type'], 'enum') ||
strstr($row_table_def['True_Type'], 'set')) {
349 echo ' <td align="center" bgcolor="'. $bgcolor . '">--</td>' . "\n";
352 <td bgcolor
="<?php echo $bgcolor; ?>">
353 <select name
="funcs[<?php echo urlencode($field); ?>]" <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($fields_cnt + $i + 1); ?>" id
="field_<?php echo $i; ?>_1">
359 // garvin: Find the current type in the RestrictColumnTypes. Will result in 'FUNC_CHAR'
360 // or something similar. Then directly look up the entry in the RestrictFunctions array,
361 // which will then reveal the available dropdown options
362 if (isset($cfg['RestrictFunctions']) && isset($cfg['RestrictColumnTypes']) && isset($cfg['RestrictColumnTypes'][strtoupper($row_table_def['True_Type'])]) && isset($cfg['RestrictFunctions'][$cfg['RestrictColumnTypes'][strtoupper($row_table_def['True_Type'])]])) {
363 $dropdown = $cfg['RestrictFunctions'][$cfg['RestrictColumnTypes'][strtoupper($row_table_def['True_Type'])]];
368 $dropdown_built = array();
369 $op_spacing_needed = FALSE;
371 // garvin: loop on the dropdown array and print all available options for that field.
372 for ($j = 0; $j < count($dropdown); $j++
) {
373 // for default function = NOW() on first timestamp field
375 $selected = ($first_timestamp && $dropdown[$j] == 'NOW')
376 ?
' selected="selected"'
379 echo '<option' . $selected . '>' . $dropdown[$j] . '</option>' . "\n";
380 $dropdown_built[$dropdown[$j]] = 'TRUE';
381 $op_spacing_needed = TRUE;
384 // garvin: For compatibility's sake, do not let out all other functions. Instead
385 // print a seperator (blank) and then show ALL functions which weren't shown
387 for ($j = 0; $j < count($cfg['Functions']); $j++
) {
388 if (!isset($dropdown_built[$cfg['Functions'][$j]]) ||
$dropdown_built[$cfg['Functions'][$j]] != 'TRUE') {
389 // for default function = NOW() on first timestamp field
391 $selected = ($first_timestamp && $cfg['Functions'][$j] == 'NOW')
392 ?
' selected="selected"'
394 if ($op_spacing_needed == TRUE) {
396 echo '<option value="">--------</option>' . "\n";
397 $op_spacing_needed = FALSE;
401 echo '<option' . $selected . '>' . $cfg['Functions'][$j] . '</option>' . "\n";
410 } // end if ($cfg['ShowFunctionFields'])
415 echo ' <td bgcolor="' . $bgcolor . '">' . "\n";
416 if (!(($cfg['ProtectBinary'] && $is_blob) ||
($cfg['ProtectBinary'] == 'all' && $is_binary))
417 && $row_table_def['Null'] == 'YES') {
418 echo ' <input type="checkbox" tabindex="' . ((2 * $fields_cnt) +
$i +
1) . '"'
419 . ' name="fields_null[' . urlencode($field) . ']"';
420 if ($data == 'NULL' && !$first_timestamp) {
421 echo ' checked="checked"';
423 echo ' id="field_' . $i . '_2"';
424 $onclick = ' onclick="if (this.checked) {nullify(';
425 if (strstr($row_table_def['True_Type'], 'enum')) {
426 if (strlen($row_table_def['Type']) > 20) {
431 } else if (strstr($row_table_def['True_Type'], 'set')) {
433 } else if ($foreigners && isset($foreigners[$field])) {
438 $onclick .= '\'' . urlencode($field) . '\', \'' . md5($field) . '\'); this.checked = true}; return true" />' . "\n";
441 echo ' ' . "\n";
443 echo ' </td>' . "\n";
445 // The value column (depends on type)
448 include('./libraries/get_foreign.lib.php3');
450 if (isset($foreign_link) && $foreign_link == true) {
452 <td bgcolor
="<?php echo $bgcolor; ?>">
453 <?php
echo $backup_field . "\n"; ?
>
454 <input type
="hidden" name
="fields_type[<?php echo urlencode($field); ?>]" value
="foreign" />
455 <input type
="hidden" name
="fields[<?php echo urlencode($field); ?>]" value
="" id
="field_<?php echo $i; ?>_1" />
456 <input type
="text" name
="field_<?php echo md5($field); ?>[]" class="textfield" <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($i + 1); ?>" id
="field_<?php echo $i; ?>_3" value
="<?php echo htmlspecialchars($data); ?>" />
457 <script type
="text/javascript" language
="javascript">
458 document
.writeln('<a target="_blank" onclick="window.open(this.href, \'foreigners\', \'width=640,height=240,scrollbars=yes\'); return false" href="browse_foreigners.php3?<?php echo PMA_generate_common_url($db, $table); ?>&field=<?php echo urlencode($field); ?>"><?php echo str_replace("'", "\'
", $titles['Browse']); ?></a>');
462 } else if (isset($disp) && $disp) {
464 <td bgcolor="<?php
echo $bgcolor; ?
>">
465 <?php echo $backup_field . "\n
"; ?>
466 <input type="hidden
" name="fields_type
[<?php
echo urlencode($field); ?
>]" value="foreign
" />
467 <input type="hidden
" name="fields
[<?php
echo urlencode($field); ?
>]" value="" id="field_
<?php
echo $i; ?
>_1
" />
468 <select name="field_
<?php
echo md5($field); ?
>[]" <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" id="field_
<?php
echo $i; ?
>_3
">
469 <?php echo PMA_foreignDropdown($disp, $foreign_field, $foreign_display, $data, 100); ?>
475 else if ($cfg['LongtextDoubleTextarea'] && strstr($type, 'longtext')) {
477 <td bgcolor="<?php
echo $bgcolor; ?
>"> </td>
480 <td colspan="4" align="right
" bgcolor="<?php
echo $bgcolor; ?
>">
481 <?php echo $backup_field . "\n
"; ?>
482 <textarea name="fields
[<?php
echo urlencode($field); ?
>]" rows="<?php
echo ($cfg['TextareaRows']*2); ?
>" cols="<?php
echo ($cfg['TextareaCols']*2); ?
>" wrap="virtual
" dir="<?php
echo $text_dir; ?
>" id="field_
<?php
echo $i; ?
>_3
"
483 <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>"><?php echo $special_chars; ?></textarea>
487 else if (strstr($type, 'text')) {
489 <td bgcolor="<?php
echo $bgcolor; ?
>">
490 <?php echo $backup_field . "\n
"; ?>
491 <textarea name="fields
[<?php
echo urlencode($field); ?
>]" rows="<?php
echo $cfg['TextareaRows']; ?
>" cols="<?php
echo $cfg['TextareaCols']; ?
>" wrap="virtual
" dir="<?php
echo $text_dir; ?
>" id="field_
<?php
echo $i; ?
>_3
"
492 <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>"><?php echo $special_chars; ?></textarea>
496 if (strlen($special_chars) > 32000) {
497 echo ' <td bgcolor="' . $bgcolor . '">' . $strTextAreaLength . '</td>' . "\n
";
500 else if ($type == 'enum') {
501 $enum = PMA_getEnumSetOptions($row_table_def['Type']);
502 $enum_cnt = count($enum);
504 <td bgcolor="<?php
echo $bgcolor; ?
>">
505 <input type="hidden
" name="fields_type
[<?php
echo urlencode($field); ?
>]" value="enum
" />
506 <input type="hidden
" name="fields
[<?php
echo urlencode($field); ?
>]" value="" />
508 echo "\n
" . ' ' . $backup_field;
510 // show dropdown or radio depend on length
511 if (strlen($row_table_def['Type']) > 20) {
514 <select name="field_
<?php
echo md5($field); ?
>[]" <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" id="field_
<?php
echo $i; ?
>_3
">
515 <option value=""></option>
519 for ($j = 0; $j < $enum_cnt; $j++) {
520 // Removes automatic MySQL escape format
521 $enum_atom = str_replace('\'\'', '\'', str_replace('\\\\', '\\', $enum[$j]));
523 echo '<option value="' . htmlspecialchars($enum_atom) . '"';
524 if ($data == $enum_atom
525 || ($data == '' && (!isset($primary_key) || $row_table_def['Null'] != 'YES')
526 && isset($row_table_def['Default']) && $enum_atom == $row_table_def['Default'])) {
527 echo ' selected="selected
"';
529 echo '>' . htmlspecialchars($enum_atom) . '</option>' . "\n
";
538 for ($j = 0; $j < $enum_cnt; $j++) {
539 // Removes automatic MySQL escape format
540 $enum_atom = str_replace('\'\'', '\'', str_replace('\\\\', '\\', $enum[$j]));
542 echo '<input type="radio
" name="field_
' . md5($field) . '[]" value="' . urlencode($enum_atom) . '" id="field_
' . $i . '_3_
' . $j . '" onclick="if (typeof(document
.forms
[\'insertForm\'
].elements
[\'fields_null
[' . urlencode($field) . ']\']) != \'undefined\'
) {document
.forms
[\'insertForm\'
].elements
[\'fields_null
[' . urlencode($field) .']\'].checked
= false}"';
543 if ($data == $enum_atom
544 || ($data == '' && (!isset($primary_key) || $row_table_def['Null'] != 'YES')
545 && isset($row_table_def['Default']) && $enum_atom == $row_table_def['Default'])) {
546 echo ' checked="checked
"';
548 echo 'tabindex="' . ($i + 1) . '" />' . "\n
";
549 echo ' <label for="field_
' . $i . '_3_
' . $j . '">' . htmlspecialchars($enum_atom) . '</label>' . "\n
";
559 else if ($type == 'set') {
560 $set = PMA_getEnumSetOptions($row_table_def['Type']);
565 for ($vals = explode(',', $data); list($t, $k) = each($vals);) {
568 $countset = count($set);
569 $size = min(4, $countset);
571 <td bgcolor="<?php
echo $bgcolor; ?
>">
572 <?php echo $backup_field . "\n
"; ?>
573 <input type="hidden
" name="fields_type
[<?php
echo urlencode($field); ?
>]" value="set
" />
574 <input type="hidden
" name="fields
[<?php
echo urlencode($field); ?
>]" value="" />
575 <select name="field_
<?php
echo md5($field); ?
>[]" size="<?php
echo $size; ?
>" multiple="multiple
" <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" id="field_
<?php
echo $i; ?
>_3
">
578 for ($j = 0; $j < $countset; $j++) {
580 echo '<option value="'. htmlspecialchars($set[$j]) . '"';
581 if (isset($vset[$set[$j]]) && $vset[$set[$j]]) {
582 echo ' selected="selected
"';
584 echo '>' . htmlspecialchars($set[$j]) . '</option>' . "\n
";
591 // Change by Bernard M. Piller <bernard@bmpsystems.com>
592 // We don't want binary data destroyed
593 else if ($is_binary || $is_blob) {
594 if (($cfg['ProtectBinary'] && $is_blob)
595 || ($cfg['ProtectBinary'] == 'all' && $is_binary)) {
598 <td align="center
" bgcolor="<?php
echo $bgcolor; ?
>">
600 echo $strBinaryDoNotEdit;
602 $data_size = PMA_formatByteDown(strlen(stripslashes($data)), 3, 1);
603 echo ' ('. $data_size [0] . ' ' . $data_size[1] . ')';
608 <input type="hidden
" name="fields_type
[<?php
echo urlencode($field); ?
>]" value="protected" />
609 <input type="hidden
" name="fields
[<?php
echo urlencode($field); ?
>]" value="" />
611 } else if ($is_blob) {
614 <td bgcolor="<?php
echo $bgcolor; ?
>">
615 <?php echo $backup_field . "\n
"; ?>
616 <textarea name="fields
[<?php
echo urlencode($field); ?
>]" rows="<?php
echo $cfg['TextareaRows']; ?
>" cols="<?php
echo $cfg['TextareaCols']; ?
>" wrap="virtual
" dir="<?php
echo $text_dir; ?
>" id="field_
<?php
echo $i; ?
>_3
"
617 <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" ><?php echo $special_chars; ?></textarea>
622 $fieldsize = $maxlength = 4;
624 $fieldsize = (($len > 40) ? 40 : $len);
629 <td bgcolor="<?php
echo $bgcolor; ?
>">
630 <?php echo $backup_field . "\n
"; ?>
631 <input type="text
" name="fields
[<?php
echo urlencode($field); ?
>]" value="<?php
echo $special_chars; ?
>" size="<?php
echo $fieldsize; ?
>" maxlength="<?php
echo $maxlength; ?
>" class="textfield
" <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" id="field_
<?php
echo $i; ?
>_3
" />
633 } // end if...elseif...else
635 // Upload choice (only for BLOBs because the binary
636 // attribute does not imply binary contents)
637 // (displayed whatever value the ProtectBinary has)
639 if ($is_upload && $is_blob) {
640 echo '<input type="file
" name="fields_upload_
' . urlencode($field) . '" class="textfield
" id="field_
' . $i . '_3
" />';
643 if ($cfg['UploadDir'] != '') {
644 if ($handle = @opendir($cfg['UploadDir'])) {
646 while ($file = @readdir($handle)) {
647 if (is_file($cfg['UploadDir'] . $file) && substr($file, -4) != '.sql') {
648 if ($is_first == 0) {
650 echo ' <i>' . $strOr . '</i>' . ' ' . $strWebServerUploadDirectory . ' :<br />' . "\n
";
651 echo ' <select size="1" name="fields_uploadlocal_
' . urlencode($field) . '">' . "\n
";
652 echo ' <option value="" selected="selected
"></option>' . "\n
";
653 } // end if (is_first)
654 echo ' <option value="' . htmlspecialchars($file) . '">' . htmlspecialchars($file) . '</option>' . "\n
";
656 } // end if (is_file)
659 echo ' </select>' . "\n
";
660 } // end if (isfirst > 0)
663 echo ' <font color="red
">' . $strError . '</font><br />' . "\n
";
664 echo ' ' . $strWebServerUploadDirectoryError . "\n
";
666 } // end if (web-server upload directory)
670 } // end else if ( binary or blob)
672 // For char or varchar, respect the maximum length (M); for other
673 // types (int or float), the length is not a limit on the values that
674 // can be entered, so let's be generous (20) (we could also use the
675 // real limits for each numeric type)
677 $fieldsize = (($len > 40) ? 40 : $len);
681 $fieldsize = $maxlength = 20;
682 } // end if... else...
685 <td bgcolor="<?php
echo $bgcolor; ?
>">
686 <?php echo $backup_field . "\n
"; ?>
688 if ($is_char && isset($cfg['CharEditing']) && ($cfg['CharEditing'] == 'textarea')) {
691 <textarea name="fields
[<?php
echo urlencode($field); ?
>]" rows="<?php
echo $cfg['CharTextareaRows']; ?
>" cols="<?php
echo $cfg['CharTextareaCols']; ?
>" wrap="virtual
" dir="<?php
echo $text_dir; ?
>" id="field_
<?php
echo $i; ?
>_3
"
692 <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" ><?php echo $special_chars; ?></textarea>
697 <input type="text
" name="fields
[<?php
echo urlencode($field); ?
>]" value="<?php
echo $special_chars; ?
>" size="<?php
echo $fieldsize; ?
>" maxlength="<?php
echo $maxlength; ?
>" class="textfield
" <?php echo $chg_evt_handler; ?>="return unNullify('<?php echo urlencode($field); ?>')" tabindex="<?php
echo ($i +
1); ?
>" id="field_
<?php
echo $i; ?
>_3
" />
715 <table cellpadding="5">
717 <td valign="middle
" nowrap="nowrap
">
719 if (isset($primary_key)) {
721 <input type="radio
" name="submit_type
" value="<?php
echo $strSave; ?
>" id="radio_submit_type_save
" checked="checked
" tabindex="<?php
echo ((3 * $fields_cnt) +
1); ?
>" /><label for="radio_submit_type_save
"><?php echo $strSave; ?></label><br />
722 <?php echo $strOr; ?><br />
723 <input type="radio
" name="submit_type
" value="<?php
echo $strInsertAsNewRow; ?
>" id="radio_submit_type_insert_as_new_row
" tabindex="<?php
echo ((3 * $fields_cnt) +
2); ?
>" /><label for="radio_submit_type_insert_as_new_row
"><?php echo $strInsertAsNewRow; ?></label>
728 <input type="hidden
" name="submit_type
" value="<?php
echo $strInsertAsNewRow; ?
>" />
730 echo ' ' . $strInsertAsNewRow . "\n
";
734 // Defines whether "insert a
new row after the current insert
" should be
735 // checked or not (keep this choice sticky)
736 // but do not check both radios, because Netscape 4.8 would display both checked
737 if (!empty($disp_message)) {
738 $checked_after_insert_new_insert = ' checked="checked
"';
739 $checked_after_insert_back = '';
741 $checked_after_insert_back = ' checked="checked
"';
742 $checked_after_insert_new_insert = '';
747 <b>-- <?php echo $strAnd; ?> --</b>
749 <td valign="middle
" nowrap="nowrap
">
750 <input type="radio
" name="after_insert
" value="back
" id="radio_after_insert_back
" <?php echo $checked_after_insert_back; ?> tabindex="<?php
echo ((3 * $fields_cnt) +
3); ?
>" /><label for="radio_after_insert_back
"><?php echo $strAfterInsertBack; ?></label><br />
751 <?php echo $strOr; ?><br />
752 <input type="radio
" name="after_insert
" value="new_insert
" id="radio_after_insert_new_insert
"<?php echo $checked_after_insert_new_insert; ?> tabindex="<?php
echo ((3 * $fields_cnt) +
4); ?
>" /><label for="radio_after_insert_new_insert
"><?php echo $strAfterInsertNewInsert; ?></label>
757 <td colspan="3" align="right
" valign="middle
">
758 <input type="submit
" value="<?php
echo $strGo; ?
>" tabindex="<?php
echo ((3 * $fields_cnt) +
5); ?
>" />
759 <input type="reset
" value="<?php
echo $strReset; ?
>" tabindex="<?php
echo ((3 * $fields_cnt) +
6); ?
>" />
769 * Displays the footer
772 require('./footer.inc.php3');