tbl_addfield.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Displays add field form and handles it
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 declare(strict_types=1);
   9
  10 use PhpMyAdmin\CreateAddField;
  11 use PhpMyAdmin\DatabaseInterface;
  12 use PhpMyAdmin\Di\Container;
  13 use PhpMyAdmin\Message;
  14 use PhpMyAdmin\Response;
  15 use PhpMyAdmin\Transformations;
  16 use PhpMyAdmin\Url;
  17 use PhpMyAdmin\Util;
  18
  19 if (! defined('ROOT_PATH')) {
  20     define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
  21 }
  22
  23 /**
  24  * Get some core libraries
  25  */
  26 require_once ROOT_PATH . 'libraries/common.inc.php';
  27
  28 $container = Container::getDefaultContainer();
  29 $container->set(Response::class, Response::getInstance());
  30
  31 /** @var Response $response */
  32 $response = $container->get(Response::class);
  33
  34 /** @var DatabaseInterface $dbi */
  35 $dbi = $container->get(DatabaseInterface::class);
  36
  37 $header = $response->getHeader();
  38 $scripts = $header->getScripts();
  39 $scripts->addFile('tbl_structure.js');
  40
  41 // Check parameters
  42 Util::checkParameters(['db', 'table']);
  43
  44 $transformations = new Transformations();
  45
  46 /**
  47  * Defines the url to return to in case of error in a sql statement
  48  */
  49 $err_url = 'tbl_sql.php' . Url::getCommon(
  50     [
  51         'db' => $db,
  52         'table' => $table,
  53     ]
  54 );
  55
  56 /**
  57  * The form used to define the field to add has been submitted
  58  */
  59 $abort = false;
  60
  61 // check number of fields to be created
  62 if (isset($_POST['submit_num_fields'])) {
  63     if (isset($_POST['orig_after_field'])) {
  64         $_POST['after_field'] = $_POST['orig_after_field'];
  65     }
  66     if (isset($_POST['orig_field_where'])) {
  67         $_POST['field_where'] = $_POST['orig_field_where'];
  68     }
  69     $num_fields = min(
  70         intval($_POST['orig_num_fields']) + intval($_POST['added_fields']),
  71         4096
  72     );
  73     $regenerate = true;
  74 } elseif (isset($_POST['num_fields']) && intval($_POST['num_fields']) > 0) {
  75     $num_fields = min(4096, intval($_POST['num_fields']));
  76 } else {
  77     $num_fields = 1;
  78 }
  79
  80 if (isset($_POST['do_save_data'])) {
  81     //avoid an incorrect calling of PMA_updateColumns() via
  82     //tbl_structure.php below
  83     unset($_POST['do_save_data']);
  84
  85     $createAddField = new CreateAddField($dbi);
  86
  87     list($result, $sql_query) = $createAddField->tryColumnCreationQuery($db, $table, $err_url);
  88
  89     if ($result === true) {
  90         // Update comment table for mime types [MIME]
  91         if (isset($_POST['field_mimetype'])
  92             && is_array($_POST['field_mimetype'])
  93             && $cfg['BrowseMIME']
  94         ) {
  95             foreach ($_POST['field_mimetype'] as $fieldindex => $mimetype) {
  96                 if (isset($_POST['field_name'][$fieldindex])
  97                     && strlen($_POST['field_name'][$fieldindex]) > 0
  98                 ) {
  99                     $transformations->setMime(
 100                         $db,
 101                         $table,
 102                         $_POST['field_name'][$fieldindex],
 103                         $mimetype,
 104                         $_POST['field_transformation'][$fieldindex],
 105                         $_POST['field_transformation_options'][$fieldindex],
 106                         $_POST['field_input_transformation'][$fieldindex],
 107                         $_POST['field_input_transformation_options'][$fieldindex]
 108                     );
 109                 }
 110             }
 111         }
 112
 113         // Go back to the structure sub-page
 114         $message = Message::success(
 115             __('Table %1$s has been altered successfully.')
 116         );
 117         $message->addParam($table);
 118         $response->addJSON(
 119             'message',
 120             Util::getMessage($message, $sql_query, 'success')
 121         );
 122         exit;
 123     } else {
 124         $error_message_html = Util::mysqlDie(
 125             '',
 126             '',
 127             false,
 128             $err_url,
 129             false
 130         );
 131         $response->addHTML($error_message_html);
 132         $response->setRequestStatus(false);
 133         exit;
 134     }
 135 } // end do alter table
 136
 137 /**
 138  * Displays the form used to define the new field
 139  */
 140 if ($abort == false) {
 141     /**
 142      * Gets tables information
 143      */
 144     include_once ROOT_PATH . 'libraries/tbl_common.inc.php';
 145
 146     $active_page = 'tbl_structure.php';
 147     /**
 148      * Display the form
 149      */
 150     $action = 'tbl_addfield.php';
 151     include_once ROOT_PATH . 'libraries/tbl_columns_definition_form.inc.php';
 152 }