tbl_change.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Displays form for editing and inserting new table rows
   5  *
   6  * register_globals_save (mark this file save for disabling register globals)
   7  *
   8  * @package PhpMyAdmin
   9  */
  10 use PMA\libraries\config\PageSettings;
  11 use PMA\libraries\Response;
  12 use PMA\libraries\Util;
  13
  14 /**
  15  * Gets the variables sent or posted to this script and displays the header
  16  */
  17 require_once 'libraries/common.inc.php';
  18 require_once 'libraries/config/user_preferences.forms.php';
  19 require_once 'libraries/config/page_settings.forms.php';
  20
  21 PageSettings::showGroup('Edit');
  22
  23 /**
  24  * Ensures db and table are valid, else moves to the "parent" script
  25  */
  26 require_once 'libraries/db_table_exists.lib.php';
  27
  28 /**
  29  * functions implementation for this script
  30  */
  31 require_once 'libraries/insert_edit.lib.php';
  32 require_once 'libraries/transformations.lib.php';
  33
  34 /**
  35  * Determine whether Insert or Edit and set global variables
  36  */
  37 list(
  38     $insert_mode, $where_clause, $where_clause_array, $where_clauses,
  39     $result, $rows, $found_unique_key, $after_insert
  40 ) = PMA_determineInsertOrEdit(
  41     isset($where_clause) ? $where_clause : null, $db, $table
  42 );
  43 // Increase number of rows if unsaved rows are more
  44 if (!empty($unsaved_values) && count($rows) < count($unsaved_values)) {
  45     $rows = array_fill(0, count($unsaved_values), false);
  46 }
  47 /**
  48  * file listing
  49 */
  50 require_once 'libraries/file_listing.lib.php';
  51
  52 /**
  53  * Defines the url to return to in case of error in a sql statement
  54  * (at this point, $GLOBALS['goto'] will be set but could be empty)
  55  */
  56 if (empty($GLOBALS['goto'])) {
  57     if (mb_strlen($table)) {
  58         // avoid a problem (see bug #2202709)
  59         $GLOBALS['goto'] = 'tbl_sql.php';
  60     } else {
  61         $GLOBALS['goto'] = 'db_sql.php';
  62     }
  63 }
  64
  65
  66 $_url_params = PMA_getUrlParameters($db, $table);
  67 $err_url = $GLOBALS['goto'] . PMA_URL_getCommon($_url_params);
  68 unset($_url_params);
  69
  70 $comments_map = PMA_getCommentsMap($db, $table);
  71
  72 /**
  73  * START REGULAR OUTPUT
  74  */
  75
  76 /**
  77  * Load JavaScript files
  78  */
  79 $response = Response::getInstance();
  80 $header   = $response->getHeader();
  81 $scripts  = $header->getScripts();
  82 $scripts->addFile('functions.js');
  83 $scripts->addFile('sql.js');
  84 $scripts->addFile('tbl_change.js');
  85 $scripts->addFile('big_ints.js');
  86 $scripts->addFile('jquery/jquery-ui-timepicker-addon.js');
  87 $scripts->addFile('jquery/jquery.validate.js');
  88 $scripts->addFile('jquery/additional-methods.js');
  89 $scripts->addFile('gis_data_editor.js');
  90
  91 /**
  92  * Displays the query submitted and its result
  93  *
  94  * $disp_message come from tbl_replace.php
  95  */
  96 if (! empty($disp_message)) {
  97     $response->addHTML(Util::getMessage($disp_message, null));
  98 }
  99
 100 $table_columns = PMA_getTableColumns($db, $table);
 101
 102 // retrieve keys into foreign fields, if any
 103 $foreigners = PMA_getForeigners($db, $table);
 104
 105 // Retrieve form parameters for insert/edit form
 106 $_form_params = PMA_getFormParametersForInsertForm(
 107     $db, $table, $where_clauses, $where_clause_array, $err_url
 108 );
 109
 110 /**
 111  * Displays the form
 112  */
 113 // autocomplete feature of IE kills the "onchange" event handler and it
 114 //        must be replaced by the "onpropertychange" one in this case
 115 $chg_evt_handler = (PMA_USR_BROWSER_AGENT == 'IE'
 116     && PMA_USR_BROWSER_VER >= 5
 117     && PMA_USR_BROWSER_VER < 7
 118 )
 119      ? 'onpropertychange'
 120      : 'onchange';
 121 // Had to put the URI because when hosted on an https server,
 122 // some browsers send wrongly this form to the http server.
 123
 124 $html_output = '';
 125 // Set if we passed the first timestamp field
 126 $timestamp_seen = false;
 127 $columns_cnt     = count($table_columns);
 128
 129 $tabindex              = 0;
 130 $tabindex_for_function = +3000;
 131 $tabindex_for_null     = +6000;
 132 $tabindex_for_value    = 0;
 133 $o_rows                = 0;
 134 $biggest_max_file_size = 0;
 135
 136 $url_params['db'] = $db;
 137 $url_params['table'] = $table;
 138 $url_params = PMA_urlParamsInEditMode(
 139     $url_params, $where_clause_array, $where_clause
 140 );
 141
 142 $has_blob_field = false;
 143 foreach ($table_columns as $column) {
 144     if (PMA_isColumn(
 145         $column,
 146         array('blob', 'tinyblob', 'mediumblob', 'longblob')
 147     )) {
 148         $has_blob_field = true;
 149         break;
 150     }
 151 }
 152
 153 //Insert/Edit form
 154 //If table has blob fields we have to disable ajax.
 155 $html_output .= PMA_getHtmlForInsertEditFormHeader($has_blob_field, $is_upload);
 156
 157 $html_output .= PMA_URL_getHiddenInputs($_form_params);
 158
 159 $titles['Browse'] = Util::getIcon('b_browse.png', __('Browse foreign values'));
 160
 161 // user can toggle the display of Function column and column types
 162 // (currently does not work for multi-edits)
 163 if (! $cfg['ShowFunctionFields'] || ! $cfg['ShowFieldTypesInDataEditView']) {
 164     $html_output .= __('Show');
 165 }
 166
 167 if (! $cfg['ShowFunctionFields']) {
 168     $html_output .= PMA_showTypeOrFunction('function', $url_params, false);
 169 }
 170
 171 if (! $cfg['ShowFieldTypesInDataEditView']) {
 172     $html_output .= PMA_showTypeOrFunction('type', $url_params, false);
 173 }
 174
 175 $GLOBALS['plugin_scripts'] = array();
 176 foreach ($rows as $row_id => $current_row) {
 177     if (empty($current_row)) {
 178         $current_row = array();
 179     }
 180
 181     $jsvkey = $row_id;
 182     $vkey = '[multi_edit][' . $jsvkey . ']';
 183
 184     $current_result = (isset($result) && is_array($result) && isset($result[$row_id])
 185         ? $result[$row_id]
 186         : $result);
 187     $repopulate = array();
 188     $checked = true;
 189     if (isset($unsaved_values[$row_id])) {
 190         $repopulate = $unsaved_values[$row_id];
 191         $checked = false;
 192     }
 193     if ($insert_mode && $row_id > 0) {
 194         $html_output .= PMA_getHtmlForIgnoreOption($row_id, $checked);
 195     }
 196
 197     $html_output .= PMA_getHtmlForInsertEditRow(
 198         $url_params, $table_columns, $comments_map, $timestamp_seen,
 199         $current_result, $chg_evt_handler, $jsvkey, $vkey, $insert_mode,
 200         $current_row, $o_rows, $tabindex, $columns_cnt,
 201         $is_upload, $tabindex_for_function, $foreigners, $tabindex_for_null,
 202         $tabindex_for_value, $table, $db, $row_id, $titles,
 203         $biggest_max_file_size, $text_dir, $repopulate, $where_clause_array
 204     );
 205 } // end foreach on multi-edit
 206 $scripts->addFiles($GLOBALS['plugin_scripts']);
 207 unset($unsaved_values, $checked, $repopulate, $GLOBALS['plugin_scripts']);
 208
 209 if (! isset($after_insert)) {
 210     $after_insert = 'back';
 211 }
 212
 213 //action panel
 214 $html_output .= PMA_getActionsPanel(
 215     $where_clause, $after_insert, $tabindex,
 216     $tabindex_for_value, $found_unique_key
 217 );
 218
 219 if ($biggest_max_file_size > 0) {
 220     $html_output .= '        '
 221         . Util::generateHiddenMaxFileSize(
 222             $biggest_max_file_size
 223         ) . "\n";
 224 }
 225 $html_output .= '</form>';
 226
 227 $html_output .= PMA_getHtmlForGisEditor();
 228 // end Insert/Edit form
 229
 230 if ($insert_mode) {
 231     //Continue insertion form
 232     $html_output .= PMA_getContinueInsertionForm(
 233         $table, $db, $where_clause_array, $err_url
 234     );
 235 }
 236
 237 $response->addHTML($html_output);