poll_id;
$query = "SELECT * FROM polls WHERE id = " . $poll_id;
$result = mysql_query($query) or die(mysql_error());
if(!mysql_num_rows($result))
die("Invalid poll id");
$row = mysql_fetch_assoc($result);
$poll_title = $row["question"];
$poll_answers = array($row["answer1"] , $row["answer2"] , $row["answer3"] , $row["answer4"] , $row["answer5"]);
$poll_answers_num = 0;
for($i = 0; $i < 5; $i++)
{
if(!empty($poll_answers[$i]))
$poll_answers_num++;
}
if(!$this->user_voted($_SERVER["REMOTE_ADDR"])) // if the user hasn't voted
{
echo "";
}
else
{
echo "" . $poll_title . "
";
echo "";
for($i = 0; $i < $poll_answers_num; $i++)
{
$answers_sum = $this->answers_sum($i + 1);
$answers_total = $this->answers_total();
$answer_percent = $this->answer_percent($answers_sum , $answers_total);
echo "- " . $poll_answers[$i] . " - " . $answer_percent . "%
";
}
echo "
";
}
}
function user_voted($user_ip)
{
$query = "SELECT * FROM poll_answers WHERE ip = '" . $user_ip . "'";
$result = mysql_query($query) or die(mysql_error());
if(mysql_num_rows($result))
return 1;
return 0;
}
function vote()
{
$poll_id = $this->poll_id;
$answer_id = $this->answer_id;
$ip = $_SERVER["REMOTE_ADDR"];
if($this->user_voted($ip))
return 2;
$result = mysql_query("INSERT INTO `poll_answers` (pollid, answerid, ip) VALUES ('$poll_id', '$answer_id', '$ip')") or die(mysql_error());
if($result != false)
return 1;
return 0;
}
function answers_sum($answerid)
{
$query = "SELECT * FROM poll_answers WHERE pollid = " . $this->poll_id . " AND answerid = " . $answerid;
$result = mysql_query($query) or die(mysql_error());
$answers_sum = 0;
while($row = mysql_fetch_assoc($result))
$answers_sum += $row["answerid"];
return $answers_sum;
}
function answers_total()
{
$query = "SELECT * FROM poll_answers WHERE pollid = " . $this->poll_id;
$result = mysql_query($query) or die(mysql_error());
return mysql_num_rows($result);
}
function answer_percent($answers_sum , $answers_total)
{
return ($answers_sum / $answers_total) * 100;
}
}
?>