当前位置: 首页>>代码示例>>PHP>>正文

PHP mysql_create_db函数代码示例

本文整理汇总了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;
}
开发者ID:riansopian，项目名称:hesk，代码行数:48，代码来源:install_functions.inc.php

示例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);
         }
     }
 }
开发者ID:rezarahimi4861，项目名称:icmf，代码行数:16，代码来源:mysql.php

示例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;
 }
开发者ID:BackupTheBerlios，项目名称:zvs，代码行数:16，代码来源:manager_mysql.php

示例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);
             }
开发者ID:uncia，项目名称:webshell，代码行数:31，代码来源:c99shell.php

示例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;
 }
开发者ID:ReKungPaw，项目名称:mysql，代码行数:10，代码来源:MySQL_Test_After.php

示例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;
 }
开发者ID:ateliee，项目名称:php_lib，代码行数:36，代码来源:class_mysql.php

示例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 = "";
开发者ID:retanoj，项目名称:webshellSample，代码行数:31，代码来源:3eb96d2bd532ff487617dd91948f8943.php

示例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());
}
开发者ID:Gerst20051，项目名称:Social-HnS，代码行数:31，代码来源:SQL.php

示例9: createDB

 function createDB($DBName)
 {
     /* 新建一个 MySQL 数据库 */
     return @mysql_create_db($DBName, $this->LinkId) or die($this->halt("创建数据库 " . $DBName . " 失败！"));
 }
开发者ID:BGCX067，项目名称:f2cont-svn-to-git，代码行数:5，代码来源:db.php

示例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']}'\">&nbsp;<input type=\"submit\" value=\"ADMIN\" onclick=\"javascript:window.location.href='admin.php'\">&nbsp;<input type=\"submit\" value=\"MEMBERAREA\" onclick=\"javascript:window.location.href='http://www.smartisoft.com/?member'\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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";
开发者ID:BackupTheBerlios，项目名称:logixclassified-svn，代码行数:31，代码来源:setup.php

示例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;
 }
开发者ID:ateliee，项目名称:pmp，代码行数:18，代码来源:database.php

示例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;
		}
	}
开发者ID:naffis，项目名称:rejectmail-php，代码行数:11，代码来源:db.inc.php

示例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-->
开发者ID:CMMCO，项目名称:Intranet，代码行数:31，代码来源:admin_dbedit_top.php

示例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);
开发者ID:antiwise，项目名称:collect，代码行数:31，代码来源:index.php

示例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);
 }
开发者ID:laiello，项目名称:yt-cache，代码行数:11，代码来源:sql.php


注：本文中的mysql_create_db函数示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。