您好,欢迎来到三六零分类信息网!老站,搜索引擎当天收录,欢迎发信息

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

2024/6/20 15:08:48发布27次查看
我们先来分析流程
一,数据库教程,
二,数据库文件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 末页
该用户其它信息

VIP推荐

免费发布信息,免费发布B2B信息网站平台 - 三六零分类信息网 沪ICP备09012988号-2
企业名录 Product