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 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Gets some core libraries
  14  */
  15 require_once './libraries/bookmark.lib.php';
  16
  17 PMA_Util::checkParameters(array('db'));
  18
  19 $is_show_stats = $cfg['ShowStats'];
  20
  21 $db_is_information_schema = $GLOBALS['dbi']->isSystemSchema($db);
  22 if ($db_is_information_schema) {
  23     $is_show_stats = false;
  24 }
  25
  26 /**
  27  * Defines the urls to return to in case of error in a sql statement
  28  */
  29 $err_url_0 = 'index.php?' . PMA_generate_common_url();
  30 $err_url   = $cfg['DefaultTabDatabase'] . '?' . PMA_generate_common_url($db);
  31
  32
  33 /**
  34  * Ensures the database exists (else move to the "parent" script) and displays
  35  * headers
  36  */
  37 if (! isset($is_db) || ! $is_db) {
  38     if (strlen($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) {
  44             $is_db = true;
  45             unset($GLOBALS['errno']);
  46         }
  47     }
  48     // Not a valid db name -> back to the welcome page
  49     $uri = $cfg['PmaAbsoluteUri'] . 'index.php?'
  50         . PMA_generate_common_url('', '', '&')
  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);
  56             $response->addJSON(
  57                 'message',
  58                 PMA_Message::error(__('No databases selected.'))
  59             );
  60         } else {
  61             PMA_sendHeaderLocation($uri);
  62         }
  63         exit;
  64     }
  65 } // end if (ensures db exists)
  66
  67 /**
  68  * Changes database charset if requested by the user
  69  */
  70 if (isset($_REQUEST['submitcollation'])
  71     && isset($_REQUEST['db_collation'])
  72     && ! empty($_REQUEST['db_collation'])
  73 ) {
  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();
  80     unset($db_charset);
  81
  82     /**
  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.
  86      */
  87     if ( $GLOBALS['is_ajax_request'] == true) {
  88         $response = PMA_Response::getInstance();
  89         $response->isSuccess($message->isSuccess());
  90         $response->addJSON('message', $message);
  91         exit;
  92     }
  93 }
  94
  95 /**
  96  * Set parameters for links
  97  */
  98 $url_query = PMA_generate_common_url($db);
  99
 100 ?>