2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Common includes for the database level views
8 if (! defined('PHPMYADMIN')) {
13 * Gets some core libraries
15 require_once './libraries/bookmark.lib.php';
17 PMA_Util
::checkParameters(array('db'));
19 $is_show_stats = $cfg['ShowStats'];
21 $db_is_system_schema = $GLOBALS['dbi']->isSystemSchema($db);
22 if ($db_is_system_schema) {
23 $is_show_stats = false;
27 * Defines the urls to return to in case of error in a sql statement
29 $err_url_0 = 'index.php?' . PMA_URL_getCommon();
30 $err_url = $cfg['DefaultTabDatabase'] . '?' . PMA_URL_getCommon($db);
34 * Ensures the database exists (else move to the "parent" script) and displays
37 if (! isset($is_db) ||
! $is_db) {
39 $is_db = $GLOBALS['dbi']->selectDb($db);
40 // This "Command out of sync" 2014 error may happen, for example
41 // after calling a MySQL procedure; at this point we can't select
42 // the db but it's not necessarily wrong
43 if ($GLOBALS['dbi']->getError() && $GLOBALS['errno'] == 2014) {
45 unset($GLOBALS['errno']);
48 // Not a valid db name -> back to the welcome page
49 $uri = $cfg['PmaAbsoluteUri'] . 'index.php?'
50 . PMA_URL_getCommon('', '', '&')
51 . (isset($message) ?
'&message=' . urlencode($message) : '') . '&reload=1';
52 if (! strlen($db) ||
! $is_db) {
53 $response = PMA_Response
::getInstance();
54 if ($response->isAjax()) {
55 $response->isSuccess(false);
58 PMA_Message
::error(__('No databases selected.'))
61 PMA_sendHeaderLocation($uri);
65 } // end if (ensures db exists)
68 * Changes database charset if requested by the user
70 if (isset($_REQUEST['submitcollation'])
71 && isset($_REQUEST['db_collation'])
72 && ! empty($_REQUEST['db_collation'])
74 list($db_charset) = explode('_', $_REQUEST['db_collation']);
75 $sql_query = 'ALTER DATABASE '
76 . PMA_Util
::backquote($db)
77 . ' DEFAULT' . PMA_generateCharsetQueryPart($_REQUEST['db_collation']);
78 $result = $GLOBALS['dbi']->query($sql_query);
79 $message = PMA_Message
::success();
83 * If we are in an Ajax request, let us stop the execution here. Necessary for
84 * db charset change action on db_operations.php. If this causes a bug on
85 * other pages, we might have to move this to a different location.
87 if ( $GLOBALS['is_ajax_request'] == true) {
88 $response = PMA_Response
::getInstance();
89 $response->isSuccess($message->isSuccess());
90 $response->addJSON('message', $message);
96 * Set parameters for links
98 $url_query = PMA_URL_getCommon($db);