libraries/db_common.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Common includes for the database level views
   5  *
   6  * @package PhpMyAdmin
   7  */
   8
   9 use PhpMyAdmin\Core;
  10 use PhpMyAdmin\Message;
  11 use PhpMyAdmin\Response;
  12 use PhpMyAdmin\Url;
  13 use PhpMyAdmin\Util;
  14 use PhpMyAdmin\Operations;
  15
  16 if (! defined('PHPMYADMIN')) {
  17     exit;
  18 }
  19
  20 PhpMyAdmin\Util::checkParameters(array('db'));
  21
  22 global $cfg;
  23 global $db;
  24
  25 $response = Response::getInstance();
  26 $is_show_stats = $cfg['ShowStats'];
  27
  28 $db_is_system_schema = $GLOBALS['dbi']->isSystemSchema($db);
  29 if ($db_is_system_schema) {
  30     $is_show_stats = false;
  31 }
  32
  33 /**
  34  * Defines the urls to return to in case of error in a sql statement
  35  */
  36 $err_url_0 = 'index.php' . Url::getCommon();
  37
  38 $err_url = PhpMyAdmin\Util::getScriptNameForOption(
  39     $GLOBALS['cfg']['DefaultTabDatabase'], 'database'
  40 )
  41     . Url::getCommon(array('db' => $db));
  42
  43 /**
  44  * Ensures the database exists (else move to the "parent" script) and displays
  45  * headers
  46  */
  47 if (! isset($is_db) || ! $is_db) {
  48     if (strlen($db) > 0) {
  49         $is_db = $GLOBALS['dbi']->selectDb($db);
  50         // This "Command out of sync" 2014 error may happen, for example
  51         // after calling a MySQL procedure; at this point we can't select
  52         // the db but it's not necessarily wrong
  53         if ($GLOBALS['dbi']->getError() && $GLOBALS['errno'] == 2014) {
  54             $is_db = true;
  55             unset($GLOBALS['errno']);
  56         }
  57     } else {
  58         $is_db = false;
  59     }
  60     // Not a valid db name -> back to the welcome page
  61     $params = array('reload' => '1');
  62     if (isset($message)) {
  63         $params['message'] = $message;
  64     }
  65     $uri = './index.php' . Url::getCommonRaw($params);
  66     if (strlen($db) === 0 || ! $is_db) {
  67         $response = Response::getInstance();
  68         if ($response->isAjax()) {
  69             $response->setRequestStatus(false);
  70             $response->addJSON(
  71                 'message',
  72                 Message::error(__('No databases selected.'))
  73             );
  74         } else {
  75             Core::sendHeaderLocation($uri);
  76         }
  77         exit;
  78     }
  79 } // end if (ensures db exists)
  80
  81 /**
  82  * Changes database charset if requested by the user
  83  */
  84 if (isset($_REQUEST['submitcollation'])
  85     && isset($_REQUEST['db_collation'])
  86     && ! empty($_REQUEST['db_collation'])
  87 ) {
  88     list($db_charset) = explode('_', $_REQUEST['db_collation']);
  89     $sql_query        = 'ALTER DATABASE '
  90         . PhpMyAdmin\Util::backquote($db)
  91         . ' DEFAULT' . Util::getCharsetQueryPart($_REQUEST['db_collation']);
  92     $result           = $GLOBALS['dbi']->query($sql_query);
  93     $message          = Message::success();
  94
  95     /**
  96     * Changes tables charset if requested by the user
  97     */
  98     if (
  99         isset($_REQUEST['change_all_tables_collations']) &&
 100         $_REQUEST['change_all_tables_collations'] == 'on'
 101     ) {
 102         list($tables, , , , , , , ,) = PhpMyAdmin\Util::getDbInfo($db, null);
 103         foreach($tables as $tableName => $data) {
 104             $sql_query      = 'ALTER TABLE '
 105             . PhpMyAdmin\Util::backquote($db)
 106             . '.'
 107             . PhpMyAdmin\Util::backquote($tableName)
 108             . 'DEFAULT '
 109             . Util::getCharsetQueryPart($_REQUEST['db_collation']);
 110             $GLOBALS['dbi']->query($sql_query);
 111
 112             /**
 113             * Changes columns charset if requested by the user
 114             */
 115             if (
 116                 isset($_REQUEST['change_all_tables_columns_collations']) &&
 117                 $_REQUEST['change_all_tables_columns_collations'] == 'on'
 118             ) {
 119                 $operations = new Operations();
 120                 $operations->changeAllColumnsCollation($db, $tableName, $_REQUEST['db_collation']);
 121             }
 122
 123         }
 124     }
 125     unset($db_charset);
 126
 127     /**
 128      * If we are in an Ajax request, let us stop the execution here. Necessary for
 129      * db charset change action on db_operations.php.  If this causes a bug on
 130      * other pages, we might have to move this to a different location.
 131      */
 132     if ($response->isAjax()) {
 133         $response->setRequestStatus($message->isSuccess());
 134         $response->addJSON('message', $message);
 135         exit;
 136     }
 137 }
 138
 139 /**
 140  * Set parameters for links
 141  */
 142 $url_query = Url::getCommon(array('db' => $db));