retour à la page du formulaire" ;
$jour = $_POST['jour'];
$mois = $_POST['mois'];
$annee = $_POST['annee'];
$heure = $_POST['heure'];
$minute = $_POST['minute'];
$sec = $_POST['sec'];
$date= array('$jour','$mois','$annee','$heure','$minute','$sec');
$age = $_POST['age'];
$sexe = $_POST['sexe'];
$deja = $_POST['deja'];
$plus = $_POST['plus'];
$couple = $_POST['couple'];
$dehors = $_POST['dehors'];
$avec = $_POST['avec'];
$culpa = $_POST['culpa'];
$pareil = $_POST['pareil'];
$frequence = $_POST['frequence'];
$message = $_POST['message'];
$adehors = $_POST['adehors'];
$amis = $_POST['amis'];
$famille = $_POST['famille'];
$homo = $_POST['homo'];
$tente = $_POST['tente'];
$hfaire = $_POST['hfaire'];
$hrecevoir = $_POST['hrecevoir'];
$voir = $_POST['voir'];
$recevoir = $_POST['recevoir'];
$faire = $_POST['faire'];
$involt = $_POST['involt'];
$volt = $_POST['volt'];
$used = $_POST['used'];
$plusieurs = $_POST['plusieurs'];
$sextoys = $_POST['sextoys'];
$autre = $_POST['autre'];
$aused = $_POST['aused'];
$aplusieurs = $_POST['aplusieurs'];
$asextoys = $_POST['asextoys'];
$aautre = $_POST['aautre'];
$dehors = $_POST['dehors'];
$boules_geisha = $_POST['boules_geisha'];
$oeuf_vibrant = $_POST['oeuf_vibrant'];
$vibro_phallique = $_POST['vibro_phallique'];
$gode = $_POST['gode'];
$plug_anal = $_POST['plug_anal'];
$anneau_vibrant = $_POST['anneau_vibrant'];
$aneros = $_POST['aneros'];
$chapelet_thai = $_POST['chapelet_thai'];
$canard = $_POST['canard'];
$stimulateur_clito = $_POST['stimulateur_clito'];
$legumes = $_POST['legumes'];
$fruits = $_POST['fruits'];
$brosse_a_dent_electrique = $_POST['brosse_a_dent_electrique'];
$a_boules_geisha = $_POST['boules_geisha'];
$a_oeuf_vibrant = $_POST['oeuf_vibrant'];
$a_vibro_phallique = $_POST['vibro_phallique'];
$a_gode = $_POST['gode'];
$a_plug_anal = $_POST['plug_anal'];
$a_anneau_vibrant = $_POST['anneau_vibrant'];
$a_aneros = $_POST['aneros'];
$a_chapelet_thai = $_POST['chapelet_thai'];
$a_canard = $_POST['canard'];
$a_stimulateur_clito = $_POST['stimulateur_clito'];
$a_legumes = $_POST['legumes'];
$a_fruits = $_POST['fruits'];
$a_brosse_a_dent_electrique = $_POST['brosse_a_dent_electrique'];
//récupération des données du vote
$prenoms = array ("François", "Michel", "Nicole", "Veronique", "Benoît");
$reponse = array("$pseudo", "$jour", "$mois", "$annee", "$heure", "$minute", "$sec", "$age", "$sexe", "$deja", "$plus", "$couple", "$dehors", "$avec", "$culpa", "$pareil", "$frequence", "$message", "$adehors", "$amis", "$famille", "$homo", "$tente", "$hfaire", "$hrecevoir", "$voir", "$recevoir", "$faire", "$involt", "$volt", "$used", "$plusieurs", "$sextoys", "$autre", "$aused", "$aplusieurs", "$asextoys", "$aautre",);
$toys3 = array("$boules_geisha", "$oeuf_vibrant", "$vibro_phallique", "$gode", "$plug_anal", "$anneau_vibrant", "$aneros", "$chapelet_thai", "$canard", "$stimulateur_clito", "$legumes", "$fruits", "$brosse_a_dent_electrique", "$a_boules_geisha", "$a_oeuf_vibrant", "$a_vibro_phallique", "$a_gode", "$a_plug_anal", "$a_anneau_vibrant", "$a_aneros", "$a_chapelet_thai", "$a_canard", "$a_stimulateur_clito", "$a_legumes", "$a_fruits", "$a_brosse_a_dent_electrique" );
$toys2 = array("boules_geisha", "oeuf_vibrant", "vibro_phallique", "gode", "plug_anal", "anneau_vibrant", "aneros", "chapelet_thai", "canard", "stimulateur_clito", "legumes", "fruits", "brosse_a_dent_electrique", "a_boules_geisha", "a_oeuf_vibrant", "a_vibro_phallique", "a_gode", "a_plug_anal", "a_anneau_vibrant", "a_aneros", "a_chapelet_thai", "a_canard", "a_stimulateur_clito", "a_legumes", "a_fruits", "a_brosse_a_dent_electrique" );
$toys = $boules_geisha.$oeuf_vibrant.$vibro_phallique.$gode.$plug_anal.$anneau_vibrant;
mysql_connect("localhost", "tykayn", "janken7");
mysql_select_db("test");
//écriture dans la BDD des résultats du vote
if ($_POST['pseudo'] == NULL OR $_POST['pseudo'] == NULL)
{ echo '
hohéééééééhooooo! retourne au formulaire de sondage et donne un pseudo ET un message!!
';
}
elseif ($_POST['message'] == NULL)
{ echo 'hohéééééééhooooo! rentre un message, raclure!!!
';
}
else
{
mysql_query("INSERT INTO sondage4 VALUES('',
'" . $pseudo . "',
'" . $age . "',
'" . $sexe . "',
'" . $deja . "',
'" . $plus . "',
'" . $couple . "',
'" . $dehors . "',
'" . $avec . "',
'" . $culpa . "',
'" . $pareil . "',
'" . $frequence . "',
'" . $message . "',
'" . $adehors . "',
'" . $amis . "',
'" . $famille . "',
'" . $homo . "',
'" . $tente . "',
'" . $hfaire . "',
'" . $involt . "',
'" . $volt . "',
'" . $used . "',
'" . $plusieurs . "',
'" . $sextoys . "',
'" . $autre . "',
'" . $aused . "',
'" . $aplusieurs . "',
'" . $asextoys . "',
'" . $aautre . "',
'" . $boules_geisha . "',
'" . $oeuf_vibrant . "',
'" . $vibro_phallique . "',
'" . $gode . "',
'" . $plug_anal . "',
'" . $anneau_vibrant . "',
'" . $aneros . "',
'" . $chapelet_thai . "',
'" . $canard . "',
'" . $stimulateur_clito . "',
'" . $legumes . "',
'" . $fruits . "',
'" . $brosse_a_dent_electrique . "',
'" . $a_boules_geisha . "',
'" . $a_oeuf_vibrant . "',
'" . $a_vibro_phallique . "',
'" . $a_gode . "',
'" . $a_plug_anal . "',
'" . $a_anneau_vibrant . "',
'" . $a_aneros . "',
'" . $a_chapelet_thai . "',
'" . $a_canard . "',
'" . $a_stimulateur_clito . "',
'" . $a_legumes . "',
'" . $a_fruits . "',
'" . $a_brosse_a_dent_electrique . "',
' date ".$jour." ".$mois." ".$annee." ".$date[4]." ".$date[5]." ".$date[6]."'
)");
}
//x personnes ont déjà voté
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM sondage4");
$donnees = mysql_fetch_array($retour);
?>
Il y a gens qui ont voté !
';
mysql_connect("localhost", "tykayn", "janken7");
mysql_select_db("test");
$reponse = mysql_query('SELECT * FROM sondage4 ORDER BY id DESC LIMIT ');
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM sondage4 WHERE couple='couple'");
$donnees = mysql_fetch_array($retour);
echo 'il y a'.$donnees['nbre_entrees'].' personnes en couple
';
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM sondage4 WHERE sexe='h'");
$donnees = mysql_fetch_array($retour);
echo ''.$donnees['nbre_entrees'].' hommes';
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM sondage4 WHERE sexe='f'");
$donnees = mysql_fetch_array($retour);
echo ' et '.$donnees['nbre_entrees'].' femmes
';
$retour = mysql_query("SELECT COUNT(*) AS nbre_entrees FROM sondage4 WHERE boules_geisha='oui'");
$donnees = mysql_fetch_array($retour);
echo ' et '.$donnees['nbre_entrees'].' personnes ont utilisé des boules geisha pour eux/elles.
';
mysql_close(); // On n'oublie pas de fermer la connexion à MySQL ;o)
?>
wouéééé!