db_create.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7
   8 /**
   9  * Gets some core libraries
  10  */
  11 require_once 'libraries/common.inc.php';
  12 $GLOBALS['js_include'][] = 'functions.js';
  13
  14 require_once 'libraries/mysql_charsets.lib.php';
  15 if (! PMA_DRIZZLE) {
  16     include_once 'libraries/replication.inc.php';
  17 }
  18 require 'libraries/build_html_for_db.lib.php';
  19
  20 /**
  21  * Sets globals from $_POST
  22  */
  23 $post_params = array(
  24     'db_collation',
  25     'new_db'
  26 );
  27 foreach ($post_params as $one_post_param) {
  28     if (isset($_POST[$one_post_param])) {
  29         $GLOBALS[$one_post_param] = $_POST[$one_post_param];
  30     }
  31 }
  32
  33 PMA_checkParameters(array('new_db'));
  34
  35 /**
  36  * Defines the url to return to in case of error in a sql statement
  37  */
  38 $err_url = 'main.php?' . PMA_generate_common_url();
  39
  40 /**
  41  * Builds and executes the db creation sql query
  42  */
  43 $sql_query = 'CREATE DATABASE ' . PMA_backquote($new_db);
  44 if (! empty($db_collation)) {
  45     list($db_charset) = explode('_', $db_collation);
  46     if (in_array($db_charset, $mysql_charsets)
  47         && in_array($db_collation, $mysql_collations[$db_charset])
  48     ) {
  49         $sql_query .= ' DEFAULT' . PMA_generateCharsetQueryPart($db_collation);
  50     }
  51     $db_collation_for_ajax = $db_collation;
  52     unset($db_charset, $db_collation);
  53 }
  54 $sql_query .= ';';
  55
  56 $result = PMA_DBI_try_query($sql_query);
  57
  58 if (! $result) {
  59     $message = PMA_Message::rawError(PMA_DBI_getError());
  60     // avoid displaying the not-created db name in header or navi panel
  61     $GLOBALS['db'] = '';
  62     $GLOBALS['table'] = '';
  63
  64     /**
  65      * If in an Ajax request, just display the message with {@link PMA_ajaxResponse}
  66      */
  67     if ($GLOBALS['is_ajax_request'] == true) {
  68         PMA_ajaxResponse($message, false);
  69     }
  70
  71     include_once 'libraries/header.inc.php';
  72     include_once 'main.php';
  73 } else {
  74     $message = PMA_Message::success(__('Database %1$s has been created.'));
  75     $message->addParam($new_db);
  76     $GLOBALS['db'] = $new_db;
  77
  78     /**
  79      * If in an Ajax request, build the output and send it
  80      */
  81     if ($GLOBALS['is_ajax_request'] == true) {
  82
  83         /**
  84          * String containing the SQL Query formatted in pretty HTML
  85          * @global array $GLOBALS['extra_data']
  86          * @name $extra_data
  87          */
  88         $extra_data['sql_query'] = PMA_showMessage(null, $sql_query, 'success');
  89
  90         //Construct the html for the new database, so that it can be appended to
  91         // the list of databases on server_databases.php
  92
  93         /**
  94          * Build the array to be passed to {@link PMA_generate_common_url}
  95          * to generate the links
  96          *
  97          * @global array $GLOBALS['db_url_params']
  98          * @name $db_url_params
  99          */
 100         $db_url_params['db'] = $new_db;
 101
 102         $is_superuser = PMA_isSuperuser();
 103         $column_order = PMA_getColumnOrder();
 104         $url_query = PMA_generate_common_url($new_db);
 105
 106         /**
 107          * String that will contain the output HTML
 108          * @name    $new_db_string
 109          */
 110         $new_db_string = '<tr>';
 111
 112         if (empty($db_collation_for_ajax)) {
 113             $db_collation_for_ajax = PMA_getServerCollation();
 114         }
 115
 116         // $dbstats comes from the create table dialog
 117         if (! empty($dbstats)) {
 118             $current = array(
 119                 'SCHEMA_NAME' => $new_db,
 120                 'DEFAULT_COLLATION_NAME' => $db_collation_for_ajax,
 121                 'SCHEMA_TABLES' => '0',
 122                 'SCHEMA_TABLE_ROWS' => '0',
 123                 'SCHEMA_DATA_LENGTH' => '0',
 124                 'SCHEMA_MAX_DATA_LENGTH' => '0',
 125                 'SCHEMA_INDEX_LENGTH' => '0',
 126                 'SCHEMA_LENGTH' => '0',
 127                 'SCHEMA_DATA_FREE' => '0'
 128             );
 129         } else {
 130             $current = array(
 131                 'SCHEMA_NAME' => $new_db
 132             );
 133         }
 134
 135         list($column_order, $generated_html) = PMA_buildHtmlForDb(
 136             $current, $is_superuser, (isset($checkall) ? $checkall : ''),
 137             $url_query, $column_order, $replication_types, $replication_info
 138         );
 139         $new_db_string .= $generated_html;
 140
 141         $new_db_string .= '</tr>';
 142
 143         $extra_data['new_db_string'] = $new_db_string;
 144
 145         PMA_ajaxResponse($message, true, $extra_data);
 146     }
 147
 148     include_once 'libraries/header.inc.php';
 149     include_once '' . $cfg['DefaultTabDatabase'];
 150 }
 151 ?>