php mysql 投票系统开发实例教程(1/4)

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());

?>