db_create.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @version $Id$
   6  */
   7
   8 /**
   9  * Gets some core libraries
  10  */
  11 require_once './libraries/common.inc.php';
  12 $GLOBALS['js_include'][] = 'functions.js';
  13 require_once './libraries/mysql_charsets.lib.php';
  14
  15 PMA_checkParameters(array('new_db'));
  16
  17 /**
  18  * Defines the url to return to in case of error in a sql statement
  19  */
  20 $err_url = 'main.php?' . PMA_generate_common_url();
  21
  22 /**
  23  * Builds and executes the db creation sql query
  24  */
  25 $sql_query = 'CREATE DATABASE ' . PMA_backquote($new_db);
  26 if (!empty($db_collation)) {
  27     list($db_charset) = explode('_', $db_collation);
  28     if (in_array($db_charset, $mysql_charsets) && in_array($db_collation, $mysql_collations[$db_charset])) {
  29         $sql_query .= ' DEFAULT' . PMA_generateCharsetQueryPart($db_collation);
  30     }
  31     unset($db_charset, $db_collation);
  32 }
  33 $sql_query .= ';';
  34
  35 $result = PMA_DBI_try_query($sql_query);
  36
  37 if (! $result) {
  38     $message = PMA_Message::rawError(PMA_DBI_getError());
  39     // avoid displaying the not-created db name in header or navi panel
  40     $GLOBALS['db'] = '';
  41     $GLOBALS['table'] = '';
  42     require_once './libraries/header.inc.php';
  43     require_once './main.php';
  44 } else {
  45     $message = PMA_Message::success('strDatabaseHasBeenCreated');
  46     $message->addParam($new_db);
  47     $GLOBALS['db'] = $new_db;
  48
  49     require_once './libraries/header.inc.php';
  50     require_once './' . $cfg['DefaultTabDatabase'];
  51 }
  52 ?>