<?php
 
echo "<form action='vote.php' method=post>
<table width='300' border='0' cellspacing='0' cellpadding='0' align='center'>";
 
$query1 = "SELECT * FROM questions";
$result1 = mysql_query($query1)or die("ERROR: $query.".mysql_error());
 
$num_row=mysql_num_rows($result1);
 
$i=1;
 
while($i<$num_row){
 
while ($row1 = mysql_fetch_array($result1)) {
 
$qid = $row1['qid'];
$qtitle = $row1['qtitle'];
 
$query2 = "SELECT * FROM answers WHERE qid='$qid'";
$result2 = mysql_query($query2) or die("ERROR: $query.".mysql_error());
 
echo "<tr>
    <td width='300' align='left'><p>".$i.". ".$qtitle."</p></td>
 	 </tr>";
 
while ($row2 = mysql_fetch_array($result2)) {
 
$aid = $row2['aid'];
$atitle = $row2['atitle'];
 
echo "<tr>
    <td width='300' align='left'><input type = radio name =aid value = '".$aid."'><font>".$atitle."</font></input><br></p></td>
 	 </tr>";
}
 
echo "<input type = hidden name = qid value = '".$qid."'>";
echo "<br />";
$i++;
 
}
}
 
echo "<td><br><br></td><tr>
<td width='300' align='center'><input type = submit name = submit value = 'Submit'></td>
</tr>
</table>
</form>";
 
}
}
// close connection
mysql_close();
 
?>

<?php
if (isset($_COOKIE) && !empty($_COOKIE)) {
    if ($_COOKIE['lastpoll'] && $_COOKIE['lastpoll'] == $_POST['qid']) {
	echo '<script>alert("You have already voted. Thank You !!!");</script>';
	echo '<script>location.replace("trysurvey.php");</script>';
	exit();
    }
}
// set cookie
setCookie('lastpoll', $_POST['qid'], time() + 2592000);
 
 
if (isset($_POST['submit'])) {
 
    if (!isset($_POST['aid'])) {
		echo '<script>alert("Please select one of the available choices.");</script>';
		echo '<script>history.back(1);</script>';
    }
	else{
 
	require_once('config.php');
 
	$aid=$_POST['aid'];
	$qid=$_POST['qid'];
 
    // update vote counter
    $query = "UPDATE answers SET acount = acount + 1 WHERE aid = '$aid' AND qid = '$qid'";
    $result = mysql_query($query) or die("ERROR: $query. ".mysql_error());
 
	}
 
    // close connection
    mysql_close();
 
 
    // print success message    
	echo '<script>alert("Your have successfully voted.");</script>';
	echo '<script>location.replace("trysurvey.php");</script>';
}
else {
    echo '<script>alert("Unable to submit your Vote. Please try again !!!");</script>';
	echo '<script>history.back(1);</script>';
}
 
?>