您好,欢迎访问一九零五行业门户网

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

我们先来分析流程
一,数据库教程,
二,数据库文件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)
 );
数据库连接文件
 代码如下 复制代码
首页 1 2 3 4 末页
其它类似信息

推荐信息