mysql_create

说明

bool mysql_create_db ( string database name [, resource link_identifier] )

mysql_create_db() 尝试在指定的连接标识所关联的服务器上建立一个新数据库。

如果成功则返回 TRUE，失败则返回 FALSE。

例子 1. MySQL 新建数据库例子
<?php $link = mysql_pconnect("localhost", "mysql_user", "mysql_password") or die("Could not connect: " . mysql_error()); if (mysql_create_db("my_db")) { print ("Database created successfully\n"); } else { printf ("Error creating database: %s\n", mysql_error()); } ?>

为向下兼容也可以用 mysql_createdb()，但并不提倡。

注: 不提倡使用函数 mysql_create_db()。最好用 mysql_query() 来提交一条 SQL CREATE DATABASE 语句来替代。

警告

如果 MySQL 扩展库是基于 MySQL 4.x 客户端库建立的，则本函数不可用。

参见 mysql_drop_db() 和 mysql_query()。

add a note User Contributed Notes

zubrag
29-Aug-2006 06:03


mysql_create_db function will not work on cPanel hosting. If you need to create database from your PHP script on cPanel hosted server then you'll need to use cPanel interface. Database creation code would look like (calling cPanel's adddb function): http://USER:PASS@HOST:2082/frontend/SKIN/sql/adddb.html?db=DB



You can download ready-made sample php script from http://www.zubrag.com/scripts/cpanel-database-creator.php

omer
21-Jun-2005 08:42


for MySQL4.1 lib users;



as noted the function is a no-go for MySQL4.1 libs.  While i do not know the logic behind this i was relieved to see that



mysql_connect ("localhost","$user","$password")

$soru = 'CREATE DATABASE '.$dbname;

mysql_query($soru);



worked just fine...

add a note