本文整理汇总了PHP中mysql_create_db函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_create_db函数的具体用法?PHP mysql_create_db怎么用?PHP mysql_create_db使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_create_db函数的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: hesk_iTestDatabaseConnection
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;
}
示例2: mysql
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);
}
}
}
示例3: CreateDatabase
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;
}
示例4: mysql_query
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);
}
示例5: MySQL_Create_Db_Test
/**
* Test mysql_create_db
*
* @return boolean
*/
public function MySQL_Create_Db_Test()
{
// Drop db
return mysql_create_db('unit_sql_v_2') === true;
}
示例6: createDB
/**
* 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;
}
示例7: mysql_query
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 = "";
示例8: array_push
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());
}
示例9: createDB
function createDB($DBName)
{
/* 新建一个 MySQL 数据库 */
return @mysql_create_db($DBName, $this->LinkId) or die($this->halt("创建数据库 " . $DBName . " 失败!"));
}
示例10: mysql_close
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";
示例11: createDB
/**
* @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;
}
示例12: createDB
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;
}
}
示例13: mysql_create_db
<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-->
示例14: getcontent
}
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);
示例15: create_database
/**
* 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);
}