v3x

<?php	class poll	{		var $poll_id;		var $answer_id;		function display_poll()		{			$poll_id = $this->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 "<form action=\"" . $_SERVER["PHP_SELF"] . "\" method=\"post\">";				echo "<b>" . $poll_title . "</b><br \>";				for($i = 0; $i < $poll_answers_num; $i++) {					echo "<input type=\"radio\" name=\"answerid\" value=\"" . ($i + 1) . "\"> " . $poll_answers[$i] . "<br \>";				}				echo "<input type=\"hidden\" name=\"pollid\" value=\"" . $poll_id . "\">";				echo "<input type=\"submit\" name=\"vote_" . $poll_id . "\" value=\"Vote\">";				echo "</form>";			}			else			{				echo "<b>" . $poll_title . "</b><br \>";				echo "<ul>";				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 , $poll_answers_num);					echo "<li>" . $poll_answers[$i] . " - " . $answer_percent . "%</li>";				}				echo "</ul>";				echo "Total #: " . $poll_answers_num;			}		}		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 mysql_num_rows($result);		}		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 , $poll_answers_total)		{			return ($answers_sum / $poll_answers_total) * 100;		}	}?>