view_operations.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * View manipulations
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 use PMA\libraries\Table;
   9 use PMA\libraries\Response;
  10
  11 /**
  12  *
  13  */
  14 require_once './libraries/common.inc.php';
  15
  16 $pma_table = new Table($GLOBALS['table'], $GLOBALS['db']);
  17
  18 /**
  19  * functions implementation for this script
  20  */
  21 require_once 'libraries/operations.lib.php';
  22
  23 /**
  24  * Load JavaScript files
  25  */
  26 $response = Response::getInstance();
  27 $header   = $response->getHeader();
  28 $scripts  = $header->getScripts();
  29 $scripts->addFile('tbl_operations.js');
  30
  31 /**
  32  * Runs common work
  33  */
  34 require './libraries/tbl_common.inc.php';
  35 $url_query .= '&amp;goto=view_operations.php&amp;back=view_operations.php';
  36 $url_params['goto'] = $url_params['back'] = 'view_operations.php';
  37
  38 /**
  39  * Gets tables information
  40  */
  41
  42 require './libraries/tbl_info.inc.php';
  43 $reread_info = false;
  44
  45 /**
  46  * Updates if required
  47  */
  48 if (isset($_REQUEST['submitoptions'])) {
  49     $_message = '';
  50     $warning_messages = array();
  51
  52     if (isset($_REQUEST['new_name'])) {
  53         if ($pma_table->rename($_REQUEST['new_name'])) {
  54             $_message .= $pma_table->getLastMessage();
  55             $result = true;
  56             $GLOBALS['table'] = $pma_table->getName();
  57             $reread_info = true;
  58             $reload = true;
  59         } else {
  60             $_message .= $pma_table->getLastError();
  61             $result = false;
  62         }
  63     }
  64 }
  65
  66 if (isset($result)) {
  67     // set to success by default, because result set could be empty
  68     // (for example, a table rename)
  69     $_type = 'success';
  70     if (empty($_message)) {
  71         $_message = $result
  72             ? __('Your SQL query has been executed successfully.')
  73             : __('Error');
  74         // $result should exist, regardless of $_message
  75         $_type = $result ? 'success' : 'error';
  76     }
  77     if (! empty($warning_messages)) {
  78         $_message = new PMA\libraries\Message;
  79         $_message->addMessages($warning_messages);
  80         $_message->isError(true);
  81         unset($warning_messages);
  82     }
  83     echo PMA\libraries\Util::getMessage(
  84         $_message, $sql_query, $_type
  85     );
  86     unset($_message, $_type);
  87 }
  88
  89 $url_params['goto'] = 'view_operations.php';
  90 $url_params['back'] = 'view_operations.php';
  91
  92 /**
  93  * Displays the page
  94  */
  95 ?>
  96 <!-- Table operations -->
  97 <div class="operations_half_width">
  98 <form method="post" action="view_operations.php">
  99 <?php echo PMA_URL_getHiddenInputs($GLOBALS['db'], $GLOBALS['table']); ?>
 100 <input type="hidden" name="reload" value="1" />
 101 <fieldset>
 102     <legend><?php echo __('Operations'); ?></legend>
 103
 104     <table>
 105     <!-- Change view name -->
 106     <tr><td><?php echo __('Rename view to'); ?></td>
 107         <td><input type="text" size="20" name="new_name" onfocus="this.select()"
 108                 value="<?php echo htmlspecialchars($GLOBALS['table']); ?>"
 109                 required />
 110         </td>
 111     </tr>
 112     </table>
 113 </fieldset>
 114 <fieldset class="tblFooters">
 115         <input type="hidden" name="submitoptions" value="1" />
 116         <input type="submit" value="<?php echo __('Go'); ?>" />
 117 </fieldset>
 118 </form>
 119 </div>
 120 <?php
 121 $drop_view_url_params = array_merge(
 122     $url_params,
 123     array(
 124         'sql_query' => 'DROP VIEW ' . PMA\libraries\Util::backquote(
 125             $GLOBALS['table']
 126         ),
 127         'goto' => 'tbl_structure.php',
 128         'reload' => '1',
 129         'purge' => '1',
 130         'message_to_show' => sprintf(
 131             __('View %s has been dropped.'),
 132             htmlspecialchars($GLOBALS['table'])
 133         ),
 134         'table' => $GLOBALS['table']
 135     )
 136 );
 137 echo '<div class="operations_half_width">';
 138 echo '<fieldset class="caution">';
 139 echo '<legend>' , __('Delete data or table') , '</legend>';
 140
 141 echo '<ul>';
 142 echo PMA_getDeleteDataOrTableLink(
 143     $drop_view_url_params,
 144     'DROP VIEW',
 145     __('Delete the view (DROP)'),
 146     'drop_view_anchor'
 147 );
 148 echo '</ul>';
 149 echo '</fieldset>';
 150 echo '</div>';