
<?
session_start();
	 global $scode;
       
		 $linkID = mysql_connect("localhost", "root", "zangtang");
         mysql_select_db("SciPark");


function findexts ($filename) 
{ 
$filename = strtolower($filename) ; 
$exts = split("[/\\.]", $filename) ; 
$n = count($exts)-1; 
$exts = $exts[$n]; 
return $exts; 
} 

//------------------------------------------------------------------------------------------------------------------------------------
//                                  VERIFY FORM FUNCTION
//---------------------------------------------------------------------------------------------------------------------------------------


function VerifyForm(&$values, &$errors)
{

   if (htmlentities($values['EventType']) == "Select")  $errors['EventType'] = "Event Name Required"; 
   

   if(htmlentities($values['EventType']) == "Other" || htmlentities($values['EventType']) == "Demonstration" || htmlentities($values['EventType']) == "CelebrationDay") 
	  {
	      if(strlen($values['EventName'])== 0)  	    $errors['EventName'] = "Event Name Required"; 
      }

    if(htmlentities($values['EventType']) == "Lecture")
	 {
	     if(strlen($values['EventName'])== 0)  	    $errors['EventName'] = "Lecture Series Name Required"; 
		 if(strlen($values['TopicName'])== 0)  	    $errors['TopicName'] = "Lecture Topic Required"; 
		 if(strlen($values['SpeakerName'])== 0)  	    $errors['SpeakerName'] = "Speaker's Info. Required"; 
	 }
    
	if(strlen($values['EventDuration'])== 0)  $errors['EventDuration'] = "Event Duration Required (Time & Date)"; 
    if(strlen($values['EventEligibility'])== 0)  $errors['EventEligibility'] = "Event's Eligibility Criteria Required"; 
 
    if(strlen($values['EventBatchSize'])== 0 && (htmlentities($values['EventType']) == "SciCamp" || htmlentities($values['EventType']) == "SummerCamp"))  $errors['EventBatchSize'] = "Batch Size Required"; 
 

   if(htmlentities($values['EventType']) == "SciCamp" || htmlentities($values['EventType']) == "TeachersPgm" || htmlentities($values['EventType']) == "SummerCamp") 
	{
		if(strlen($values['EventFees'])== 0)  $errors['EventFees'] = "Course Fees Required"; 
	}


  	$RegStartDate =  $values['RegStartYear']."-".$values['RegStartMonth']."-".$values['RegStartDay']; //echo $RegStartDate;
	$RegLastDate =  $values['RegLastYear']."-".$values['RegLastMonth']."-".$values['RegLastDay'];
	$BatchStartDate =  $values['BatchStartYear']."-".$values['BatchStartMonth']."-".$values['BatchStartDay'];
	$BatchEndDate =  $values['BatchEndYear']."-".$values['BatchEndMonth']."-".$values['BatchEndDay'];


	if(htmlentities($values['RegReqd']) == "Yes")
	{
		if(!checkdate( $values['RegStartMonth'], $values['RegStartDay'], $values['RegStartYear'])) $errors['RegStartDate'] = 'Correct Registration Starting Date Required'; 
        if(!checkdate( $values['RegLastMonth'], $values['RegLastDay'], $values['RegLastYear'])) $errors['RegLastDate'] = 'Correct Registration Ending Date Required';

		if($RegStartDate > $RegLastDate) $errors['RegLastDate'] = 'Select the date after Opening date of Registration';
		if($RegLastDate > $BatchStartDate) $errors['BatchStartDate'] = 'Select the date after Last date of Registration';
		if($BatchStartDate > $BatchEndDate) $errors['BatchEndDate'] = 'Select the date after Starting date of Batch';	

	//	if($RegStartDate != "Select-Select-Select") 
	//	{
	//        if(!checkdate( $values['RegLastMonth'], $values['RegLastDay'], $values['RegLastYear'])) $errors['RegLastDate'] = 'Correct Registration Ending Date Required';   
	//	}
		
	}

	if(!checkdate( $values['BatchStartMonth'], $values['BatchStartDay'], $values['BatchStartYear'])) $errors['BatchStartDate'] = 'Correct Batch Starting Date Required'; 
	if(!checkdate( $values['BatchEndMonth'], $values['BatchEndDay'], $values['BatchEndYear'])) $errors['BatchEndDate'] = 'Correct Batch Ending Date Required';
	
	if($BatchStartDate > $BatchEndDate) $errors['BatchEndDate'] = 'Select the date after Starting date of Batch';
	

 // if (htmlentities($values['RegReqd']) == "Yes" && (htmlentities($values['EventType']) == "LPF" || htmlentities($values['EventType']) == "ScienceDay" || htmlentities($values['EventType']) == "Other" || //htmlentities($values['EventType']) == "Lecture"  || htmlentities($values['EventType']) == "Demonstration" || htmlentities($values['EventType']) == "CelebrationDay"))

 
//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ FILE ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

	$EventFile = $_SESSION['EventFile']; 

	$Code = $_SESSION['Code'] ;  

	 $_SESSION['uploads'] = "1";

	 $uploaddir = "uploads/";

		  $query0 = "SELECT  `EventNo` FROM EventsInfo Order by EventNo";
		  $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
		  $tung0=mysql_affected_rows();

		  if($tung0 != 0)  { while ($r = mysql_fetch_array($result0))  {  $EventCnt = $r["EventNo"]; }	  $EventCnt++;		  } 
 		  else  {   $EventCnt = "1";  }
		 

	   $ext = findexts($_FILES['Event_PDF']['name']) ; // POST Extension of File echo $ext; 
	   if($ext == "") { $_SESSION["FileUp"]= 0; } else { $_SESSION["FileUp"]= 1; }
	   $tname = $Code."EV".$EventCnt."Brochure."; 
	   $filename  = $tname.$ext; 
	   
	   $uploadfile = $uploaddir.$filename;  // echo "----->".$uploadfile;
	   $_SESSION["uploadfile"] = $uploadfile;

	if($ext != "")
	 {
 	   if(($_FILES['Event_PDF']['size']) > 5242880)   { $errors['EventFL'] = "File Size is more than 5 MB"; }  
	   if((!ereg(".pdf", $filename)))	   { $errors['EventFL'] = "Event Brochure : Only PDF allowed";	} 
	 }


//~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
//print_r($errors);
return (count($errors) == 0);
}


//---------------------------------------------------------------------------------------------------------------------------------------
//                                                             DISPLAY FORM FUNCTION
//---------------------------------------------------------------------------------------------------------------------------------------

function outputOptionList($list, $selected)
{

	foreach ($list as $item)
		echo "<option value=\"{$item['Value']}\"" . ($item['Value'] === $selected ? " selected=\"selected\"" : '') . ">{$item['Text']}</option>\n";
}


function DisplayForm($values, $errors)
{ 
//	$chars = "abcdefghijkmnopqrstuvwxyz023456789"; $i=0;

	$d=date(d);
	$m=date(F);
	$n=date(n);
	$y=date(Y);

	$optionListMonth = array(
		array('Value' =>'Select', 'Text' => '(select Month)'),
		array('Value' =>'01', 'Text' => 'January'),
		array('Value' =>'02', 'Text' => 'February'),
	    array('Value' =>'03', 'Text' => 'March'),
		array('Value' =>'04', 'Text' => 'April'),
		array('Value' =>'05', 'Text' => 'May'),
		array('Value' =>'06', 'Text' => 'June'),
		array('Value' =>'07', 'Text' => 'July'),
		array('Value' =>'08', 'Text' => 'August'),
		array('Value' =>'09', 'Text' => 'September'),
		array('Value' =>'10', 'Text' => 'October'),
		array('Value' =>'11', 'Text' => 'November'),
		array('Value' =>'12', 'Text' => 'December'),
		);

	$optionEventName = array(
		array('Value' =>'Select', 'Text' => '(select Event)'),
		array('Value' =>'Lecture', 'Text' => 'Lecture'),
		array('Value' =>'Demonstration', 'Text' => 'Demonstration'),
		array('Value' =>'CelebrationDay', 'Text' => 'Celebration Day'),
		array('Value' =>'SciCamp', 'Text' => 'Initiative in Science Education for School Children(Handson training Lab'),
		array('Value' =>'LPF', 'Text' => 'Lila Poonawalla Foundation Girls Science Camp'),
		array('Value' =>'ScienceDay', 'Text' => 'Science Day/Open Day'),
		array('Value' =>'SummerCamp', 'Text' => 'Summer Science Camp'), 
		array('Value' =>'TeachersPgm', 'Text' => 'Teachers Training Program'), 
		array('Value' =>'SchoolVisit', 'Text' => 'School Visit'),
		array('Value' =>'Other', 'Text' => 'Other'),
		);

       $nextY = $y+1; //echo $nextY;
	   $next2Y = $nextY+1; //echo $next2Y;

	$optionListYear = array(
		array('Value' => 'Select', 'Text' => "(select Year)"),
 		array('Value' => '2023', 'Text' => "2023"),
 		array('Value' => '2024', 'Text' => "2024"),
 		array('Value' => '2025', 'Text' => "2025"),

		); 
	

//print_r($optionListYear);

	$days = array(

		array('Value' =>'Select', 'Text' => 'Date'),
	    array('Value' =>'01', 'Text'  => '01'),
	    array('Value' =>'02', 'Text'  => '02'),
	    array('Value' =>'03', 'Text'  => '03'),
	    array('Value' =>'04', 'Text'  => '04'),
	    array('Value' =>'05', 'Text'  => '05'),
	    array('Value' =>'06', 'Text'  => '06'),
	    array('Value' =>'07', 'Text'  => '07'),
	    array('Value' =>'08', 'Text'  => '08'),
	    array('Value' =>'09', 'Text'  => '09'),
	    array('Value' =>'10', 'Text'  => '10'),
	    array('Value' =>'11', 'Text'  => '11'),
	    array('Value' =>'12', 'Text'  => '12'),
	    array('Value' =>'13', 'Text'  => '13'),
	    array('Value' =>'14', 'Text'  => '14'),
	    array('Value' =>'15', 'Text'  => '15'),
	    array('Value' =>'16', 'Text'  => '16'),
	    array('Value' =>'17', 'Text'  => '17'),
	    array('Value' =>'18', 'Text'  => '18'),
	    array('Value' =>'19', 'Text'  => '19'),
	    array('Value' =>'20', 'Text'  => '20'),
	    array('Value' =>'21', 'Text'  => '21'),
	    array('Value' =>'22', 'Text'  => '22'),
	    array('Value' =>'23', 'Text'  => '23'),
	    array('Value' =>'24', 'Text'  => '24'),
	    array('Value' =>'25', 'Text'  => '25'),
	    array('Value' =>'26', 'Text'  => '26'),
		array('Value' =>'27', 'Text'  => '27'),
	    array('Value' =>'28', 'Text'  => '28'),
	    array('Value' =>'29', 'Text'  => '29'),
	    array('Value' =>'30', 'Text'  => '30'),
	    array('Value' =>'31', 'Text'  => '31'),
	    );

    ?>
		<html>

		<head>
		<meta http-equiv="Content-Language" content="en-us">
		<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
		<meta name="ProgId" content="FrontPage.Editor.Document">
		<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
		<title>SCIENCE PARK UNIVERSITY OF PUNE</title>

			<link rel="shortcut icon" href="../images/favicon.png?v=2" type="image/png" />
		<link rel="stylesheet" type="text/css" href="css/custom.css">
		<link rel="stylesheet" type="text/css" href="css/style.css">
		<link rel="stylesheet" href="css/bootstrap.css">
		<link rel="stylesheet" type="text/css" href="css/font-awesome.css">

		<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
		<script src="js/bootstrap.min.js"></script>

		<script>
			$(document).ready(function() {

				$("#header").load("header.html", function() {
					$("events").addClass("active"); 
				});   

				$("#footer").load("footer.html", function() {      
				});    
				
			});

		</script>
	
	<style>	TD.error { color: yellow; font-weight: bold; } </style>
	</head>	
		<div class="container-fluid">
		<header id="header"></header>


	<body background="../images/bg2.jpg">

	
		<form method="POST" name="AddEvent" action="" enctype="multipart/form-data">

<table border="0" width="100%" height="201">
	<tr><td width="19%" height="197" background="images/events-bg.png"><p align="center">&nbsp;</td><td width="34%" height="197"><p align="center"><b>
	<font face="Comic Sans MS" size="7" color="#0000FF">Upcoming Events</font></b></p><p>&nbsp;</td><td width="46%" height="197" background="../images/events_Top.png">&nbsp;</td></tr>
</table>


<p align="center"><i><b><font face="Verdana" color="#FF0000" size="5">To add a New Event, please fill the detailed information...</font></b></i></p>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
	<tr><td width="10%">&nbsp;</td><td width="67%">

  <table border="0" width="100%" bgcolor="#00FFFF"><tr><td width="35%"  align="left" height="13"><span style="font-size: 3pt">&nbsp; </span></td><td width="65%"  align="left" height="13">
	<span style="font-size: 3pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Type of Event&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%" >
	<select size="1" name="EventType" onchange="this.form.submit()">
         <? outputOptionList($optionEventName, $values['EventType']); ?>    
	</option></select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

	<!-----------------------------       Display Name field -----------------------------------------------------------------------------------------------------------------------------> 

	<? if(htmlentities($values['EventType']) == "Other" ||  htmlentities($values['EventType']) == "Demonstration" || htmlentities($values['EventType']) == "CelebrationDay") { ?>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Name of the Event&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%" >
	<input type="text" name="EventName" size="40" value="">
	<FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>
	<? }
	
	if(htmlentities($values['EventType']) == "Lecture") 
	  { ?>
		 <tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
 		 <tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Name of the Lecture Series&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%">
 		 <input type="text" name="EventName" size="40" value="">
		 <FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

		 <tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
 		 <tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Topic of the Lecture &nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%">
 		 <input type="text" name="TopicName" size="40" value="">
		 <FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

		 <tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
 		 <tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Lecture by Speaker&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%">
 		 <input type="text" name="SpeakerName" size="40" value="">
		 <FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

		<? } ?>
	<!--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 


	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
	
	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Duration of the Event(Day &amp; Time)&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%">
	<input type="text" name="EventDuration" size="49" value=""><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 3pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Eligibility Criteria&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%" >
	<input type="text" name="EventEligibility" size="36" value=""><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font></td></tr>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
			
	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">&nbsp;Batch size&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%" >
	<input type="text" name="EventBatchSize" size="30" value=""><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp; </b></font></td></tr>


<!------------------------------------------------ FEE --------------------------------------------------------------------------------------------------------------------------------------->
<?  if(htmlentities($values['EventType']) != "LPF") 
	{ ?>
	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">Fees :&nbsp;&nbsp; </font></i></b></td><td width="65%" >
	<input type="text" name="EventFees" size="30" value=""><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>	</td></tr>
	<? } ?>
<!----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#003E3E">Extra Information&nbsp;&nbsp;&nbsp;<font size="2"><br>(If anything like early bird discount etc.)&nbsp; </font></i>:<font size="2"><i>&nbsp; </i></font></font></b></td><td width="65%" ><input type="text" name="EventExtraInfo" size="56" value=""></td></tr>


	  <tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

		<tr><td width="35%"  align="right"  bgcolor="#91FFFF"><b><i><font face="Verdana" color="#003E3E">Registration Required?&nbsp;&nbsp;</font></i></b></td><td width="65%"  bgcolor="#91FFFF" >
		<input type="radio" value="Yes" name="RegReqd" onClick="this.form.submit()" <? if(htmlentities($values['RegReqd']) == "Yes") { echo "checked"; } ?>>Yes&nbsp;
		<input type="radio" value="No"  name="RegReqd" onClick="this.form.submit()" <? if(htmlentities($values['RegReqd']) == "No") { echo "checked"; } ?>>No</font></b>
		<FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>	
		</td></tr>

	  <tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

		<? if(htmlentities($values['RegReqd']) == "Yes") 
			{ ?>

			<tr><td width="35%"  align="right"  bgcolor="#91FFFF"><b><i><font face="Verdana" color="#003E3E">Registration opens on:&nbsp;&nbsp;</font></i></b></td><td width="65%"  bgcolor="#91FFFF" >
			<select size="1" name="RegStartDay">
				 <? outputOptionList($days, $values['RegStartDay']); ?>    
			</option></select>&nbsp;
			<select size="1" name="RegStartMonth">
				 <? outputOptionList($optionListMonth, $values['RegStartMonth']); ?>    
			</option></select>&nbsp;
			<select size="1" name="RegStartYear">
					 <? outputOptionList($optionListYear, $values['RegStartYear']); ?>    
			</select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>	
			</td></tr>

			<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

			<tr><td width="35%"  align="right"  bgcolor="#91FFFF"><b><i><font face="Verdana" color="#003E3E">Last date of registration :&nbsp;&nbsp;</font></i></b></td><td width="65%"  bgcolor="#91FFFF" >
			<select size="1" name="RegLastDay">
				 <? outputOptionList($days, $values['RegLastDay']); ?>    
			</option></select>&nbsp;
			<select size="1" name="RegLastMonth">
				 <? outputOptionList($optionListMonth, $values['RegLastMonth']); ?>    
			</option></select>&nbsp;
			<select size="1" name="RegLastYear">
					 <? outputOptionList($optionListYear, $values['RegLastYear']); ?>    
			</select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>	
			</td></tr>
 <?     } ?>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"  bgcolor="#B9FFFF"><b><i><font face="Verdana" color="#003E3E">&nbsp;Batch Starting Date&nbsp;<font face="Verdana" color="#FF0000">*</font>&nbsp;:&nbsp;&nbsp; </font></i></b></td><td width="65%"  bgcolor="#B9FFFF">
	
	 <select size="1" name="BatchStartDay">
         <? outputOptionList($days, $values['BatchStartDay']); ?>    
	</option></select>&nbsp;
	<select size="1" name="BatchStartMonth">
         <? outputOptionList($optionListMonth, $values['BatchStartMonth']); ?>    
	</option></select>&nbsp;
	<select size="1" name="BatchStartYear">
	         <? outputOptionList($optionListYear, $values['BatchStartYear']); ?>    
	</select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>			 
	</td></tr>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right" bgcolor="#D5FFFF"><b><i><font face="Verdana" color="#003E3E">Batch Ending Date&nbsp; :&nbsp;&nbsp;</font></i></b></td><td width="65%" bgcolor="#D5FFFF">
	 <select size="1" name="BatchEndDay">
         <? outputOptionList($days, $values['BatchEndDay']); ?>    
	</option></select>&nbsp;
	<select size="1" name="BatchEndMonth">
         <? outputOptionList($optionListMonth, $values['BatchEndMonth']); ?>    
	</option></select>&nbsp;
	<select size="1" name="BatchEndYear">
	         <? outputOptionList($optionListYear, $values['BatchEndYear']); ?>    
	</select><FONT COLOR=#FF0000 Face="Comic Sans MS" size='2'><b>&nbsp;</b></font>	
	</td></tr>

	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
<?
   if($EventFile != "Up")
 	 { 
		$EventFile =  $_SESSION['EventFile'];       			?>

		<tr><td width="35%"  align="right"><b><i><font face="Verdana" color="#FF0000"><span style="background-color: #FFFF00">Upload Brochure File&nbsp;&nbsp; :&nbsp;&nbsp; </span></font></i></b></td><td width="65%" >
		<input type="file" name="Event_PDF" size="30"> <input type="hidden" name="MAX_FILE_SIZE" value="307200" /><font face="Verdana" size="2" color="#FFFF00">
		<span style="background-color: #CF3C15"></b></td></tr>
 <? }
	else
	{ 
		$EventFile =  $_SESSION['EventFile'] ;     
		unset($_SESSION['EventFile']);
		unset($_SESSION['uploads']); //		session_unregister("PHDFile");
	}
?> 
	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>

	<tr><td width="35%"  align="right"><input type="submit" value="Submit for Uploading Event" name="AddEvent">&nbsp;&nbsp;</td><td width="65%" >&nbsp;&nbsp;<input type="reset" value="Reset" name="B2"></td></tr>


	<tr><td width="35%"  align="right"><span style="font-size: 5pt">&nbsp;</span></td><td width="65%" ><span style="font-size: 5pt">&nbsp;</span></td></tr>
  </table>
		</td><td width="10%"><p align="center"><font face="Verdana"><img border="0" src="../images/Event_Left.png" width="112" height="177"></font></td></tr>
 </table></form><p>&nbsp;</p>


		</body>
		</html>
<?
 }

//---------------------------------------------------------------------------------------------------------------------------------------
	$login = $_SESSION['AdminLogin'] ; 

     $linkID = mysql_connect("localhost", "webuser", "zangtang");
     mysql_select_db("SciPark");

	 $query0 = "SELECT * FROM AdminLogin WHERE `AdminLogin`='$login'";
     $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
     $tung0=mysql_affected_rows();
     $i=0; $j=0;				 

 if(isset($_SESSION['AdminLogin']))
  { 
    if($tung0)
	  {

		if($_SERVER['REQUEST_METHOD'] == "POST")
		 {
			 //echo $_SESSION["TP"];

			$formValues = $_POST;
			$formErrors = array();

			//echo "the errors are :".$formValues."--".$Sname;
		 if(isset($_POST["AddEvent"]))
			{ 
			  if(!VerifyForm($formValues, $formErrors)) 	  
				  DisplayForm($formValues, $formErrors); 
			else
			 {
				//$formValues = $_POST;
				//$formErrors = array();

			$EventType = $_POST["EventType"]; 
			$EventName = $_POST["EventName"]; 
			$EventOther = $_POST["EventOther"]; 

			$TopicName = $_POST["TopicName"]; 
			$SpeakerName = $_POST["SpeakerName"]; 


			$EventDuration = $_POST["EventDuration"]; 
			$EventEligibility = $_POST["EventEligibility"]; 
			$EventBatchSize = $_POST["EventBatchSize"]; 
			
			$EventExtraInfo = $_POST["EventExtraInfo"]; 
			$EventFees = $_POST["EventFees"]; 
			
			$RegStartDay = $_POST["RegStartDay"]; 
			$RegStartMonth = $_POST["RegStartMonth"]; 
			$RegStartYear = $_POST["RegStartYear"]; 


			$RegReqd = $_POST["RegReqd"];

			$RegLastDay = $_POST["RegLastDay"];  //echo "-->".$RegLastDay."<br>";
			$RegLastMonth = $_POST["RegLastMonth"]; 
			$RegLastYear = $_POST["RegLastYear"]; 

			$BatchStartDay = $_POST["BatchStartDay"]; 
			$BatchStartMonth = $_POST["BatchStartMonth"]; 
			$BatchStartYear = $_POST["BatchStartYear"];
			
			$BatchEndDay = $_POST["BatchEndDay"]; 
			$BatchEndMonth = $_POST["BatchEndMonth"]; 
			$BatchEndYear = $_POST["BatchEndYear"];

		
			switch($EventType)
			 {
					//case 'Lecture': $EvName =  'Lecture'; break;
					//case 'Demonstration': $EvName =  'Demonstration'; break;
					//case 'CelebrationDay': $EvName =  'Celebration Day'; break;
					case 'SciCamp': $EvName =  'Initiative in Science Education for School Children(Handson training Lab)'; break;
					case 'LPF': $EvName =  'Lila Poonawalla Foundation Girls Science Camp'; break;
					case 'ScienceDay': $EvName =  'Science Day/Open Day'; break;
					case 'SummerCamp': $EvName =  'Summer Science Camp'; break; 
				  	case 'TeachersPgm': $EvName =  'Teachers Training Program'; break; 
			 }
			

			$RegSDT = strtotime($RegStartMonth."/".$RegStartDay."/".$RegStartYear); $RegStartDate = date('Y-m-d',$RegSDT); //echo $RegStartDate."<br>";
			$RegLDT = strtotime($RegLastMonth."/".$RegLastDay."/".$RegLastYear); $RegLastDate = date('Y-m-d',$RegLDT); //echo $RegLastDate;
			$EveSDT = strtotime($BatchStartMonth."/".$BatchStartDay."/".$BatchStartYear); $BatchStartDate = date('Y-m-d',$EveSDT); //echo $BatchStartDate;
			$EveLDT = strtotime($BatchEndMonth."/".$BatchEndDay."/".$BatchEndYear); $BatchEndDate = date('Y-m-d',$EveLDT); //echo $BatchEndDate;

			
			if($EventType == "LPF" || $EventType == "ScienceDay")
			 {
			    $RegStartDate = "0000-00-00"; $RegLastDate = "0000-00-00"; $EventFees = "-"; 
			 }

			if($RegStartDate == "1970-01-01") { $RegStartDate= "0000-00-00"; }
			if($RegLastDate == "1970-01-01") { $RegLastDate= "0000-00-00"; }
			if($BatchEndDate == "1970-01-01") { $BatchEndDate= "0000-00-00"; }

			if($EventType == "Lecture" || $EventType == "Demonstration" || $EventType == "CelebrationDay" || $EventType == "Other") 
			{
			      $EvName = $EventName; //echo $EventType; echo $EventName;
			}
			

			if($RegReqd=="No") { $RegStartDate= "0000-00-00"; $RegEndDate= "0000-00-00"; }		

			if (isset($EventType) && isset($EventDuration) &&  isset($EventEligibility) && isset($BatchStartDay))
				{
					
				?>

							
					<?
					$Fdate =  date("Y-m-d"); 
					$Tag = "0"; $ExtraInfo = "";
				
				  $query0 = "SELECT  `EventNo` FROM EventsInfo Order by EventNo";
				  $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
				  $tung0=mysql_affected_rows();

				  if($tung0 != 0)  { while ($r = mysql_fetch_array($result0))  {  $EventCnt = $r["EventNo"]; }	  $EventCnt++;		  } 
				  else  {   $EventCnt = "1";  }
				 
				 $uploadfile = $_SESSION["uploadfile"];
				 //echo $uploadfile;
				 
				 if(move_uploaded_file($_FILES['Event_PDF']['tmp_name'], $uploadfile)) 
				   {
						chmod($uploadfile, 0644);
						//echo "The file ".  basename( $_FILES['uploadedfile']['name'])." has been uploaded";
						$_SESSION['EventFile'] = "Up"; 
						$_SESSION['EventFLFile'] = $filename; 			
					}
				  else  {  $errors['EventFL'] = "There was an error uploading the file, please try again!. File size must limit to 100kb."; } 


				  if ( $_SESSION["FileUp"] == 0 ) { $uploadfile = ""; }
				  
				  
				  $query0 = "SELECT  `EventNo` FROM EventsInfo Order by EventNo";
				  $result0 = mysql_db_query("SciPark", $query0) or die ("could not query" . mysql_error());
				  $tung0=mysql_affected_rows();

				  if($tung0 != 0)  { while ($r = mysql_fetch_array($result0))  {  $EventCnt = $r["EventNo"]; }	  $EventCnt++;		  } 
				  else  {   $EventCnt = "1";  }
				

				 $query = "INSERT INTO EventsInfo VALUES ('$EventCnt','$EventType','$EvName','$TopicName','$SpeakerName','$EventDuration','$EventEligibility','$EventBatchSize','$EventFees','$EventExtraInfo','$RegReqd','$RegStartDate','$RegLastDate','$BatchStartDate','$BatchEndDate','$uploadfile','N','$Fdate','','','A')"; //echo $query ;
				 $result = mysql_db_query("SciPark", $query) or die ("could not connect to database".mysql_error());
				 $tung1=mysql_affected_rows();
			 
				 if($tung1 != 0)
					{
					        $_SESSION["EventAddedNo"] =   $EventCnt;
  							header( 'Location: EventAdded.php' ) ;
					}
					else
					{ ?>
						   <br><br>	<p align="center"><i><b><font face="Verdana" color="#FF0000" size="5">Problem with adding New Event into the Database...</font></b></i></p>
					
					 <?}

				}
			else echo "Error found!!! Please fill the form correctly";
			 } //else close
		 }
		 else 
		 { 
		     $formValues = $_POST;	$formErrors = array();
			 DisplayForm($formValues, $formErrors);  
		 }//echo $_POST["a_addr1"]; }//}  ////////$_SESSIOM['H_HCBL'] = $H_HCBL; 
	 } 
	  else
		{
		  DisplayForm(null, null); //echo "here1"; //
		}
	
 
	  }
	  }
   else 
   {
     header( 'Location: Access_Denied.html' ) ;
    } 
?></pre>