1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
<?php
require('configuration.php');
mysql_connect("localhost", "root", "pass");
//Tu te connecte à ton serveur
mysql_select_db("table");
$sondage="CREATE TABLE `sondage` (
`id` SMALLINT NOT NULL AUTO_INCREMENT,
`question` TEXT NOT NULL ,
`proposition1` VARCHAR( 100 ) NOT NULL ,
`proposition2` VARCHAR( 100 ) NOT NULL ,
`proposition3` VARCHAR( 100 ) NOT NULL ,
`proposition4` VARCHAR( 100 ) NOT NULL ,
`proposition5` VARCHAR( 100 ) NOT NULL ,
`resultats1` SMALLINT NOT NULL ,
`resultats2` SMALLINT NOT NULL ,
`resultats3` SMALLINT NOT NULL ,
`resultats4` SMALLINT NOT NULL ,
`resultats5` SMALLINT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB ;";
$vote="CREATE TABLE `t_vote` (
vote_id int(16) unsigned NOT NULL auto_increment,
sondage_id int(16) unsigned NOT NULL,
vote_ip varchar(15) NOT NULL,
PRIMARY KEY(vote_id)
)";
mysql_query("$sondage","$vote");
mysql_close();
?> |
Partager