<?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">
<table width="104%" border="0" align="left" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#E6E6E6">Polls Name</td><td bgcolor="#E6E6E6">Poll Description</td><td bgcolor="#E6E6E6">Total Responses</td></tr>
<?php
while($counter[0]>0)
{
$result6 = mysql_fetch_array($temp);
//echo $result6[0]."<br/>";
$counter[0]=$counter[0]-1;
$result2 = mysql_fetch_array(mysql_query("SELECT PollName,PollDescription FROM polls WHERE PollId = $result6[0]"));
//print_r($result2);
//echo "$result2[0]"."$result2[1]";
?><tr><td bgcolor="#FFFFFF" ><?php echo $result2[0]; ?></td>
<td bgcolor="#FFFFFF">
<a href="user_votePolls.php<?php echo "?PollId=".$result6[0] ?>" ><?php echo $result2[1]; ?></a></td><?php $TableName="Poll"."$result6[0]";?>
<td bgcolor="#FFFFFF"><?php //echo $TableName;
$TotalResponse = mysql_fetch_array(mysql_query("SELECT COUNT(UserName) FROM $TableName"));
// print_r($TotalResponse);
echo $TotalResponse[0];?></td><td bgcolor="#FFFFFF"><a href="user_deletePoll.php<?php echo "?PollId=$result6[0]"."&UserName=";?><?php echo $_SESSION["UserName"]?>" >delete</a></td></tr>
<?php
}
?>
</table>
</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');
?>