2 /* vim: set expandtab sw=4 ts=4 sts=4: */
8 use PMA\libraries\Table
;
9 use PMA\libraries\Response
;
10 use PMA\libraries\URL
;
15 require_once './libraries/common.inc.php';
17 $pma_table = new Table($GLOBALS['table'], $GLOBALS['db']);
20 * functions implementation for this script
22 require_once 'libraries/operations.lib.php';
25 * Load JavaScript files
27 $response = Response
::getInstance();
28 $header = $response->getHeader();
29 $scripts = $header->getScripts();
30 $scripts->addFile('tbl_operations.js');
35 require './libraries/tbl_common.inc.php';
36 $url_query .= '&goto=view_operations.php&back=view_operations.php';
37 $url_params['goto'] = $url_params['back'] = 'view_operations.php';
40 * Gets tables information
43 require './libraries/tbl_info.inc.php';
49 if (isset($_REQUEST['submitoptions'])) {
51 $warning_messages = array();
53 if (isset($_REQUEST['new_name'])) {
54 if ($pma_table->rename($_REQUEST['new_name'])) {
55 $_message .= $pma_table->getLastMessage();
57 $GLOBALS['table'] = $pma_table->getName();
61 $_message .= $pma_table->getLastError();
68 // set to success by default, because result set could be empty
69 // (for example, a table rename)
71 if (empty($_message)) {
73 ?
__('Your SQL query has been executed successfully.')
75 // $result should exist, regardless of $_message
76 $_type = $result ?
'success' : 'error';
78 if (! empty($warning_messages)) {
79 $_message = new PMA\libraries\Message
;
80 $_message->addMessages($warning_messages);
81 $_message->isError(true);
82 unset($warning_messages);
84 echo PMA\libraries\Util
::getMessage(
85 $_message, $sql_query, $_type
87 unset($_message, $_type);
90 $url_params['goto'] = 'view_operations.php';
91 $url_params['back'] = 'view_operations.php';
97 <!-- Table operations
-->
98 <div
class="operations_half_width">
99 <form method
="post" action
="view_operations.php">
100 <?php
echo URL
::getHiddenInputs($GLOBALS['db'], $GLOBALS['table']); ?
>
101 <input type
="hidden" name
="reload" value
="1" />
103 <legend
><?php
echo __('Operations'); ?
></legend
>
106 <!-- Change view name
-->
107 <tr
><td
><?php
echo __('Rename view to'); ?
></td
>
108 <td
><input type
="text" size
="20" name
="new_name" onfocus
="this.select()"
109 value
="<?php echo htmlspecialchars($GLOBALS['table']); ?>"
115 <fieldset
class="tblFooters">
116 <input type
="hidden" name
="submitoptions" value
="1" />
117 <input type
="submit" value
="<?php echo __('Go'); ?>" />
122 $drop_view_url_params = array_merge(
125 'sql_query' => 'DROP VIEW ' . PMA\libraries\Util
::backquote(
128 'goto' => 'tbl_structure.php',
131 'message_to_show' => sprintf(
132 __('View %s has been dropped.'),
133 htmlspecialchars($GLOBALS['table'])
135 'table' => $GLOBALS['table']
138 echo '<div class="operations_half_width">';
139 echo '<fieldset class="caution">';
140 echo '<legend>' , __('Delete data or table') , '</legend>';
143 echo PMA_getDeleteDataOrTableLink(
144 $drop_view_url_params,
146 __('Delete the view (DROP)'),