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

資料庫連接檔案

代碼如下	複製代碼
<?php $conn=mysql_connect("localhost","phpdb","phpdb")         or die("不能串連資料庫伺服器： ".mysql_error()); mysql_select_db("vote",$conn) or die ("不能選擇資料庫: ".mysql_error()); ?>

 

首頁 1 2 3 4 末頁