Location: PHPKode > projects > EasyFest > new/user_votePolls.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:user_login.php");
		exit;
			
	}include_once("config.php");
?>

<?php

/*
      $dbHostname = "localhost";
      $dbUsername = "root";
      $dbPassword = "admin";
      $dbName     = "EasyFest";   
	  $dblink = MYSQL_CONNECT($dbHostname, $dbUsername, $dbPassword) OR DIE("Error !! Unable to connect to database");       

      //Select database or print error message if unsuccessful 
     mysql_select_db($dbName) or die( "Unable to select database ".$dbName); 
*/

$counter = mysql_fetch_array(mysql_query("SELECT COUNT(PollId) FROM polls"));
//echo "$counter[0]"."<br/>";
$temp=mysql_query("SELECT PollId FROM polls ORDER BY (PollId) DESC ");
		$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
$UserName = $_SESSION['UserName'];
$PollId=$_GET['PollId'];
$TableName="Poll"."$PollId";
$result3 = mysql_fetch_array(mysql_query("SELECT Active FROM polls WHERE PollId = $PollId "));
$result7 = mysql_fetch_array(mysql_query("SELECT * FROM polls WHERE PollId = $PollId "));
$result5 = mysql_fetch_array(mysql_query("SELECT count(UserName) FROM $TableName "));
$result4 = mysql_fetch_array(mysql_query("SELECT * FROM polls WHERE PollId = $PollId "));
?>

<?php
//print_r($result5);
if($result3[0]==0 || ($result3[0]==1 && $result5[0]==1) ) 
{
?>
PollName : 
<?php echo $result4[PollName];?>
<br />
Poll Description :
<?php echo $result4[PollDescription];?>
<br />
<?php 
$PollResponse1 = mysql_fetch_array(mysql_query("SELECT SUM(Response1) FROM $TableName"));?>


Total Response of Option 1 is :

<?php echo $PollResponse1[0];?> 
<br />
<?php
$PollResponse2 = mysql_fetch_array(mysql_query("SELECT SUM(Response2) FROM $TableName"));?>
Total Response of Option 2 is : 
<?php echo $PollResponse2[0];?> 
<br />
<?php 
if($result4['Option3']!=NULL)
{
$PollResponse3 = mysql_fetch_array(mysql_query("SELECT SUM(Response3) FROM $TableName"));?>
Total Response of Option 3 is : 

<?php echo $PollResponse3[0];?> 
<br />
<?php
}
if($result4['Response4']!=NULL)
{
$PollResponse4 = mysql_fetch_array(mysql_query("SELECT SUM(Response4) FROM $TableName"));?>
Total Response of Option 4 is : 
<?php echo $PollResponse4[0];?> 
<br />
<?php
}
if($result4['Response5']!=NULL)
{
$PollResponse5 = mysql_fetch_array(mysql_query("SELECT SUM(Response5) FROM $TableName"));?>
Total Response of Option 5 is : 
<?php echo $PollResponse5[0];?> 
<br />
<?php 
}
}
else
{
?> 
PollName : 
<?php echo $result4[PollName];?>
<br/>
Poll Description : 
<?php echo $result4[PollDescription];?>
<br />
<form action="user_votePolling.php<?php echo "?"."PollId="."$PollId" ?>" method="post" >

<TABLE  width="104%" border="0" align="left" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">



<tr>
<td width="303" align="center" bgcolor="#E6E6E6"><?php echo $result4[Option1];?></td>
<td width="212" align="center" bgcolor="#FFFFFF">
<input type="radio" name="RadioGroup1" value="1"/>
</td>
</tr>
<tr>
<td align="center" bgcolor="#E6E6E6"><?php echo $result4[Option2];?></td>
<td align="center" bgcolor="#FFFFFF">
<input type="radio" name="RadioGroup1" value="2"/>
</td>
</tr>
<?php
if($result7['Option3']!=NULL)
{
?>
<tr>
<td align="center" bgcolor="#E6E6E6"><?php echo $result4[Option3];?></td>
<td align="center" bgcolor="#FFFFFF">
<input type="radio" name="RadioGroup1" value="3" />
</td>
</tr>
<?php }?>
<?php
if($result7['Option4']!=NULL)
{
?>
<tr>
<td align="center" bgcolor="#E6E6E6"><?php echo $result4[Option4];?></td>
<td align="center" bgcolor="#FFFFFF">
<input type="radio" name="RadioGroup1" value="4"/>
</td>
</tr>
<?php }?>
<?php
if($result7['Option5']!=NULL)
{
?>

<tr>
<td align="center" bgcolor="#E6E6E6"><?php echo $result4[Option5];?></td>
<td align="center" bgcolor="#FFFFFF">
<input type="radio" name="RadioGroup1" value="5"/>
</td>
</tr>
<?php }?>
</TABLE>
<input name="submit" type="submit">
</form>
<?php 
}
?>

                    </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