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 // Set if we passed the first timestamp field
181 $fields_cnt = mysql_num_rows($table_def);
183 // Set a flag here because the 'if' would not be valid in the loop
184 // if we set a value in some field
185 $insert_mode = (!isset($row) ?
TRUE : FALSE);
187 for ($i = 0; $i < $fields_cnt; $i++
) {
188 // Display the submit button after every 15 lines --swix
189 // (wanted to use an <a href="#bottom"> and <a name> instead,
190 // but it didn't worked because of the <base href>)
192 if ((($i %
15) == 0) && ($i != 0)) {
195 <th colspan
="5" align
="right">
196 <input type
="submit" value
="<?php echo $strGo; ?>" /> 
;
203 $row_table_def = PMA_mysql_fetch_array($table_def);
204 $row_table_def['True_Type'] = ereg_replace('\\(.*', '', $row_table_def['Type']);
205 $field = $row_table_def['Field'];
207 // garvin: possible workaround. If current field is numerical, do not try to
208 // access the result-array with its 'associative' key but with its numerical
210 if ((PMA_PHP_INT_VERSION
> 40000 && is_numeric($field)) ||
eregi('^[0-9]*$', $field)) {
216 // loic1: current date should not be set as default if the field is NULL
217 // for the current row
218 // lem9: but do not put here the current datetime if there is a default
219 // value (the real default value will be set in the
220 // Default value logic below)
221 if ($row_table_def['Type'] == 'datetime'
222 && (!isset($row_table_def['Default']))) {
225 $row[$rowfield] = date('Y-m-d H:i:s', time());
227 // UPDATE case with an empty and not NULL value under PHP4
228 else if (empty($row[$rowfield]) && function_exists('is_null')) {
229 $row[$rowfield] = (is_null($row[$rowfield]) ?
$row[$rowfield] : date('Y-m-d H:i:s', time()));
231 // UPDATE case with an empty value under PHP3
232 else if (empty($row[$rowfield])) {
233 $row[$rowfield] = date('Y-m-d H:i:s', time());
234 } // end if... else if... else if...
236 $len = (eregi('float|double', $row_table_def['Type']))
238 : @mysql_field_len
($result, $i);
239 $first_timestamp = 0;
241 $bgcolor = ($i %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
244 <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
>
249 $is_binary = eregi(' binary', $row_table_def['Type']);
250 $is_blob = eregi('blob', $row_table_def['Type']);
251 $is_char = eregi('char', $row_table_def['Type']);
252 switch ($row_table_def['True_Type']) {
262 if (!$timestamp_seen) { // can only occur once per table
264 $first_timestamp = 1;
266 $type = $row_table_def['Type'];
267 $type_nowrap = ' nowrap="nowrap"';
271 $type = $row_table_def['Type'];
272 $type_nowrap = ' nowrap="nowrap"';
276 <td align
="center" bgcolor
="<?php echo $bgcolor; ?>"<?php
echo $type_nowrap; ?
>>
282 // Prepares the field value
284 // loic1: null field value
285 if (!isset($row[$rowfield])) {
286 $row[$rowfield] = 'NULL';
288 $data = $row[$rowfield];
290 // loic1: special binary "characters"
291 if ($is_binary ||
$is_blob) {
292 $row[$rowfield] = str_replace("\x00", '\0', $row[$rowfield]);
293 $row[$rowfield] = str_replace("\x08", '\b', $row[$rowfield]);
294 $row[$rowfield] = str_replace("\x0a", '\n', $row[$rowfield]);
295 $row[$rowfield] = str_replace("\x0d", '\r', $row[$rowfield]);
296 $row[$rowfield] = str_replace("\x1a", '\Z', $row[$rowfield]);
298 $special_chars = htmlspecialchars($row[$rowfield]);
299 $data = $row[$rowfield];
300 } // end if... else...
301 // loic1: if a timestamp field value is not included in an update
302 // statement MySQL auto-update it to the current timestamp
303 $backup_field = ($row_table_def['True_Type'] == 'timestamp')
305 : '<input type="hidden" name="fields_prev[' . urlencode($field) . ']" value="' . urlencode($row[$rowfield]) . '" />';
307 // loic1: display default values
308 if (!isset($row_table_def['Default'])) {
309 $row_table_def['Default'] = '';
312 $data = $row_table_def['Default'];
314 $special_chars = htmlspecialchars($row_table_def['Default']);
318 // The function column
319 // -------------------
320 // Change by Bernard M. Piller <bernard@bmpsystems.com>
321 // We don't want binary data to be destroyed
322 // Note: from the MySQL manual: "BINARY doesn't affect how the column is
323 // stored or retrieved" so it does not mean that the contents is
325 if ($cfg['ShowFunctionFields']) {
326 if (($cfg['ProtectBinary'] && $is_blob)
327 ||
($cfg['ProtectBinary'] == 'all' && $is_binary)) {
328 echo ' <td align="center" bgcolor="'. $bgcolor . '">' . $strBinary . '</td>' . "\n";
329 } else if (strstr($row_table_def['True_Type'], 'enum') ||
strstr($row_table_def['True_Type'], 'set')) {
330 echo ' <td align="center" bgcolor="'. $bgcolor . '">--</td>' . "\n";
333 <td bgcolor
="<?php echo $bgcolor; ?>">
334 <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">
340 // garvin: Find the current type in the RestrictColumnTypes. Will result in 'FUNC_CHAR'
341 // or something similar. Then directly look up the entry in the RestrictFunctions array,
342 // which will then reveal the available dropdown options
343 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'])]])) {
344 $dropdown = $cfg['RestrictFunctions'][$cfg['RestrictColumnTypes'][strtoupper($row_table_def['True_Type'])]];
349 $dropdown_built = array();
350 $op_spacing_needed = FALSE;
352 // garvin: loop on the dropdown array and print all available options for that field.
353 for ($j = 0; $j < count($dropdown); $j++
) {
354 // for default function = NOW() on first timestamp field
356 $selected = ($first_timestamp && $dropdown[$j] == 'NOW')
357 ?
' selected="selected"'
360 echo '<option' . $selected . '>' . $dropdown[$j] . '</option>' . "\n";
361 $dropdown_built[$dropdown[$j]] = 'TRUE';
362 $op_spacing_needed = TRUE;
365 // garvin: For compatibility's sake, do not let out all other functions. Instead
366 // print a seperator (blank) and then show ALL functions which weren't shown
368 for ($j = 0; $j < count($cfg['Functions']); $j++
) {
369 if (!isset($dropdown_built[$cfg['Functions'][$j]]) ||
$dropdown_built[$cfg['Functions'][$j]] != 'TRUE') {
370 // for default function = NOW() on first timestamp field
372 $selected = ($first_timestamp && $cfg['Functions'][$j] == 'NOW')
373 ?
' selected="selected"'
375 if ($op_spacing_needed == TRUE) {
377 echo '<option value="">--------</option>' . "\n";
378 $op_spacing_needed = FALSE;
382 echo '<option' . $selected . '>' . $cfg['Functions'][$j] . '</option>' . "\n";
391 } // end if ($cfg['ShowFunctionFields'])
396 echo ' <td bgcolor="' . $bgcolor . '">' . "\n";
397 if (!(($cfg['ProtectBinary'] && $is_blob) ||
($cfg['ProtectBinary'] == 'all' && $is_binary))
398 && $row_table_def['Null'] == 'YES') {
399 echo ' <input type="checkbox" tabindex="' . ((2 * $fields_cnt) +
$i +
1) . '"'
400 . ' name="fields_null[' . urlencode($field) . ']"';
401 if ($data == 'NULL' && !$first_timestamp) {
402 echo ' checked="checked"';
404 echo ' id="field_' . $i . '_2"';
405 $onclick = ' onclick="if (this.checked) {nullify(';
406 if (strstr($row_table_def['True_Type'], 'enum')) {
407 if (strlen($row_table_def['Type']) > 20) {
412 } else if (strstr($row_table_def['True_Type'], 'set')) {
414 } else if ($foreigners && isset($foreigners[$field])) {
419 $onclick .= '\'' . urlencode($field) . '\', \'' . md5($field) . '\'); this.checked = true}; return true" />' . "\n";
422 echo ' ' . "\n";
424 echo ' </td>' . "\n";
426 // The value column (depends on type)
429 include('./libraries/get_foreign.lib.php3');
431 if (isset($disp) && $disp) {
433 <td bgcolor
="<?php echo $bgcolor; ?>">
434 <?php
echo $backup_field . "\n"; ?
>
435 <input type
="hidden" name
="fields_type[<?php echo urlencode($field); ?>]" value
="foreign" />
436 <input type
="hidden" name
="fields[<?php echo urlencode($field); ?>]" value
="" id
="field_<?php echo $i; ?>_1" />
437 <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">
438 <option value
=""></option
>
441 $reloptions = array('content-id' => array(), 'id-content' => array());
442 while ($relrow = @PMA_mysql_fetch_array
($disp)) {
443 $key = $relrow[$foreign_field];
444 if (strlen($relrow[$foreign_display]) <= $cfg['LimitChars']) {
445 $value = (($foreign_display != FALSE) ?
htmlspecialchars($relrow[$foreign_display]) : '');
448 $vtitle = htmlspecialchars($relrow[$foreign_display]);
449 $value = (($foreign_display != FALSE) ?
htmlspecialchars(substr($vtitle, 0, $cfg['LimitChars']) . '...') : '');
452 $reloption = ' <option value="' . htmlspecialchars($key) . '"';
454 $reloption .= ' title="' . $vtitle . '"';
458 $reloption .= ' selected="selected"';
461 $reloptions['id-content'][] = $reloption . '>' . $value . ' - ' . htmlspecialchars($key) . '</option>' . "\n";
462 $reloptions['content-id'][] = $reloption . '>' . htmlspecialchars($key) . ' - ' . $value . '</option>' . "\n";
465 if (count($reloptions['content-id']) < 100) {
466 echo implode('', $reloptions['content-id']);
467 if (count($reloptions['content-id']) > 0) {
468 echo ' <option value=""></option>' . "\n";
469 echo ' <option value=""></option>' . "\n";
472 echo implode('', $reloptions['id-content']);
473 echo ' </select>' . "\n";
474 echo ' </td>' . "\n";
477 else if ($cfg['LongtextDoubleTextarea'] && strstr($type, 'longtext')) {
479 <td bgcolor
="<?php echo $bgcolor; ?>"> 
;</td
>
482 <td colspan
="4" align
="right" bgcolor
="<?php echo $bgcolor; ?>">
483 <?php
echo $backup_field . "\n"; ?
>
484 <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"
485 <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($i + 1); ?>"><?php
echo $special_chars; ?
></textarea
>
489 else if (strstr($type, 'text')) {
491 <td bgcolor
="<?php echo $bgcolor; ?>">
492 <?php
echo $backup_field . "\n"; ?
>
493 <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"
494 <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($i + 1); ?>"><?php
echo $special_chars; ?
></textarea
>
498 if (strlen($special_chars) > 32000) {
499 echo ' <td bgcolor="' . $bgcolor . '">' . $strTextAreaLength . '</td>' . "\n";
502 else if ($type == 'enum') {
503 $enum = PMA_getEnumSetOptions($row_table_def['Type']);
504 $enum_cnt = count($enum);
506 <td bgcolor
="<?php echo $bgcolor; ?>">
507 <input type
="hidden" name
="fields_type[<?php echo urlencode($field); ?>]" value
="enum" />
508 <input type
="hidden" name
="fields[<?php echo urlencode($field); ?>]" value
="" />
510 echo "\n" . ' ' . $backup_field;
512 // show dropdown or radio depend on length
513 if (strlen($row_table_def['Type']) > 20) {
516 <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">
517 <option value
=""></option
>
521 for ($j = 0; $j < $enum_cnt; $j++
) {
522 // Removes automatic MySQL escape format
523 $enum_atom = str_replace('\'\'', '\'', str_replace('\\\\', '\\', $enum[$j]));
525 echo '<option value="' . htmlspecialchars($enum_atom) . '"';
526 if ($data == $enum_atom
527 ||
($data == '' && (!isset($primary_key) ||
$row_table_def['Null'] != 'YES')
528 && isset($row_table_def['Default']) && $enum_atom == $row_table_def['Default'])) {
529 echo ' selected="selected"';
531 echo '>' . htmlspecialchars($enum_atom) . '</option>' . "\n";
540 for ($j = 0; $j < $enum_cnt; $j++
) {
541 // Removes automatic MySQL escape format
542 $enum_atom = str_replace('\'\'', '\'', str_replace('\\\\', '\\', $enum[$j]));
544 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}"';
545 if ($data == $enum_atom
546 ||
($data == '' && (!isset($primary_key) ||
$row_table_def['Null'] != 'YES')
547 && isset($row_table_def['Default']) && $enum_atom == $row_table_def['Default'])) {
548 echo ' checked="checked"';
550 echo 'tabindex="' . ($i +
1) . '" />' . "\n";
551 echo ' <label for="field_' . $i . '_3_' . $j . '">' . htmlspecialchars($enum_atom) . '</label>' . "\n";
561 else if ($type == 'set') {
562 $set = PMA_getEnumSetOptions($row_table_def['Type']);
567 for ($vals = explode(',', $data); list($t, $k) = each($vals);) {
570 $countset = count($set);
571 $size = min(4, $countset);
573 <td bgcolor
="<?php echo $bgcolor; ?>">
574 <?php
echo $backup_field . "\n"; ?
>
575 <input type
="hidden" name
="fields_type[<?php echo urlencode($field); ?>]" value
="set" />
576 <input type
="hidden" name
="fields[<?php echo urlencode($field); ?>]" value
="" />
577 <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">
580 for ($j = 0; $j < $countset; $j++
) {
582 echo '<option value="'. htmlspecialchars($set[$j]) . '"';
583 if (isset($vset[$set[$j]]) && $vset[$set[$j]]) {
584 echo ' selected="selected"';
586 echo '>' . htmlspecialchars($set[$j]) . '</option>' . "\n";
593 // Change by Bernard M. Piller <bernard@bmpsystems.com>
594 // We don't want binary data destroyed
595 else if ($is_binary ||
$is_blob) {
596 if (($cfg['ProtectBinary'] && $is_blob)
597 ||
($cfg['ProtectBinary'] == 'all' && $is_binary)) {
600 <td align
="center" bgcolor
="<?php echo $bgcolor; ?>">
602 echo $strBinaryDoNotEdit;
604 $data_size = PMA_formatByteDown(strlen(stripslashes($data)), 3, 1);
605 echo ' ('. $data_size [0] . ' ' . $data_size[1] . ')';
610 <input type
="hidden" name
="fields_type[<?php echo urlencode($field); ?>]" value
="protected" />
611 <input type
="hidden" name
="fields[<?php echo urlencode($field); ?>]" value
="" />
613 } else if ($is_blob) {
616 <td bgcolor
="<?php echo $bgcolor; ?>">
617 <?php
echo $backup_field . "\n"; ?
>
618 <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"
619 <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($i + 1); ?>" ><?php
echo $special_chars; ?
></textarea
>
624 $fieldsize = $maxlength = 4;
626 $fieldsize = (($len > 40) ?
40 : $len);
631 <td bgcolor
="<?php echo $bgcolor; ?>">
632 <?php
echo $backup_field . "\n"; ?
>
633 <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" />
635 } // end if...elseif...else
637 // Upload choice (only for BLOBs because the binary
638 // attribute does not imply binary contents)
639 // (displayed whatever value the ProtectBinary has)
641 if ($is_upload && $is_blob) {
642 echo '<input type="file" name="fields_upload_' . urlencode($field) . '" class="textfield" id="field_' . $i . '_3" />';
645 if ($cfg['UploadDir'] != '') {
646 if ($handle = @opendir
($cfg['UploadDir'])) {
648 while ($file = @readdir
($handle)) {
649 if (is_file($cfg['UploadDir'] . $file) && substr($file, -4) != '.sql') {
650 if ($is_first == 0) {
652 echo ' <i>' . $strOr . '</i>' . ' ' . $strWebServerUploadDirectory . ' :<br />' . "\n";
653 echo ' <select size="1" name="fields_uploadlocal_' . urlencode($field) . '">' . "\n";
654 echo ' <option value="" selected="selected"></option>' . "\n";
655 } // end if (is_first)
656 echo ' <option value="' . htmlspecialchars($file) . '">' . htmlspecialchars($file) . '</option>' . "\n";
658 } // end if (is_file)
661 echo ' </select>' . "\n";
662 } // end if (isfirst > 0)
665 echo ' <font color="red">' . $strError . '</font><br />' . "\n";
666 echo ' ' . $strWebServerUploadDirectoryError . "\n";
668 } // end if (web-server upload directory)
672 } // end else if ( binary or blob)
674 // For char or varchar, respect the maximum length (M); for other
675 // types (int or float), the length is not a limit on the values that
676 // can be entered, so let's be generous (20) (we could also use the
677 // real limits for each numeric type)
679 $fieldsize = (($len > 40) ?
40 : $len);
683 $fieldsize = $maxlength = 20;
684 } // end if... else...
687 <td bgcolor
="<?php echo $bgcolor; ?>">
688 <?php
echo $backup_field . "\n"; ?
>
690 if ($is_char && isset($cfg['CharEditing']) && ($cfg['CharEditing'] == 'textarea')) {
693 <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"
694 <?php
echo $chg_evt_handler; ?
>="return unNullify('<?php echo urlencode($field); ?>')" tabindex
="<?php echo ($i + 1); ?>" ><?php
echo $special_chars; ?
></textarea
>
699 <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" />
717 <table cellpadding
="5">
719 <td valign
="middle" nowrap
="nowrap">
721 if (isset($primary_key)) {
723 <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
/>
724  
; 
; 
; 
; 
; 
;<?php
echo $strOr; ?
><br
/>
725 <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
>
730 <input type
="hidden" name
="submit_type" value
="<?php echo $strInsertAsNewRow; ?>" />
732 echo ' ' . $strInsertAsNewRow . "\n";
736 // Defines whether "insert a new row after the current insert" should be
737 // checked or not (keep this choice sticky)
738 $checked = !empty($disp_message) ?
' checked="checked"' : '';
742  
; 
; 
;<b
>-- <?php
echo $strAnd; ?
> --</b
> 
; 
; 
;
744 <td valign
="middle" nowrap
="nowrap">
745 <input type
="radio" name
="after_insert" value
="back" id
="radio_after_insert_back" checked
="checked" tabindex
="<?php echo ((3 * $fields_cnt) + 3); ?>" /><label
for="radio_after_insert_back"><?php
echo $strAfterInsertBack; ?
></label
><br
/>
746  
; 
; 
; 
; 
; 
;<?php
echo $strOr; ?
><br
/>
747 <input type
="radio" name
="after_insert" value
="new_insert" id
="radio_after_insert_new_insert"<?php
echo $checked; ?
> tabindex
="<?php echo ((3 * $fields_cnt) + 4); ?>" /><label
for="radio_after_insert_new_insert"><?php
echo $strAfterInsertNewInsert; ?
></label
>
752 <td colspan
="3" align
="right" valign
="middle">
753 <input type
="submit" value
="<?php echo $strGo; ?>" tabindex
="<?php echo ((3 * $fields_cnt) + 5); ?>" />
754 <input type
="reset" value
="<?php echo $strReset; ?>" tabindex
="<?php echo ((3 * $fields_cnt) + 6); ?>" />
764 * Displays the footer
767 require('./footer.inc.php3');