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
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>star</title>
<link rel="stylesheet" type="text/css" href="voteCSS.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
</head>
<body>
<div id="vote">
<?php $id=1; ?>
<div id="texteVote">
Donnez votre avis !
</div>
<div class="icone-vote">
<button type="button" onclick="traitementVote(1, <?php echo $id; ?>)">1</button>
<button type="button" onclick="traitementVote(2, <?php echo $id; ?>)">2</button>
<button type="button" onclick="traitementVote(3, <?php echo $id; ?>)">3</button>
<button type="button" onclick="traitementVote(4, <?php echo $id; ?>)">4</button>
<button type="button" onclick="traitementVote(5, <?php echo $id; ?>)">5</button>
</div>
<?php
/***************************************/
/**** Connection au serveur et base ****/
/***************************************/
$serveur = mysql_connect("localhost","root","");
if (!$serveur)
{
die('Non connecte : ' . mysql_error());
}
$db_basevote = mysql_select_db('basevote', $serveur);
if (!$db_basevote)
{
die ('Impossible d\'utiliser la base : ' . mysql_error());
}
/***************************************/
/***************************************/
/**************************************/
/* Recup ip utilisateur et ip sotckee */
/**************************************/
$ip = $_SERVER['REMOTE_ADDR'];
$sql = "SELECT ip FROM basevote WHERE id = '$id' AND vote = 1";
$envoi = @mysql_query($sql);
$line = @mysql_fetch_row($envoi);
$ipCompare = $line[0];
$testVote = 0;
if ($ip == $ipCompare) {
$testVote = 1;
}
/***************************************/
/***************************************/
/*******************************************/
/** Recup des votes dans la BDD et calculs */
/*******************************************/
$sql = "SELECT nombreVotes FROM basevote WHERE id='$id'";
$envoi = mysql_query($sql);
$nbrVoteX = array();
$i = 0;
while ($lines = mysql_fetch_object($envoi)) {
$nbrVoteX[$i] = $lines->nombreVotes;
$i++;
}
$nbrVote1 = $nbrVoteX[0];
$nbrVote2 = $nbrVoteX[1];
$nbrVote3 = $nbrVoteX[2];
$nbrVote4 = $nbrVoteX[3];
$nbrVote5 = $nbrVoteX[4];
$totalVote = $nbrVote1 + $nbrVote2 + $nbrVote3 + $nbrVote4 + $nbrVote5;
$valeurVote = $nbrVote1 + $nbrVote2*2 + $nbrVote3*3 + $nbrVote4*4 + $nbrVote5*5;
$moyenneVoteBrut = $valeurVote/$totalVote;
$moyenneVote = number_format($moyenneVoteBrut,2);
/***************************************/
/***************************************/
/*******************************************/
/** Affichage des donnees */
/*******************************************/
$info = "rating : $moyenneVote /5 ($totalVote votes cast)" ;
$vote = "Vous avez voté !";
if ( $testVote == 1) {
echo $info;
?> <br /> <?php
echo $vote;
}
else {
echo $info;
}
?>
</div>
<script>
function traitementVote(choixVote, idSite) {
var xhr = new XMLHttpRequest();
data="vote="+choixVote+"&id="+idSite;
xhr.open('POST',votePhP.php);
xhr.setRequestHeader("Content-Type", "application/x-www-form-urlencoded");
xhr.send(data);
}
</script>
</body>
</html> |
Partager