php mysql 投票系统开发实例教程(1/4)-PHP源码-php.cn

Home

php教程

PHP源码

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 08, 2016 pm 05:26 PM

BSPnbspnullquot

我们先来分析流程

一，数据库教程，

二，数据库文件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 末页

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn