Question

php 导入数据库

DROP TABLE IF EXISTS config;
CREATE TABLE config (
db_name varchar(30) character set utf8 NOT NULL default '',
db_value text character set utf8 NOT NULL ,
PRIMARY KEY (db_name)
) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci;

这类的语句如何导入,不用phpmyadmin的,用php函数.
有点懂了,是不是每个语句单独query就可以?

Answer 1

<?
/*省略连接数据库部分，请自行添加*/
$sql = "DROP TABLE IF EXISTS config";
mysql_query($sql) ;//执行命令
$sql = "CREATE TABLE config (
db_name varchar(30) character set utf8 NOT NULL default '',
db_value text character set utf8 NOT NULL ,
PRIMARY KEY (db_name)
) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
if (mysql_query($sql))
echo '创建表config成功';
else
echo '创建表config失败';

?>

Answer 2

用Php的引擎中相应的数据库函数，比如是mysql的话，把上面的sql语句放到变量中，$sql = "drop table if ...."; mysql_query($sql);

Answer 3

如果启用了mysqli模块,使用 mysqli 对象的 query()方法
如果是使用mysql模块,用mysql_query()

Answer 4

$sql="DROP TABLE IF EXISTS config";
mysql_query($sql);

$sql="CREATE TABLE config (
db_name varchar(30) character set utf8 NOT NULL default '',
db_value text character set utf8 NOT NULL ,
PRIMARY KEY (db_name)
) TYPE=MyISAM CHARACTER SET utf8 COLLATE utf8_general_ci";
mysql_query($sql);