Location: PHPKode > projects > EasyFest > new/user_votePolling.php
<?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["loggedIn"] == FALSE){
		header("Location:admin_login.php");
		exit;
			
	}include_once("config.php");
		$UserName=$_SESSION['UserName'];

	include('header1.php');
	$query1=mysql_fetch_array(mysql_query("select UserName FROM users WHERE Type='1' AND  UserName='$UserName'" ));
if($UserName==$query1['UserName'] ){
	 echo $UserName;
	 include('left_user.php');}
	 else{
	
	 include('left_coord.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">&nbsp;</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 = "user_votePolls.php?PollId=<?php echo  $PollId ;?>"
//-->
</script>	

                    </p>
				</div>
		  </div>
		</div>
        </div>
        <!-- end content -->
		<!-- start sidebars -->
		<!-- end sidebars -->
	  <div style="clear: both;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest