<?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"> </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;"> </div>
</div>
<!-- end page -->
</div>
</html>
<?php
include('footer.php');
?>