libraries/sql_query_form.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * functions for displaying the sql query form
   5  *
   6  * @version $Id$
   7  * @usedby  server_sql.php
   8  * @usedby  db_sql.php
   9  * @usedby  tbl_sql.php
  10  * @usedby  tbl_structure.php
  11  * @usedby  tbl_tracking.php
  12  * @usedby  querywindow.php
  13  * @package phpMyAdmin
  14  */
  15 if (! defined('PHPMYADMIN')) {
  16     exit;
  17 }
  18
  19 /**
  20  *
  21  */
  22 require_once './libraries/file_listing.php'; // used for file listing
  23 require_once './libraries/bookmark.lib.php'; // used for file listing
  24
  25 /**
  26  * prints the sql query boxes
  27  *
  28  * @usedby  server_sql.php
  29  * @usedby  db_sql.php
  30  * @usedby  tbl_sql.php
  31  * @usedby  tbl_structure.php
  32  * @usedby  tbl_tracking.php
  33  * @usedby  querywindow.php
  34  * @uses    $GLOBALS['table']
  35  * @uses    $GLOBALS['db']
  36  * @uses    $GLOBALS['server']
  37  * @uses    $GLOBALS['goto']
  38  * @uses    $GLOBALS['is_upload']           from common.inc.php
  39  * @uses    $GLOBALS['sql_query']           from grab_globals.lib.php
  40  * @uses    $GLOBALS['cfg']['DefaultQueryTable']
  41  * @uses    $GLOBALS['cfg']['DefaultQueryDatabase']
  42  * @uses    $GLOBALS['cfg']['Servers']
  43  * @uses    $GLOBALS['cfg']['DefaultTabDatabase']
  44  * @uses    $GLOBALS['cfg']['DefaultQueryDatabase']
  45  * @uses    $GLOBALS['cfg']['DefaultQueryTable']
  46  * @uses    $GLOBALS['cfg']['Bookmark']
  47  * @uses    $GLOBALS['strSuccess']
  48  * @uses    PMA_generate_common_url()
  49  * @uses    PMA_backquote()
  50  * @uses    PMA_DBI_fetch_result()
  51  * @uses    PMA_showMySQLDocu()
  52  * @uses    PMA_generate_common_hidden_inputs()
  53  * @uses    PMA_sqlQueryFormBookmark()
  54  * @uses    PMA_sqlQueryFormInsert()
  55  * @uses    PMA_sqlQueryFormUpload()
  56  * @uses    PMA_DBI_QUERY_STORE
  57  * @uses    PMA_set_enc_form()
  58  * @uses    sprintf()
  59  * @uses    htmlspecialchars()
  60  * @uses    str_replace()
  61  * @uses    md5()
  62  * @uses    function_exists()
  63  * @param   boolean|string  $query          query to display in the textarea
  64  *                                          or true to display last executed
  65  * @param   boolean|string  $display_tab    sql|files|history|full|FALSE
  66  *                                          what part to display
  67  *                                          false if not inside querywindow
  68  * @param   string          $delimiter
  69  */
  70 function PMA_sqlQueryForm($query = true, $display_tab = false, $delimiter = ';')
  71 {
  72     // check tab to display if inside querywindow
  73     if (! $display_tab) {
  74         $display_tab = 'full';
  75         $is_querywindow = false;
  76     } else {
  77         $is_querywindow = true;
  78     }
  79
  80     // query to show
  81     if (true === $query) {
  82         $query = $GLOBALS['sql_query'];
  83     }
  84
  85     // set enctype to multipart for file uploads
  86     if ($GLOBALS['is_upload']) {
  87         $enctype = ' enctype="multipart/form-data"';
  88     } else {
  89         $enctype = '';
  90     }
  91
  92     $table  = '';
  93     $db     = '';
  94     if (! strlen($GLOBALS['db'])) {
  95         // prepare for server related
  96         $goto   = empty($GLOBALS['goto']) ?
  97                     'server_sql.php' : $GLOBALS['goto'];
  98     } elseif (! strlen($GLOBALS['table'])) {
  99         // prepare for db related
 100         $db     = $GLOBALS['db'];
 101         $goto   = empty($GLOBALS['goto']) ?
 102                     'db_sql.php' : $GLOBALS['goto'];
 103     } else {
 104         $table  = $GLOBALS['table'];
 105         $db     = $GLOBALS['db'];
 106         $goto   = empty($GLOBALS['goto']) ?
 107                     'tbl_sql.php' : $GLOBALS['goto'];
 108     }
 109
 110
 111     // start output
 112     if ($is_querywindow) {
 113         ?>
 114         <form method="post" id="sqlqueryform" target="frame_content"
 115               action="import.php"<?php echo $enctype; ?> name="sqlform"
 116               onsubmit="var save_name = window.opener.parent.frame_content.name;
 117               window.opener.parent.frame_content.name = save_name + '<?php echo time(); ?>';
 118               this.target = window.opener.parent.frame_content.name;
 119               return checkSqlQuery(this)">
 120         <?php
 121     } else {
 122         echo '<form method="post" action="import.php" ' . $enctype . ' id="sqlqueryform"'
 123             .' onsubmit="return checkSqlQuery(this)" name="sqlform">' . "\n";
 124     }
 125
 126     if ($is_querywindow) {
 127         echo '<input type="hidden" name="focus_querywindow" value="true" />'
 128             ."\n";
 129         if ($display_tab != 'sql' && $display_tab != 'full') {
 130             echo '<input type="hidden" name="sql_query" value="" />' . "\n";
 131             echo '<input type="hidden" name="show_query" value="1" />' . "\n";
 132         }
 133     }
 134     echo '<input type="hidden" name="is_js_confirmed" value="0" />' . "\n"
 135         .PMA_generate_common_hidden_inputs($db, $table) . "\n"
 136         .'<input type="hidden" name="pos" value="0" />' . "\n"
 137         .'<input type="hidden" name="goto" value="'
 138         .htmlspecialchars($goto) . '" />' . "\n"
 139         .'<input type="hidden" name="zero_rows" value="'
 140         . htmlspecialchars($GLOBALS['strSuccess']) . '" />' . "\n"
 141         .'<input type="hidden" name="prev_sql_query" value="'
 142         . htmlspecialchars($query) . '" />' . "\n";
 143
 144     // display querybox
 145     if ($display_tab === 'full' || $display_tab === 'sql') {
 146         PMA_sqlQueryFormInsert($query, $is_querywindow, $delimiter);
 147     }
 148
 149     // display uploads
 150     if ($display_tab === 'files' && $GLOBALS['is_upload']) {
 151         PMA_sqlQueryFormUpload();
 152     }
 153
 154     // Bookmark Support
 155     if ($display_tab === 'full' || $display_tab === 'history') {
 156         if (! empty($GLOBALS['cfg']['Bookmark'])) {
 157             PMA_sqlQueryFormBookmark();
 158         }
 159     }
 160
 161     // Encoding setting form appended by Y.Kawada
 162     if (function_exists('PMA_set_enc_form')) {
 163         echo PMA_set_enc_form('    ');
 164     }
 165
 166     echo '</form>' . "\n";
 167     if ($is_querywindow) {
 168         ?>
 169         <script type="text/javascript">
 170         //<![CDATA[
 171             if (window.opener) {
 172                 window.opener.parent.insertQuery();
 173             }
 174         //]]>
 175         </script>
 176         <?php
 177     }
 178 }
 179
 180 /**
 181  * prints querybox fieldset
 182  *
 183  * @usedby  PMA_sqlQueryForm()
 184  * @uses    $GLOBALS['text_dir']
 185  * @uses    $GLOBALS['cfg']['TextareaAutoSelect']
 186  * @uses    $GLOBALS['cfg']['TextareaCols']
 187  * @uses    $GLOBALS['cfg']['TextareaRows']
 188  * @uses    $GLOBALS['strShowThisQuery']
 189  * @uses    $GLOBALS['strGo']
 190  * @uses    PMA_USR_OS
 191  * @uses    PMA_USR_BROWSER_AGENT
 192  * @uses    PMA_USR_BROWSER_VER
 193  * @uses    htmlspecialchars()
 194  * @param   string      $query          query to display in the textarea
 195  * @param   boolean     $is_querywindow if inside querywindow or not
 196  * @param   string      $delimiter      default delimiter to use
 197  */
 198 function PMA_sqlQueryFormInsert($query = '', $is_querywindow = false, $delimiter = ';')
 199 {
 200
 201     // enable auto select text in textarea
 202     if ($GLOBALS['cfg']['TextareaAutoSelect']) {
 203         $auto_sel = ' onfocus="selectContent(this, sql_box_locked, true)"';
 204     } else {
 205         $auto_sel = '';
 206     }
 207
 208     // enable locking if inside query window
 209     if ($is_querywindow) {
 210         $locking = ' onkeypress="document.sqlform.elements[\'LockFromUpdate\'].'
 211             .'checked = true;"';
 212         $height = $GLOBALS['cfg']['TextareaRows'] * 1.25;
 213     } else {
 214         $locking = '';
 215         $height = $GLOBALS['cfg']['TextareaRows'] * 2;
 216     }
 217
 218     $table          = '';
 219     $db             = '';
 220     $fields_list    = array();
 221     if (! strlen($GLOBALS['db'])) {
 222         // prepare for server related
 223         $legend = sprintf($GLOBALS['strRunSQLQueryOnServer'],
 224             '&quot;' . htmlspecialchars(
 225                 ! empty($GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose']) ? $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose'] : $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['host']) . '&quot;');
 226     } elseif (! strlen($GLOBALS['table'])) {
 227         // prepare for db related
 228         $db     = $GLOBALS['db'];
 229         // if you want navigation:
 230         $strDBLink = '<a href="' . $GLOBALS['cfg']['DefaultTabDatabase']
 231             . '?' . PMA_generate_common_url($db) . '"';
 232         if ($is_querywindow) {
 233             $strDBLink .= ' target="_self"'
 234                 . ' onclick="this.target=window.opener.frame_content.name"';
 235         }
 236         $strDBLink .= '>'
 237             . htmlspecialchars($db) . '</a>';
 238         // else use
 239         // $strDBLink = htmlspecialchars($db);
 240         $legend = sprintf($GLOBALS['strRunSQLQuery'], $strDBLink);
 241         if (empty($query)) {
 242             $query = str_replace('%d',
 243                 PMA_backquote($db), $GLOBALS['cfg']['DefaultQueryDatabase']);
 244         }
 245     } else {
 246         $table  = $GLOBALS['table'];
 247         $db     = $GLOBALS['db'];
 248         // Get the list and number of fields
 249         // we do a try_query here, because we could be in the query window,
 250         // trying to synchonize and the table has not yet been created
 251         $fields_list = PMA_DBI_fetch_result(
 252             'SHOW FULL COLUMNS FROM ' . PMA_backquote($db)
 253             . '.' . PMA_backquote($GLOBALS['table']));
 254
 255         $strDBLink = '<a href="' . $GLOBALS['cfg']['DefaultTabDatabase']
 256             . '?' . PMA_generate_common_url($db) . '"';
 257         if ($is_querywindow) {
 258             $strDBLink .= ' target="_self"'
 259                 . ' onclick="this.target=window.opener.frame_content.name"';
 260         }
 261         $strDBLink .= '>'
 262             . htmlspecialchars($db) . '</a>';
 263         // else use
 264         // $strDBLink = htmlspecialchars($db);
 265         $legend = sprintf($GLOBALS['strRunSQLQuery'], $strDBLink);
 266         if (empty($query) && count($fields_list)) {
 267             $field_names = array();
 268             foreach ($fields_list as $field) {
 269                 $field_names[] = PMA_backquote($field['Field']);
 270             }
 271             $query =
 272                 str_replace('%d', PMA_backquote($db),
 273                     str_replace('%t', PMA_backquote($table),
 274                         str_replace('%f',
 275                             implode(', ', $field_names),
 276                             $GLOBALS['cfg']['DefaultQueryTable'])));
 277             unset($field_names);
 278         }
 279     }
 280     $legend .= ': ' . PMA_showMySQLDocu('SQL-Syntax', 'SELECT');
 281
 282     if (count($fields_list)) {
 283         $sqlquerycontainer_id = 'sqlquerycontainer';
 284     } else {
 285         $sqlquerycontainer_id = 'sqlquerycontainerfull';
 286     }
 287
 288     echo '<a name="querybox"></a>' . "\n"
 289         .'<div id="queryboxcontainer">' . "\n"
 290         .'<fieldset id="querybox">' . "\n";
 291     echo '<legend>' . $legend . '</legend>' . "\n";
 292     echo '<div id="queryfieldscontainer">' . "\n";
 293     echo '<div id="' . $sqlquerycontainer_id . '">' . "\n"
 294         .'<textarea name="sql_query" id="sqlquery"'
 295         .'  cols="' . $GLOBALS['cfg']['TextareaCols'] . '"'
 296         .'  rows="' . $height . '"'
 297         .'  dir="' . $GLOBALS['text_dir'] . '"'
 298         .$auto_sel . $locking . '>' . htmlspecialchars($query) . '</textarea>' . "\n";
 299     echo '</div>' . "\n";
 300
 301     if (count($fields_list)) {
 302         echo '<div id="tablefieldscontainer">' . "\n"
 303             .'<label>' . $GLOBALS['strFields'] . '</label>' . "\n"
 304             .'<select id="tablefields" name="dummy" '
 305             .'size="' . ($GLOBALS['cfg']['TextareaRows'] - 2) . '" '
 306             .'multiple="multiple" ondblclick="insertValueQuery()">' . "\n";
 307         foreach ($fields_list as $field) {
 308             echo '<option value="'
 309                 .PMA_backquote(htmlspecialchars($field['Field'])) . '"';
 310             if (isset($field['Field']) && strlen($field['Field']) && isset($field['Comment'])) {
 311                 echo ' title="' . htmlspecialchars($field['Comment']) . '"';
 312             }
 313             echo '>' . htmlspecialchars($field['Field']) . '</option>' . "\n";
 314         }
 315         echo '</select>' . "\n"
 316             .'<div id="tablefieldinsertbuttoncontainer">' . "\n";
 317         if ($GLOBALS['cfg']['PropertiesIconic']) {
 318             echo '<input type="button" name="insert" value="&lt;&lt;"'
 319                 .' onclick="insertValueQuery()"'
 320                 .' title="' . $GLOBALS['strInsert'] . '" />' . "\n";
 321         } else {
 322             echo '<input type="button" name="insert"'
 323                 .' value="' . $GLOBALS['strInsert'] . '"'
 324                 .' onclick="insertValueQuery()" />' . "\n";
 325         }
 326         echo '</div>' . "\n"
 327             .'</div>' . "\n";
 328     }
 329
 330     echo '<div class="clearfloat"></div>' . "\n";
 331     echo '</div>' . "\n";
 332
 333     if (! empty($GLOBALS['cfg']['Bookmark'])) {
 334         ?>
 335         <div id="bookmarkoptions">
 336         <div class="formelement">
 337         <label for="bkm_label">
 338             <?php echo $GLOBALS['strBookmarkThis']; ?>:</label>
 339         <input type="text" name="bkm_label" id="bkm_label" value="" />
 340         </div>
 341         <div class="formelement">
 342         <input type="checkbox" name="bkm_all_users" id="id_bkm_all_users"
 343             value="true" />
 344         <label for="id_bkm_all_users">
 345             <?php echo $GLOBALS['strBookmarkAllUsers']; ?></label>
 346         </div>
 347         <div class="formelement">
 348         <input type="checkbox" name="bkm_replace" id="id_bkm_replace"
 349             value="true" />
 350         <label for="id_bkm_replace">
 351             <?php echo $GLOBALS['strBookmarkReplace']; ?></label>
 352         </div>
 353         </div>
 354         <?php
 355     }
 356
 357     echo '<div class="clearfloat"></div>' . "\n";
 358     echo '</fieldset>' . "\n"
 359         .'</div>' . "\n";
 360
 361     echo '<fieldset id="queryboxfooter" class="tblFooters">' . "\n";
 362     echo '<div class="formelement">' . "\n";
 363     if ($is_querywindow) {
 364         ?>
 365         <script type="text/javascript">
 366         //<![CDATA[
 367             document.writeln(' <input type="checkbox" name="LockFromUpdate" value="1" id="checkbox_lock" /> <label for="checkbox_lock"><?php echo $GLOBALS['strQueryWindowLock']; ?></label> ');
 368         //]]>
 369         </script>
 370         <?php
 371     }
 372     echo '</div>' . "\n";
 373     echo '<div class="formelement">' . "\n";
 374     echo '<label for="id_sql_delimiter">[ ' . $GLOBALS['strDelimiter']
 375         .'</label>' . "\n";
 376     echo '<input type="text" name="sql_delimiter" size="3" '
 377         .'value="' . $delimiter . '" '
 378         .'id="id_sql_delimiter" /> ]' . "\n";
 379
 380     echo '<input type="checkbox" name="show_query" value="1" '
 381         .'id="checkbox_show_query" checked="checked" />' . "\n"
 382         .'<label for="checkbox_show_query">' . $GLOBALS['strShowThisQuery']
 383         .'</label>' . "\n";
 384
 385     echo '</div>' . "\n";
 386     echo '<input type="submit" name="SQL" value="' . $GLOBALS['strGo'] . '" />'
 387         ."\n";
 388     echo '<div class="clearfloat"></div>' . "\n";
 389     echo '</fieldset>' . "\n";
 390 }
 391
 392 /**
 393  * prints bookmark fieldset
 394  *
 395  * @usedby  PMA_sqlQueryForm()
 396  * @uses    PMA_Bookmark_getList()
 397  * @uses    $GLOBALS['db']
 398  * @uses    $GLOBALS['pmaThemeImage']
 399  * @uses    $GLOBALS['cfg']['ReplaceHelpImg']
 400  * @uses    $GLOBALS['strBookmarkQuery']
 401  * @uses    $GLOBALS['strBookmarkView']
 402  * @uses    $GLOBALS['strDelete']
 403  * @uses    $GLOBALS['strDocu']
 404  * @uses    $GLOBALS['strGo']
 405  * @uses    $GLOBALS['strSubmit']
 406  * @uses    $GLOBALS['strVar']
 407  * @uses    count()
 408  * @uses    htmlspecialchars()
 409  */
 410 function PMA_sqlQueryFormBookmark()
 411 {
 412     $bookmark_list = PMA_Bookmark_getList($GLOBALS['db']);
 413     if (! $bookmark_list || count($bookmark_list) < 1) {
 414         return;
 415     }
 416
 417     echo '<fieldset id="bookmarkoptions">';
 418     echo '<legend>';
 419     echo $GLOBALS['strBookmarkQuery'] . '</legend>' . "\n";
 420     echo '<div class="formelement">';
 421     echo '<select name="id_bookmark">' . "\n";
 422     echo '<option value="">&nbsp;</option>' . "\n";
 423     foreach ($bookmark_list as $key => $value) {
 424         echo '<option value="' . htmlspecialchars($key) . '">'
 425             .htmlspecialchars($value) . '</option>' . "\n";
 426     }
 427     // &nbsp; is required for correct display with styles/line height
 428     echo '</select>&nbsp;' . "\n";
 429     echo '</div>' . "\n";
 430     echo '<div class="formelement">' . "\n";
 431     echo $GLOBALS['strVar'];
 432     if ($GLOBALS['cfg']['ReplaceHelpImg']) {
 433         echo ' <a href="./Documentation.html#faqbookmark"'
 434             .' target="documentation">'
 435             .'<img class="icon" src="' . $GLOBALS['pmaThemeImage'] . 'b_help.png"'
 436             .' border="0" width="11" height="11" align="middle"'
 437             .' alt="' . $GLOBALS['strDocu'] . '" /></a> ';
 438     } else {
 439         echo ' (<a href="./Documentation.html#faqbookmark"'
 440             .' target="documentation">' . $GLOBALS['strDocu'] . '</a>): ';
 441     }
 442     echo '<input type="text" name="bookmark_variable" class="textfield"'
 443         .' size="10" />' . "\n";
 444     echo '</div>' . "\n";
 445     echo '<div class="formelement">' . "\n";
 446     echo '<input type="radio" name="action_bookmark" value="0"'
 447         .' id="radio_bookmark_exe" checked="checked" />'
 448         .'<label for="radio_bookmark_exe">' . $GLOBALS['strSubmit']
 449         .'</label>' . "\n";
 450     echo '<input type="radio" name="action_bookmark" value="1"'
 451         .' id="radio_bookmark_view" />'
 452         .'<label for="radio_bookmark_view">' . $GLOBALS['strBookmarkView']
 453         .'</label>' . "\n";
 454     echo '<input type="radio" name="action_bookmark" value="2"'
 455         .' id="radio_bookmark_del" />'
 456         .'<label for="radio_bookmark_del">' . $GLOBALS['strDelete']
 457         .'</label>' . "\n";
 458     echo '</div>' . "\n";
 459     echo '<div class="clearfloat"></div>' . "\n";
 460     echo '</fieldset>' . "\n";
 461
 462     echo '<fieldset id="bookmarkoptionsfooter" class="tblFooters">' . "\n";
 463     echo '<input type="submit" name="SQL" value="' . $GLOBALS['strGo'] . '" />';
 464     echo '<div class="clearfloat"></div>' . "\n";
 465     echo '</fieldset>' . "\n";
 466 }
 467
 468 /**
 469  * prints bookmark fieldset
 470  *
 471  * @usedby  PMA_sqlQueryForm()
 472  * @uses    $GLOBALS['cfg']['GZipDump']
 473  * @uses    $GLOBALS['cfg']['BZipDump']
 474  * @uses    $GLOBALS['cfg']['UploadDir']
 475  * @uses    $GLOBALS['cfg']['AvailableCharsets']
 476  * @uses    $GLOBALS['cfg']['AllowAnywhereRecoding']
 477  * @uses    $GLOBALS['strBzip']
 478  * @uses    $GLOBALS['strCharsetOfFile']
 479  * @uses    $GLOBALS['strCompression']
 480  * @uses    $GLOBALS['strError']
 481  * @uses    $GLOBALS['strGo']
 482  * @uses    $GLOBALS['strGzip']
 483  * @uses    $GLOBALS['strLocationTextfile']
 484  * @uses    $GLOBALS['strWebServerUploadDirectory']
 485  * @uses    $GLOBALS['strWebServerUploadDirectoryError']
 486  * @uses    $GLOBALS['charset']
 487  * @uses    $GLOBALS['max_upload_size']
 488  * @uses    PMA_supportedDecompressions()
 489  * @uses    PMA_getFileSelectOptions()
 490  * @uses    PMA_displayMaximumUploadSize()
 491  * @uses    PMA_generateCharsetDropdownBox()
 492  * @uses    PMA_generateHiddenMaxFileSize()
 493  * @uses    PMA_CSDROPDOWN_CHARSET
 494  * @uses    empty()
 495  */
 496 function PMA_sqlQueryFormUpload(){
 497     $errors = array ();
 498
 499     $matcher = '@\.sql(\.(' . PMA_supportedDecompressions() . '))?$@'; // we allow only SQL here
 500
 501     if (!empty($GLOBALS['cfg']['UploadDir'])) {
 502         $files = PMA_getFileSelectOptions(PMA_userDir($GLOBALS['cfg']['UploadDir']), $matcher, (isset($timeout_passed) && $timeout_passed && isset($local_import_file)) ? $local_import_file : '');
 503     } else {
 504         $files = '';
 505     }
 506
 507     // start output
 508     echo '<fieldset id="">';
 509     echo '<legend>';
 510     echo $GLOBALS['strLocationTextfile'] . '</legend>';
 511     echo '<div class="formelement">';
 512     echo '<input type="file" name="sql_file" class="textfield" /> ';
 513     echo PMA_displayMaximumUploadSize($GLOBALS['max_upload_size']);
 514     // some browsers should respect this :)
 515     echo PMA_generateHiddenMaxFileSize($GLOBALS['max_upload_size']) . "\n";
 516     echo '</div>';
 517
 518     if ($files === FALSE) {
 519         $errors[] = PMA_Message::error('strWebServerUploadDirectoryError');
 520     } elseif (!empty($files)) {
 521         echo '<div class="formelement">';
 522         echo '<strong>' . $GLOBALS['strWebServerUploadDirectory'] .':</strong>' . "\n";
 523         echo '<select size="1" name="sql_localfile">' . "\n";
 524         echo '<option value="" selected="selected"></option>' . "\n";
 525         echo $files;
 526         echo '</select>' . "\n";
 527         echo '</div>';
 528     }
 529
 530     echo '<div class="clearfloat"></div>' . "\n";
 531     echo '</fieldset>';
 532
 533
 534     echo '<fieldset id="" class="tblFooters">';
 535     echo $GLOBALS['strCharsetOfFile'] . "\n";
 536     echo PMA_generateCharsetDropdownBox(PMA_CSDROPDOWN_CHARSET,
 537             'charset_of_file', null, 'utf8', FALSE);
 538     echo '<input type="submit" name="SQL" value="' . $GLOBALS['strGo']
 539         .'" />' . "\n";
 540     echo '<div class="clearfloat"></div>' . "\n";
 541     echo '</fieldset>';
 542
 543     foreach ($errors as $error) {
 544         $error->display();
 545     }
 546 }
 547 ?>