【php开源代码栏目提醒】:网学会员,鉴于大家对php开源代码十分关注,论文会员在此为大家搜集整理了“createdb.php”一文,供大家参考学习!
<?php
echo "读取数据库配置信息...<br>";
require("config.php");
echo "准备创建投票数据库...<br>";
mysql_query("drop database if exists $dbname")or die(mysql_error());
mysql_query("create database $dbname")or die(mysql_error());
mysql_select_db($dbname);
echo "创建投票主题信息表addpoll...<br>";
$str = <<<SQL
CREATE TABLE addpoll(
pid tinyint(4) NOT NULL auto_increment,
question varchar(100),
answer1 varchar(40),
answer2 varchar(40),
answer3 varchar(40),
answer4 varchar(40),
answer5 varchar(40),
answer6 varchar(40),
noofanswers tinyint(1),
display tinyint(1) DEFAULT '0',
PRIMARY KEY (pid)
)
SQL;
my
sql_query($str) or die(mysql_error());
echo "创建投票结果表pollresult...<br>";
$str = <<<SQL
CREATE TABLE pollresult(
pid tinyint(4),
answer1 varchar(40),
answer2 varchar(40),
answer3 varchar(40),
answer4 varchar(40),
answer5 varchar(40),
answer6 varchar(40),
noofanswers tinyint(1)
)
SQL;
mysql_query($str) or die(mysql_error());
echo "数据库成功创建完毕!";
?>