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

<script>ec(2);</script>

我们先来分析流程

一，数据库教程，

二，数据库文件dbconn.php

三，vote.php投票页面

四，投票功能页面vote_add.php

五，查看所有投票数据viewpoll.php

现在我们来看看数据库结构

代码如下

复制代码

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

 

首页 1 2 3 4 末页