créer un sondage
liste des sondages

----------bravooo tu as voté!----------

"; //récup du nombre de votes (colonne reponse) include('connexion.php'); $recup=mysql_query("SELECT reponse from tk_sondages WHERE id_sondage=".$_POST['id'].""); $tadam=mysql_fetch_array($recup)or die( $recup."
". mysql_error()) ; $num_vote = $tadam[0]+1; if ($tadam[0]==NULL){$tadam[0]=0;} echo"
Il y a $tadam[0] votes avant d'ajouter celui-ci. qui sera le $num_vote
"; //ajout de 1 vote $ajout ="UPDATE `tykayn`.`tk_sondages` SET `reponse` = '".$num_vote."' WHERE id_sondage='".$id_sondage."' AND pour_le_sondage_numero='' LIMIT 1"; mysql_query($ajout) or die( $ajout."
". mysql_error()) ;; $age = $genre = $pseudo=""; //recherche du pseudo print_r($_POST); //si y'en a pas, $pseudo vaut NULL foreach ( $_POST AS $k => $v) { $analyse_reponse = explode("_",$k); if (isset($analyse_reponse[2]) AND $analyse_reponse[2] =="pseudo"){$pseudo=$v;} if (isset($analyse_reponse[2]) AND $analyse_reponse[2] =="genre"){$genre=$v;} if (isset($analyse_reponse[2]) AND $analyse_reponse[2] =="age"){$age=$v;} } $sql ="INSERT INTO tk_sondages VALUES"; //$analyse_reponse[0] = n° du sondage //$analyse_reponse[1] = n° question // $v = réponse $ip_adress = $_SERVER['REMOTE_ADDR']; foreach ( $_POST AS $k => $v) { $v = htmlspecialchars($v); if ($k != 'id') { $analyse_reponse = explode("_",$k); $sql .='(NULL,NOW(),"","","","","","","","'.$analyse_reponse[0].'","'.$analyse_reponse[1].'","'.$v.'","'.$ip_adress.'","'.$num_vote.'_'.$pseudo.'_'.$genre.'_'.$age.'"),'; } //réponse à vote if ($k != 'id' AND $k == 'reponse') { $analyse_reponse = explode("_",$k); $sql .='(NULL,NOW(),"","","","","","","","'.$analyse_reponse[0].'","'.$analyse_reponse[1].'","'.$v.'","'.$ip_adress.'","'.$num_vote.'_'.$pseudo.'"),'; } } //enlever la dernière virgule pour fermer la requete SQL $sql=substr($sql,0,-1); //echo" "; mysql_query($sql) or die( $sql."
". mysql_error()) ; ///////////////////////////////////////////////////////// AJOUT: '.$ajout.'

$id_sondage =$_POST['id']; echo ' ---------- Voir les statistiques des '.$num_vote.' réponses à ce sondage'; mysql_close(); ?> merci d'avoir voté! \o/

liste des sondages