name="sqlform" onsubmit="var save_name = window.opener.parent.frame_content.name; window.opener.parent.frame_content.name = save_name + ''; this.target = window.opener.parent.frame_content.name; return checkSqlQuery(this)"> ' . "\n"; } if ($is_querywindow) { echo '' ."\n"; if ($display_tab != 'sql' && $display_tab != 'full') { echo '' . "\n"; echo '' . "\n"; } } echo '' . "\n" .PMA_generate_common_hidden_inputs($db, $table) . "\n" .'' . "\n" .'' . "\n" .'' . "\n" .'' . "\n"; // display querybox if ($display_tab === 'full' || $display_tab === 'sql') { PMA_sqlQueryFormInsert($query, $is_querywindow, $delimiter); } // display uploads if ($display_tab === 'files' && $GLOBALS['is_upload']) { PMA_sqlQueryFormUpload(); } // Bookmark Support if ($display_tab === 'full' || $display_tab === 'history') { if (! empty($GLOBALS['cfg']['Bookmark'])) { PMA_sqlQueryFormBookmark(); } } // Encoding setting form appended by Y.Kawada if (function_exists('PMA_set_enc_form')) { echo PMA_set_enc_form(' '); } echo '
' . "\n"; // print an empty div, which will be later filled with // the sql query results by ajax echo '
'; } /** * Prints querybox fieldset * * @param string $query query to display in the textarea * @param boolean $is_querywindow if inside querywindow or not * @param string $delimiter default delimiter to use * * @return void * * @usedby PMA_sqlQueryForm() */ function PMA_sqlQueryFormInsert( $query = '', $is_querywindow = false, $delimiter = ';' ) { // enable auto select text in textarea if ($GLOBALS['cfg']['TextareaAutoSelect']) { $auto_sel = ' onclick="selectContent(this, sql_box_locked, true)"'; } else { $auto_sel = ''; } // enable locking if inside query window if ($is_querywindow) { $locking = ' onkeypress="document.sqlform.elements[\'LockFromUpdate\'].' .'checked = true;"'; $height = $GLOBALS['cfg']['TextareaRows'] * 1.25; } else { $locking = ''; $height = $GLOBALS['cfg']['TextareaRows'] * 2; } $table = ''; $db = ''; $fields_list = array(); if (! strlen($GLOBALS['db'])) { // prepare for server related $legend = sprintf( __('Run SQL query/queries on server %s'), '"' . htmlspecialchars( ! empty($GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose']) ? $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['verbose'] : $GLOBALS['cfg']['Servers'][$GLOBALS['server']]['host'] ) . '"' ); } elseif (! strlen($GLOBALS['table'])) { // prepare for db related $db = $GLOBALS['db']; // if you want navigation: $tmp_db_link = ''; // else use // $tmp_db_link = htmlspecialchars($db); $legend = sprintf(__('Run SQL query/queries on database %s'), $tmp_db_link); if (empty($query)) { $query = PMA_Util::expandUserString( $GLOBALS['cfg']['DefaultQueryDatabase'], 'backquote' ); } } else { $table = $GLOBALS['table']; $db = $GLOBALS['db']; // Get the list and number of fields // we do a try_query here, because we could be in the query window, // trying to synchonize and the table has not yet been created $fields_list = PMA_DBI_get_columns($db, $GLOBALS['table'], null, true); $tmp_db_link = ''; // else use // $tmp_db_link = htmlspecialchars($db); $legend = sprintf(__('Run SQL query/queries on database %s'), $tmp_db_link); if (empty($query)) { $query = PMA_Util::expandUserString( $GLOBALS['cfg']['DefaultQueryTable'], 'backquote' ); } } $legend .= ': ' . PMA_Util::showMySQLDocu('SQL-Syntax', 'SELECT'); if (count($fields_list)) { $sqlquerycontainer_id = 'sqlquerycontainer'; } else { $sqlquerycontainer_id = 'sqlquerycontainerfull'; } echo '' . "\n" .'
' . "\n" .'
' . "\n"; echo '' . $legend . '' . "\n"; echo '
' . "\n"; echo '
' . "\n" .'' . "\n"; // Add buttons to generate query easily for // select all, single select, insert, update and delete if (count($fields_list)) { echo ''; echo ''; echo ''; echo ''; echo ''; } echo ''; echo '
' . "\n"; if (count($fields_list)) { echo '
' . "\n" .'' . "\n" .'' . "\n" .'
' . "\n"; if (in_array( $GLOBALS['cfg']['ActionLinksMode'], array('icons', 'both') ) ) { echo '' . "\n"; } else { echo '' . "\n"; } echo '
' . "\n" .'
' . "\n"; } echo '
' . "\n"; echo '
' . "\n"; if (! empty($GLOBALS['cfg']['Bookmark'])) { ?>
' . "\n"; echo '' . "\n" .'' . "\n"; echo '
' . "\n"; echo '
' . "\n"; if ($is_querywindow) { ?> ' . "\n"; echo '
' . "\n"; echo '' . "\n"; echo ' ]' . "\n"; echo '' . "\n" .'' . "\n"; if (! $is_querywindow) { echo '' . ''; } echo '
' . "\n"; echo '' ."\n"; echo '
' . "\n"; echo '
' . "\n"; } /** * Prints bookmark fieldset * * @return void * * @usedby PMA_sqlQueryForm() */ function PMA_sqlQueryFormBookmark() { $bookmark_list = PMA_Bookmark_getList($GLOBALS['db']); if (! $bookmark_list || count($bookmark_list) < 1) { return; } echo '
'; echo ''; echo __('Bookmarked SQL query') . '' . "\n"; echo '
'; echo ' ' . "\n"; echo '
' . "\n"; echo '
' . "\n"; echo __('Variable'); echo PMA_Util::showDocu('faq', 'faqbookmark'); echo '' . "\n"; echo '
' . "\n"; echo '
' . "\n"; echo '' .'' . "\n"; echo '' .'' . "\n"; echo '' .'' . "\n"; echo '
' . "\n"; echo '
' . "\n"; echo '
' . "\n"; echo '
' . "\n"; echo ''; echo '
' . "\n"; echo '
' . "\n"; } /** * Prints bookmark fieldset * * @return void * * @usedby PMA_sqlQueryForm() */ function PMA_sqlQueryFormUpload() { global $timeout_passed, $local_import_file; $errors = array(); // we allow only SQL here $matcher = '@\.sql(\.(' . PMA_supportedDecompressions() . '))?$@'; if (!empty($GLOBALS['cfg']['UploadDir'])) { $files = PMA_getFileSelectOptions( PMA_Util::userDir($GLOBALS['cfg']['UploadDir']), $matcher, (isset($timeout_passed) && $timeout_passed && isset($local_import_file)) ? $local_import_file : '' ); } else { $files = ''; } // start output echo '
'; echo ''; echo __('Browse your computer:') . ''; echo '
'; echo ' '; echo PMA_Util::getFormattedMaximumUploadSize($GLOBALS['max_upload_size']); // some browsers should respect this :) echo PMA_Util::generateHiddenMaxFileSize($GLOBALS['max_upload_size']) . "\n"; echo '
'; if ($files === false) { $errors[] = PMA_Message::error(__('The directory you set for upload work cannot be reached')); } elseif (!empty($files)) { echo '
'; echo '' . __('web server upload directory') .':' . "\n"; echo '' . "\n"; echo '
'; } echo '
' . "\n"; echo '
'; echo '
'; echo __('Character set of the file:') . "\n"; echo PMA_generateCharsetDropdownBox( PMA_CSDROPDOWN_CHARSET, 'charset_of_file', null, 'utf8', false ); echo '' . "\n"; echo '
' . "\n"; echo '
'; foreach ($errors as $error) { $error->display(); } } ?>