drop database if exists vote;
create database vote;
use vote;
CREATE TABLE title (
id int(6) NOT NULL auto_increment,
username varchar(20) NOT NULL,
email varchar(50) NOT NULL,
title varchar(250) NOT NULL default '',
types tinyint(2) NOT NULL default '1',
choice text,
times datetime NOT NULL default '0000-00-00 00:00:00',
primary KEY ( id )
);
CREATE TABLE vote (
id int(6) NOT NULL auto_increment,
titleid int(6) NOT NULL default '0',
info text NOT NULL,
vcount int(4) NOT NULL default '0',
primary KEY ( id )
);
create table email (
id int(6) not null,
email varchar(50) not null,
primary key ( id, email)
);
数据库连接文件
代码如下
$cOnn=mysql_connect("localhost","phpdb","phpdb")
or die("不能连接数据库服务器: ".mysql_error());
mysql_select_db("vote",$conn) or die ("不能选择数据库: ".mysql_error());