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
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
//On prend l'id le plus grand
$nombreEntrees = mysql_query("SELECT MAX(id) AS nbre_entrees FROM sondage") or die(mysql_error());
$numeroDuSondage = mysql_fetch_assoc($nombreEntrees);
//On sélectionne la question et les choix
$req="SELECT question, proposition1, proposition2, proposition3, proposition4, proposition5 FROM sondage WHERE id = '" . $numeroDuSondage['nbre_entrees'] . "' ";
$MySQL_infos = mysql_query($req) or die(mysql_error());
$infos = mysql_fetch_array($MySQL_infos);
//On sélectionne le nombre de votes
$MySQL_votes = mysql_query("SELECT resultats1, resultats2, resultats3,resultats4,resultats5 FROM sondage WHERE id = '" . $numeroDuSondage['nbre_entrees'] . "'") or die(mysql_error());
$votes = mysql_fetch_assoc($MySQL_votes);
//script pour ajouter les votes
//script pour ajouter les votes et ip
$ip = $_SERVER['REMOTE_ADDR'];
$prop = "prop";
$resultat = "resultats";
$fin = false;
if(isset($_POST['sondage']))
{
for($i = 1; $i <= 5 && !$fin; $i++)
{
if($_POST['sondage'] == $prop . $i)
{
$votes[$resultat . $i] ++;
mysql_query("UPDATE sondage SET " . $resultat . $i ." = '" . $votes[$resultat . $i] . "' WHERE id = '" . $numeroDuSondage['nbre_entrees'] . "'") or die(mysql_error());
$fin = true;
}
}
}
// On recupere les nombre total de votes resultat
$query = "SELECT resultats1,resultats2,resultats3,resultats4, resultats5 FROM ".$table." WHERE id="."'" . $numeroDuSondage['nbre_entrees'] . "'";
$row = mysql_query($query);
$data = mysql_fetch_array($row);
$resultat1 = $data["resultats1"];
$resultat2 = $data["resultats2"];
$resultat3 = $data["resultats3"];
$resultat4 = $data["resultats4"];
$resultat5 = $data["resultats5"];
$total_votes = $resultat1 + $resultat2 + $resultat3 + $resultat4 + $resultat5;
if($total_votes != 0){
$pourcentage_r1 = ($resultat1 / $total_votes) * 100;
$pourcentage_r2 = ($resultat2 / $total_votes) * 100;
$pourcentage_r3 = ($resultat3 / $total_votes) * 100;
$pourcentage_r4 = ($resultat4 / $total_votes) * 100;
$pourcentage_r5 = ($resultat5 / $total_votes) * 100;
}
else{
$pourcentage_r1 = 0;
$pourcentage_r2 = 0;
$pourcentage_r3 = 0;
$pourcentage_r4 = 0;
$pourcentage_r5 = 0;
}
$long_max_bloc = 120;
//recupere ip et on insere par rapport à l'id
$query = "SELECT vote_ip FROM $table1 WHERE sondage_id="."'" . $numeroDuSondage['nbre_entrees'] . "' " ;
$result = mysql_query($query);
$num = mysql_num_rows($result);
if($num)
{
if ($infos['question'] != "")
echo '<span style="color:#4C1B1B;font-size:20px;">'.$infos['question'].'</span>'.'<br/>'. "";
if ($infos['proposition1'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition1'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop1' id='prop1' /> <label for='prop1'>" .'<img src="img/greenrond.gif">'.'<img src="img/green.gif" height="16" width="' . $pourcentage_r1 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r1).'%" />' . '<img src="img/greendroit.gif"/>' . round($pourcentage_r1) . "% </label><br />";
if ($infos['proposition2'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition2'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop2' id='prop2' /> <label for='prop2'>" .'<img src="img/blackrond.gif">'.'<img src="img/black.gif" height="16" width="' . $pourcentage_r2 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r2).'%" />' . '<img src="img/blackdroit.gif"/>' . round($pourcentage_r2) . "% </label><br />";
if ($infos['proposition3'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition3'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop3' id='prop3' /> <label for='prop3'>" .'<img src="img/redrond.gif">'.'<img src="img/red.gif" height="16" width="' . $pourcentage_r3 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r3).'%" />' . '<img src="img/reddroit.gif"/>' . round($pourcentage_r3) . "% </label><br />";
if ($infos['proposition4'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition4'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop4' id='prop4' /> <label for='prop4'>" .'<img src="img/bluerond.gif">'.'<img src="img/blue.gif" height="16" width="' . $pourcentage_r4 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r4).'%" />' . '<img src="img/bluedroit.gif"/>' . round($pourcentage_r4) . "% </label><br />";
if ($infos['proposition5'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition5'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop5' id='prop5' /> <label for='prop5'>" .'<img src="img/copperrond.gif">'.'<img src="img/copper.gif" height="16" width="' . $pourcentage_r5 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r5).'%" />' . '<img src="img/copperdroit.gif"/>' . round($pourcentage_r5) . "% </label><br /><br /><br />";
// echo '<a href="archive.php" style="text-decoration:none;padding-left:10em;"><b><font color="#4C1B1B"> les résultats des anciens sondages </b></font></a>';
exit;
}
$vote_ip = $_SERVER['REMOTE_ADDR'];
$sondage_id = $numeroDuSondage['nbre_entrees'];
$sql = "INSERT INTO $table1 (sondage_id, vote_ip) VALUES ($sondage_id, '$vote_ip')";
mysql_query($sql) or die('Erreur SQL !<br>'.$sql.'<br>'.mysql_error());
?>
<!-- formulaire-->
<form method="post">
<?php
echo '<span style="color:#4C1B1B;font-size:20px;">'.$infos['question'].'</span>'.'<br/>'. "";
echo '<span style="padding-left:2em;">'.$infos['proposition1'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop1' id='prop1' /> <label for='prop1'>" .'<img src="img/greenrond.gif">'.'<img src="img/green.gif" height="16" width="' . $pourcentage_r1 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r1).'%" />' . '<img src="img/greendroit.gif"/>' . round($pourcentage_r1) . "% </label><br />";
echo '<span style="padding-left:2em;">'.$infos['proposition2'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop2' id='prop2' /> <label for='prop2'>" .'<img src="img/blackrond.gif">'.'<img src="img/black.gif" height="16" width="' . $pourcentage_r2 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r2).'%" />' . '<img src="img/blackdroit.gif"/>' . round($pourcentage_r2) . "% </label><br />";
if ($infos['proposition3'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition3'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop3' id='prop3' /> <label for='prop3'>" .'<img src="img/redrond.gif">'.'<img src="img/red.gif" height="16" width="' . $pourcentage_r3 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r3).'%" />' . '<img src="img/reddroit.gif"/>' . round($pourcentage_r3) . "% </label><br />";
if ($infos['proposition4'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition4'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop4' id='prop4' /> <label for='prop4'>" .'<img src="img/bluerond.gif">'.'<img src="img/blue.gif" height="16" width="' . $pourcentage_r4 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r4).'%" />' . '<img src="img/bluedroit.gif"/>' . round($pourcentage_r4) . "% </label><br />";
if ($infos['proposition5'] != "")
echo '<span style="padding-left:2em;">'.$infos['proposition5'].'</span>'.'<br/>'. "<input type='radio' name='sondage' value='prop5' id='prop5' /> <label for='prop5'>" .'<img src="img/copperrond.gif">'.'<img src="img/copper.gif" height="16" width="' . $pourcentage_r5 / 100 * $long_max_bloc . '" alt="'.round($pourcentage_r5).'%" />' . '<img src="img/copperdroit.gif"/>' . round($pourcentage_r5) . "% </label><br /><br /><br />";
?>
<input type="submit" value="Voter !"/><br /><br/>
</form>
<?php
//<a href="archive.php" style="text-decoration:none;color:#4C1B1B;padding-left:10em;"><b> les résultats des anciens sondages </b></a>
?> |
Partager