Location: PHPKode > projects > EasyFest > new/creatingPoll.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["adminloggedIn"] == FALSE){
		header("Location:admin_login.php");
		exit;
	}
	
	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>Premium Series by Free CSS Templates</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>Untitled Document</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'];

	$PollDescription = $_POST['PollDescription'];
	
	
	
	$PollName = $_POST['PollName'];
	$Option1 = $_POST['Option1'];
	$Option2 = $_POST['Option2'];
	//echo "bg".$_POST['Option3']."fg";
	if($_POST['Option3']==NULL)
	$Option3 = NULL;
	else
	$Option3 = $_POST['Option3'];
	if($_POST['Option4']=="")
	$Option4 = NULL;
	else
	$Option4 = $_POST['Option4'];
	if($_POST['Option5']=="")
	$Option5 = NULL;
	else
	$Option5 = $_POST['Option5'];
	
    
	$sqlQuery = "INSERT INTO  polls(`UserName`,`PollDescription`,`Option1`,`Option2`,`Option3`,`Option4`,`Option5`,`PollName`) VALUES 
('$UserName', '$PollDescription', '$Option1', '$Option2', '$Option3', '$Option4' , '$Option5', '$PollName')";
$result = mysql_query($sqlQuery) or die("Invalid query: " . mysql_error() . "<br><br>". $sqlQuery);
$query= "SELECT  MAX(PollId) from polls  ";
$result1=mysql_query($query);
$row=mysql_fetch_array($result1);

//echo $row[0];
//foreach($result1 as $value)
//{

 //$count=$value;
// echo $count;
//}
//$result=mysql_query($query);
//$row=mysql_fetch_array($result);

//$TableName=$result[0];
//$TableName=1;

$TableName="Poll"."$row[0]";
//echo $TableName;

$sqlQuery1="CREATE TABLE "."$TableName "." 
(
PollNameId int(10) unsigned NOT NULL AUTO_INCREMENT,
PollsName  varchar(45) NOT NULL,
UserName  varchar(45) NOT NULL,
Response1 tinyint(1) NOT NULL,
Response2 tinyint(1) NOT NULL,
Response3 tinyint(1) NOT NULL,
Response4 tinyint(1) NOT NULL,
Response5 tinyint(1) NOT NULL,
 UNIQUE KEY `UserName` (`UserName`),
  PRIMARY KEY (`PollNameId`)


)";
$result = mysql_query($sqlQuery1) or die("Invalid query: " . mysql_error() . "<br><br>". $sqlQuery1);
		
	

?>

<a href="viewAllPoll.php" ><span>View Polls</span></a>
                    </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