Location: PHPKode > projects > EasyFest > new/viewAllPoll.php
<?php
	include("include/db_connection.php");
	session_start();
	if($_SESSION["adminloggedIn"] == FALSE){
				header("Location:admin_login.php");
				exit;
	}

?>

<?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 ");
	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">&nbsp;</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="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="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;">&nbsp;</div>
	</div>
	<!-- end page -->
</div>
</html>
<?php
	include('footer.php');
?>
Return current item: EasyFest