2 /* vim: set expandtab sw=4 ts=4 sts=4: */
8 use PMA\libraries\Table
;
9 use PMA\libraries\Response
;
14 require_once './libraries/common.inc.php';
16 $pma_table = new Table($GLOBALS['table'], $GLOBALS['db']);
19 * functions implementation for this script
21 require_once 'libraries/operations.lib.php';
24 * Load JavaScript files
26 $response = Response
::getInstance();
27 $header = $response->getHeader();
28 $scripts = $header->getScripts();
29 $scripts->addFile('tbl_operations.js');
34 require './libraries/tbl_common.inc.php';
35 $url_query .= '&goto=view_operations.php&back=view_operations.php';
36 $url_params['goto'] = $url_params['back'] = 'view_operations.php';
39 * Gets tables information
42 require './libraries/tbl_info.inc.php';
48 if (isset($_REQUEST['submitoptions'])) {
50 $warning_messages = array();
52 if (isset($_REQUEST['new_name'])) {
53 if ($pma_table->rename($_REQUEST['new_name'])) {
54 $_message .= $pma_table->getLastMessage();
56 $GLOBALS['table'] = $pma_table->getName();
60 $_message .= $pma_table->getLastError();
67 // set to success by default, because result set could be empty
68 // (for example, a table rename)
70 if (empty($_message)) {
72 ?
__('Your SQL query has been executed successfully.')
74 // $result should exist, regardless of $_message
75 $_type = $result ?
'success' : 'error';
77 if (! empty($warning_messages)) {
78 $_message = new PMA\libraries\Message
;
79 $_message->addMessages($warning_messages);
80 $_message->isError(true);
81 unset($warning_messages);
83 echo PMA\libraries\Util
::getMessage(
84 $_message, $sql_query, $_type
86 unset($_message, $_type);
89 $url_params['goto'] = 'view_operations.php';
90 $url_params['back'] = 'view_operations.php';
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" />
102 <legend
><?php
echo __('Operations'); ?
></legend
>
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']); ?>"
114 <fieldset
class="tblFooters">
115 <input type
="hidden" name
="submitoptions" value
="1" />
116 <input type
="submit" value
="<?php echo __('Go'); ?>" />
121 $drop_view_url_params = array_merge(
124 'sql_query' => 'DROP VIEW ' . PMA\libraries\Util
::backquote(
127 'goto' => 'tbl_structure.php',
130 'message_to_show' => sprintf(
131 __('View %s has been dropped.'),
132 htmlspecialchars($GLOBALS['table'])
134 'table' => $GLOBALS['table']
137 echo '<div class="operations_half_width">';
138 echo '<fieldset class="caution">';
139 echo '<legend>' , __('Delete data or table') , '</legend>';
142 echo PMA_getDeleteDataOrTableLink(
143 $drop_view_url_params,
145 __('Delete the view (DROP)'),