libraries/db_common.inc.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package phpMyAdmin
   6  */
   7 if (! defined('PHPMYADMIN')) {
   8     exit;
   9 }
  10
  11 /**
  12  * Gets some core libraries
  13  */
  14 require_once './libraries/common.inc.php';
  15 require_once './libraries/bookmark.lib.php';
  16
  17 PMA_checkParameters(array('db'));
  18
  19 $is_show_stats = $cfg['ShowStats'];
  20
  21 if ($db == 'information_schema') {
  22     $is_show_stats = false;
  23     $db_is_information_schema = true;
  24 } else {
  25     $db_is_information_schema = false;
  26 }
  27
  28 /**
  29  * Defines the urls to return to in case of error in a sql statement
  30  */
  31 $err_url_0 = 'main.php?' . PMA_generate_common_url();
  32 $err_url   = $cfg['DefaultTabDatabase'] . '?' . PMA_generate_common_url($db);
  33
  34
  35 /**
  36  * Ensures the database exists (else move to the "parent" script) and displays
  37  * headers
  38  */
  39 if (! isset($is_db) || ! $is_db) {
  40     if (strlen($db)) {
  41         $is_db = PMA_DBI_select_db($db);
  42         // This "Command out of sync" 2014 error may happen, for example
  43         // after calling a MySQL procedure; at this point we can't select
  44         // the db but it's not necessarily wrong
  45         if (PMA_DBI_getError() && $GLOBALS['errno'] == 2014) {
  46             $is_db = true;
  47             unset($GLOBALS['errno']);
  48         }
  49     }
  50     // Not a valid db name -> back to the welcome page
  51     if (! strlen($db) || ! $is_db) {
  52         PMA_sendHeaderLocation($cfg['PmaAbsoluteUri'] . 'main.php?' . PMA_generate_common_url('', '', '&') . (isset($message) ? '&message=' . urlencode($message) : '') . '&reload=1');
  53         exit;
  54     }
  55 } // end if (ensures db exists)
  56
  57 /**
  58  * Changes database charset if requested by the user
  59  */
  60 if (isset($submitcollation) && !empty($db_collation)) {
  61     list($db_charset) = explode('_', $db_collation);
  62     $sql_query        = 'ALTER DATABASE ' . PMA_backquote($db) . ' DEFAULT' . PMA_generateCharsetQueryPart($db_collation);
  63     $result           = PMA_DBI_query($sql_query);
  64     $message          = PMA_Message::success();
  65     unset($db_charset, $db_collation);
  66
  67     /**
  68      * If we are in an Ajax request, let us stop the execution here. Necessary for
  69      * db charset change action on db_operations.php.  If this causes a bug on
  70      * other pages, we might have to move this to a different location.
  71      */
  72     if( $GLOBALS['is_ajax_request'] == true) {
  73         PMA_ajaxResponse($message, $message->isSuccess());
  74     };
  75 }
  76
  77 require_once './libraries/header.inc.php';
  78
  79 /**
  80  * Set parameters for links
  81  */
  82 $url_query = PMA_generate_common_url($db);
  83
  84 ?>