<?php
include_once("include/db_connection.php");
header("Expires: Thu, 17 May 2001 10:17:17 GMT"); // Date in the past
header ("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); // always modified
header ("Cache-Control: no-cache, must-revalidate"); // HTTP/1.1
header ("Pragma: no-cache"); // HTTP/1.0
session_start();
if($_SESSION["adminloggedIn"] == FALSE){
header("Location:admin_login.php");
exit;
}
include('header.php');
include('left1.php');
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>View All Polls</title>
<meta name="keywords" content="" />
<meta name="Premium Series" content="" />
<link href="default.css" rel="stylesheet" type="text/css" media="screen" />
<script language="JavaScript" src="gen_validatorv31.js" type="text/javascript"></script>
<title>View All Polls</title>
</head>
<body>
<div id="wrapper">
<!-- start page -->
<div id="page">
<!-- start content -->
<div id="prtCnt" align="center">
<div id="content" align="center">
<div class="post">
<h2 class="title"> </h2>
<div class="entry">
<?php
$PollId=$_GET['PollId'];
//print_r($_GET);
//print_r($_POST);
$TableName="Poll"."$PollId";
$UserName = $_SESSION['UserName'];
$Response = $_POST['RadioGroup1'];
echo "response === ";
echo $Response;
$result4 = mysql_fetch_array(mysql_query("SELECT * FROM polls WHERE PollId = $PollId "));
if($Response==1)
{
$sqlQuery = "INSERT INTO $TableName(`PollsName`,`UserName`,`Response1`,`Response2`,`Response3`,`Response4`,`Response5` ) VALUES
('$result4[PollName]', '$UserName', '1', '0', '0', '0' , '0')";
}
else if($Response==2)
{
$sqlQuery = "INSERT INTO $TableName(`PollsName`,`UserName`,`Response1`,`Response2`,`Response3`,`Response4`,`Response5` ) VALUES
('$result4[PollName]', '$UserName', '0', '1', '0', '0' , '0')";
}
else if($Response==3)
{
$sqlQuery = "INSERT INTO $TableName(`PollsName`,`UserName`,`Response1`,`Response2`,`Response3`,`Response4`,`Response5` ) VALUES
('$result4[PollName]', '$UserName', '0', '0', '1', '0' , '0')";
}
else if($Response==4)
{
$sqlQuery = "INSERT INTO $TableName(`PollsName`,`UserName`,`Response1`,`Response2`,`Response3`,`Response4`,`Response5` ) VALUES
('$result4[PollName]', '$UserName', '0', '0', '0', '1' , '0')";
}
else if($Response==5)
{
$sqlQuery = "INSERT INTO $TableName(`PollsName`,`UserName`,`Response1`,`Response2`,`Response3`,`Response4`,`Response5` ) VALUES
('$result4[PollName]', '$UserName', '0', '0', '0', '0' , '1')";
}
$result = mysql_query($sqlQuery) or die("Invalid query: " . mysql_error() . "<br><br>". $sqlQuery);
?>
<script type="text/javascript">
<!--
window.location = "votePolls.php?PollId=<?php echo $PollId ;?>"
//-->
</script>
</p>
</div>
</div>
</div>
</div>
<!-- end content -->
<!-- start sidebars -->
<!-- end sidebars -->
<div style="clear: both;"> </div>
</div>
<!-- end page -->
</div>
</html>
<?php
include('footer.php');
?>