getHeader(); $scripts = $header->getScripts(); $scripts->addFile('tbl_structure.js'); // Check parameters PMA_Util::checkParameters(array('db', 'table')); /** * Defines the url to return to in case of error in a sql statement */ $err_url = 'tbl_sql.php?' . PMA_URL_getCommon($db, $table); /** * The form used to define the field to add has been submitted */ $abort = false; // check number of fields to be created if (isset($_REQUEST['submit_num_fields'])) { if (isset($_REQUEST['orig_after_field'])) { $_REQUEST['after_field'] = $_REQUEST['orig_after_field']; } if (isset($_REQUEST['orig_field_where'])) { $_REQUEST['field_where'] = $_REQUEST['orig_field_where']; } $num_fields = $_REQUEST['orig_num_fields'] + $_REQUEST['added_fields']; $regenerate = true; } elseif (isset($_REQUEST['num_fields']) && intval($_REQUEST['num_fields']) > 0) { $num_fields = (int) $_REQUEST['num_fields']; } else { $num_fields = 1; } if (isset($_REQUEST['do_save_data'])) { //avoid an incorrect calling of PMA_updateColumns() via //tbl_structure.php below unset($_REQUEST['do_save_data']); include_once 'libraries/create_addfield.lib.php'; list($result, $sql_query) = PMA_tryColumnCreationQuery($db, $table, $err_url); if ($result === true) { // If comments were sent, enable relation stuff include_once 'libraries/transformations.lib.php'; // Update comment table for mime types [MIME] if (isset($_REQUEST['field_mimetype']) && is_array($_REQUEST['field_mimetype']) && $cfg['BrowseMIME'] ) { foreach ($_REQUEST['field_mimetype'] as $fieldindex => $mimetype) { if (isset($_REQUEST['field_name'][$fieldindex]) && strlen($_REQUEST['field_name'][$fieldindex]) ) { PMA_setMIME( $db, $table, $_REQUEST['field_name'][$fieldindex], $mimetype, $_REQUEST['field_transformation'][$fieldindex], $_REQUEST['field_transformation_options'][$fieldindex] ); } } } // Go back to the structure sub-page $message = PMA_Message::success( __('Table %1$s has been altered successfully') ); $message->addParam($table); $response->addJSON('message', $message); $response->addJSON( 'sql_query', PMA_Util::getMessage(null, $sql_query) ); exit; } else { $error_message_html = PMA_Util::mysqlDie('', '', '', $err_url, false); $response->addHTML($error_message_html); exit; } } // end do alter table /** * Displays the form used to define the new field */ if ($abort == false) { /** * Gets tables informations */ include_once 'libraries/tbl_common.inc.php'; include_once 'libraries/tbl_info.inc.php'; $active_page = 'tbl_structure.php'; /** * Display the form */ $action = 'tbl_addfield.php'; include_once 'libraries/tbl_columns_definition_form.inc.php'; } ?>