tbl_properties_operations.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5
   6 /**
   7  * Runs common work
   8  */
   9 require('./tbl_properties_common.php3');
  10 //$err_url   = 'tbl_properties_operations.php3' . $err_url;
  11 $url_query .= '&amp;goto=tbl_properties_operations.php3&amp;back=tbl_properties_operations.php3';
  12
  13
  14 /**
  15  * Gets relation settings
  16  */
  17 require('./libraries/relation.lib.php3');
  18 $cfgRelation = PMA_getRelationsParam();
  19
  20
  21 /**
  22  * Reordering the table has been requested by the user
  23  */
  24 if (isset($submitorderby) && !empty($order_field)) {
  25     $sql_query   = 'ALTER TABLE ' . PMA_backquote($table)
  26                  . ' ORDER BY ' . PMA_backquote(urldecode($order_field));
  27     $result      = PMA_mysql_query($sql_query) or PMA_mysqlDie('', $sql_query, '', $err_url);
  28     PMA_showMessage($strSuccess);
  29 } // end if
  30
  31
  32 /**
  33  * Gets tables informations and displays top links
  34  */
  35 require('./tbl_properties_table_info.php3');
  36
  37
  38 /**
  39  * Get columns names
  40  */
  41 $local_query = 'SHOW COLUMNS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db);
  42 $result      = PMA_mysql_query($local_query) or PMA_mysqlDie('', $local_query, '', $error_url);
  43 for ($i = 0; $row = PMA_mysql_fetch_array($result); $i++) {
  44         $columns[$i] = $row['Field'];
  45 }
  46 mysql_free_result($result);
  47
  48
  49 /**
  50  * Displays the page
  51  */
  52 ?>
  53 <ul>
  54
  55 <?php
  56 if (PMA_MYSQL_INT_VERSION >= 32334) {
  57     ?>
  58     <!-- Order the table -->
  59     <li>
  60         <form method="post" action="tbl_properties_operations.php3">
  61             <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
  62             <?php echo $strAlterOrderBy; ?>&nbsp;:
  63             <select name="order_field" style="vertical-align: middle">
  64     <?php
  65     echo "\n";
  66     reset($columns);
  67     while (list($junk, $fieldname) = each($columns)) {
  68         echo '                <option value="' . urlencode($fieldname) . '">' . htmlspecialchars($fieldname) . '</option>' . "\n";
  69     }
  70     unset($columns);
  71     ?>
  72             </select>
  73             <input type="submit" name="submitorderby" value="<?php echo $strGo; ?>" style="vertical-align: middle" />
  74             &nbsp;<?php echo $strSingly . "\n"; ?>
  75         </form>
  76     </li>
  77     <?php
  78 }
  79 echo "\n";
  80 ?>
  81
  82     <!-- Change table name -->
  83     <li>
  84         <div style="margin-bottom: 10px">
  85             <form method="post" action="tbl_rename.php3"
  86                 onsubmit="return emptyFormElements(this, 'new_name')">
  87                 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
  88                 <input type="hidden" name="reload" value="1" />
  89                 <?php echo $strRenameTable; ?>&nbsp;:
  90                 <input type="text" size="20" name="new_name" value="<?php echo htmlspecialchars($table); ?>" class="textfield" onfocus="this.select()" />&nbsp;
  91                 <input type="submit" value="<?php echo $strGo; ?>" />
  92             </form>
  93         </div>
  94     </li>
  95
  96     <!-- Move and copy table -->
  97     <li style="vertical-align: top">
  98         <div style="margin-bottom: 10px">
  99         <table border="0" cellspacing="0" cellpadding="0" style="vertical-align: top">
 100         <tr>
 101             <td valign="top">
 102             <form method="post" action="tbl_move_copy.php3"
 103                 onsubmit="return emptyFormElements(this, 'new_name')">
 104                 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 105                 <input type="hidden" name="reload" value="1" />
 106                 <input type="hidden" name="what" value="data" />
 107                 <table border="0" cellspacing="0" cellpadding="0">
 108                 <tr>
 109                     <td nowrap="nowrap">
 110                         <?php echo $strMoveTable . "\n"; ?>
 111                     </td>
 112                 </tr>
 113                 <tr>
 114                     <td>
 115                         <select name="target_db">
 116                             <option value=""></option>
 117 <?php
 118 // The function used below is defined in "common.lib.php3"
 119 PMA_availableDatabases('main.php3?' . PMA_generate_common_url());
 120 for ($i = 0; $i < $num_dbs; $i++) {
 121     echo '                            ';
 122     echo '<option value="' . str_replace('"', '&quot;', $dblist[$i]) . '">' . htmlspecialchars($dblist[$i]) . '</option>';
 123     echo "\n";
 124 } // end for
 125 ?>
 126                         </select>
 127                         &nbsp;<b>.</b>&nbsp;
 128                         <input type="text" size="20" name="new_name" value="<?php echo $table; ?>" class="textfield" onfocus="this.select()" />
 129                     </td>
 130                 </tr>
 131                 <tr>
 132                     <td align="<?php echo $cell_align_right; ?>" valign="top">
 133                         <input type="submit" name="submit_move" value="<?php echo $strGo; ?>" />
 134                     </td>
 135                 </tr>
 136                 </table>
 137             </form>
 138             </td>
 139             <td width="25">&nbsp;</td>
 140             <td valign="top">
 141             <form method="post" action="tbl_move_copy.php3"
 142                 onsubmit="return emptyFormElements(this, 'new_name')">
 143                 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
 144                 <input type="hidden" name="reload" value="1" />
 145                 <table border="0" cellspacing="0" cellpadding="0">
 146                 <tr>
 147                     <td colspan="2" nowrap="nowrap">
 148                         <?php echo $strCopyTable . "\n"; ?>
 149                     </td>
 150                 </tr>
 151                 <tr>
 152                     <td colspan="2">
 153                         <select name="target_db">
 154 <?php
 155 for ($i = 0; $i < $num_dbs; $i++) {
 156     echo '                            ';
 157     echo '<option value="' . str_replace('"', '&quot;', $dblist[$i]) . '"';
 158     if ($dblist[$i] == $db) {
 159         echo ' selected="selected"';
 160     }
 161     echo '>' . htmlspecialchars($dblist[$i]) . '</option>';
 162     echo "\n";
 163 } // end for
 164 ?>
 165                         </select>
 166                         &nbsp;<b>.</b>&nbsp;
 167                         <input type="text" size="20" name="new_name" class="textfield" onfocus="this.select()" />
 168                     </td>
 169                 </tr>
 170                 <tr>
 171                     <td nowrap="nowrap">
 172                         <input type="radio" name="what" value="structure" id="radio_copy_structure" checked="checked" />
 173                         <label for="radio_copy_structure"><?php echo $strStrucOnly; ?></label>&nbsp;&nbsp;<br />
 174                         <input type="radio" name="what" value="data" id="radio_copy_data" />
 175                         <label for="radio_copy_data"><?php echo $strStrucData; ?></label>&nbsp;&nbsp;<br />
 176                         <input type="radio" name="what" value="dataonly" id="radio_copy_data" />
 177                         <label for="radio_copy_data"><?php echo $strDataOnly; ?></label>&nbsp;&nbsp;
 178                     </td>
 179                     <td align="<?php echo $cell_align_right; ?>" valign="top">
 180                         <input type="submit" name="submit_copy" value="<?php echo $strGo; ?>" />
 181                     </td>
 182                 </tr>
 183                 </table>
 184             </form>
 185         </td>
 186     </tr>
 187     </table>
 188     </div>
 189     </li>
 190
 191 <?php
 192 if (PMA_MYSQL_INT_VERSION >= 32322) {
 193     if ($tbl_type == 'MYISAM' or $tbl_type == 'BDB') {
 194         ?>
 195     <!-- Table maintenance -->
 196     <li style="vertical-align: top">
 197         <div style="margin-bottom: 10px">
 198         <table border="0" cellspacing="0" cellpadding="0" style="vertical-align: top">
 199         <tr>
 200             <td><?php echo $strTableMaintenance; ?>&nbsp;:&nbsp;</td>
 201         <?php
 202         echo "\n";
 203         if ($tbl_type == 'MYISAM') {
 204             ?>
 205             <td>
 206                 <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('CHECK TABLE ' . PMA_backquote($table)); ?>">
 207                     <?php echo $strCheckTable; ?></a>&nbsp;
 208                 <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'CHECK_TABLE') . "\n"; ?>
 209             </td>
 210             <td>&nbsp;-&nbsp;</td>
 211             <?php
 212         }
 213         echo "\n";
 214         if ($tbl_type == 'MYISAM' || $tbl_type == 'BDB') {
 215             ?>
 216             <td>
 217                 <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('ANALYZE TABLE ' . PMA_backquote($table)); ?>">
 218                     <?php echo $strAnalyzeTable; ?></a>&nbsp;
 219                 <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'ANALYZE_TABLE') . "\n";?>
 220             </td>
 221             <?php
 222         }
 223         echo "\n";
 224         ?>
 225         </tr>
 226         <tr>
 227             <td>&nbsp;</td>
 228         <?php
 229         echo "\n";
 230         if ($tbl_type == 'MYISAM') {
 231             ?>
 232             <td>
 233                 <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('REPAIR TABLE ' . PMA_backquote($table)); ?>">
 234                     <?php echo $strRepairTable; ?></a>&nbsp;
 235                 <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'REPAIR_TABLE') . "\n"; ?>
 236             </td>
 237             <td>&nbsp;-&nbsp;</td>
 238             <?php
 239         }
 240         echo "\n";
 241         if ($tbl_type == 'MYISAM' || $tbl_type == 'BDB') {
 242             ?>
 243             <td>
 244                 <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table)); ?>">
 245                     <?php echo $strOptimizeTable; ?></a>&nbsp;
 246                 <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE') . "\n"; ?>
 247             </td>
 248             <?php
 249         }
 250         echo "\n";
 251         ?>
 252         </tr>
 253         </table><br />
 254         </div>
 255     </li>
 256         <?php
 257     } // end MYISAM or BDB case
 258     echo "\n";
 259 } // end MySQL >= 3.23.22
 260
 261 // loic1: "OPTIMIZE" statement is available for MyISAM and BDB tables only and
 262 //        MyISAM/BDB tables exists since MySQL 3.23.06/3.23.34
 263 else if (PMA_MYSQL_INT_VERSION >= 32306
 264          && ($tbl_type == 'MYISAM' or $tbl_type == 'BDB')) {
 265     ?>
 266     <!-- Table maintenance -->
 267     <li style="vertical-align: top">
 268         <div style="margin-bottom: 10px">
 269         <?php echo $strTableMaintenance; ?>&nbsp;:&nbsp;
 270         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('OPTIMIZE TABLE ' . PMA_backquote($table)); ?>">
 271             <?php echo $strOptimizeTable; ?></a>&nbsp;
 272         <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'OPTIMIZE_TABLE') . "\n"; ?>
 273         </div>
 274     </li>
 275     <?php
 276     echo "\n";
 277 } // end 3.23.06 < MySQL < 3.23.22
 278
 279 // Referential integrity check
 280 if ($cfgRelation['relwork']) {
 281
 282     // we need this PMA_mysql_select_db if the user has access to more than one db
 283     // and $db is not the last of the list, because PMA_availableDatabases()
 284     // has made a PMA_mysql_select_db() on the last one
 285     PMA_mysql_select_db($db);
 286     $foreign = PMA_getForeigners($db, $table);
 287
 288     if ($foreign) {
 289         ?>
 290     <!-- Referential integrity check -->
 291     <li style="vertical-align: top">
 292         <div style="margin-bottom: 10px">
 293         <?php echo $strReferentialIntegrity; ?><br />
 294         <?php
 295         echo "\n";
 296         while (list($master, $arr) = each($foreign)){
 297             $join_query  = 'SELECT ' . PMA_backquote($table) . '.* FROM '
 298                          . PMA_backquote($table) . ' LEFT JOIN '
 299                          . PMA_backquote($arr['foreign_table']);
 300             if ($arr['foreign_table'] == $table) {
 301                 $foreign_table = $table . '1';
 302                 $join_query .= ' AS ' . PMA_backquote($foreign_table);
 303             } else {
 304                 $foreign_table = $arr['foreign_table'];
 305             }
 306             $join_query .= ' ON '
 307                          . PMA_backquote($table) . '.' . PMA_backquote($master)
 308                          . ' = ' . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 309                          . ' WHERE '
 310                          . PMA_backquote($foreign_table) . '.' . PMA_backquote($arr['foreign_field'])
 311                          . ' IS NULL AND '
 312                          . PMA_backquote($table) . '.' . PMA_backquote($master)
 313                          . ' IS NOT NULL';
 314             echo '        '
 315                  . '<a href="sql.php3?' . $url_query
 316                  . '&amp;sql_query='
 317                  . urlencode($join_query)
 318                  . '">' . $master . '&nbsp;->&nbsp;' . $arr['foreign_table'] . '.' . $arr['foreign_field']
 319                  . '</a><br />' . "\n";
 320             unset($foreign_table);
 321             unset($join_query);
 322         } //  end while
 323         ?>
 324         </div>
 325     </li><br />
 326         <?php
 327     } // end if ($result)
 328     echo "\n";
 329
 330 } // end  if (!empty($cfg['Server']['relation']))
 331 ?>
 332
 333     <!-- Flushes the table -->
 334     <li>
 335         <a href="sql.php3?<?php echo $url_query; ?>&amp;sql_query=<?php echo urlencode('FLUSH TABLE ' . PMA_backquote($table)); ?>&amp;zero_rows=<?php echo urlencode(sprintf($strTableHasBeenFlushed, htmlspecialchars($table))); if ($cfg['ShowTooltip']) echo '&amp;reload=1'; ?>">
 336             <?php echo $strFlushTable; ?></a>&nbsp;
 337             <?php echo PMA_showMySQLDocu('MySQL_Database_Administration', 'FLUSH') . "\n"; ?>
 338         <br /><br />
 339     </li>
 340
 341 </ul>
 342
 343 <?php
 344 /**
 345  * Displays the footer
 346  */
 347 echo "\n";
 348 require('./footer.inc.php3');
 349 ?>