<?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");
$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>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"> </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="user_viewAllPoll.php" ><span>View Polls</span></a>
</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');
?>