Anonymous

<?php
	include('ConnectionFile.php');

	if($_REQUEST['Submit']) {
	
		$Day = date("l");
		$Month=	date("F");
		$Year = date("Y");
		$SubmittedOn = $Day .'-'. $Month .'-'. $Year;
		
			
		$sql = "INSERT INTO Calendar (ShortTask, Task, Month, Day, Year,  Importance, SubmittedOn)
			VALUES ('".$_REQUEST['ShortTask']."', '".$_REQUEST['Task']."','".$_REQUEST['Month']."',
			'".$_REQUEST['Day']."', '".$_REQUEST['Year']."', '". $_REQUEST['Importance']."',
			'$SubmittedOn')";
		mysql_query($sql) OR die("An error has occured ". mysql_error());
	
		header("location: ./Calendar.php");
	}

        if($_REQUEST['Remove']) {
                $sql = "DELETE FROM Calendar WHERE TaskID = '".$_REQUEST['Remove']."'";
                mysql_query($sql);
        }


?>


<html>
<head>

<script type="javascript">

function Hi_Light(row) {
	row.style.backgroundColor='#CC9999';

}

</script>


<title>Calendar</title>
</head>
<body>
<form action="Calendar.php" method="post">
<input type="button" value="Add Event" onclick="document.getElementById('AddEventMenu').style.display='block'"/>


<center>
<table border="1" style="width:900px">


	<tr>
	<td align="center" colspan="6"><b> Calendar </b></td>
	</tr>
	<tr>
	<b>
	<td>Importance</td>
	<td>Task Name</td>
	<td>Task</td>
	<td>Submited On</td>
	<td>Complete By</td>
	<td>Remove</td>
	</tr>
	</b>
	<?php
	
		$sql = "SELECT * From Calendar";
		$result = mysql_query($sql);
		
		while ($row = mysql_fetch_assoc($result)) {
			echo '<tr onmouseover="this.style.backgroundColor=\'#CC9999\';" onmouseout = "this.style.backgroundColor=\'#FFFFFF\';"> ';
			
			if($row['Importance'] == 1) {
				$color = '#FF0000';
				}
			else if($row['Importance'] == 2) {
				$color= '#FFFF00';
				}
			else if($row['Importance'] == 3) {
				$color = '#00FF00';
				}
			else {
				$color = '#990000';
				}
			
			echo "<td style=\"background-color:$color;\">";
			echo '</td>';
			echo '<td> '.$row['ShortTask'].'</td>';
			echo '<td> '.$row['Task'].'</td>';
			echo '<td> '.$row['SubmittedOn'].'</td>';
			echo '<td> '.$row['Day'].'-'.$row['Month'].'-'.$row[Year].'</td>';
			echo '<td> <input type="button" value="Remove" onclick="window.location=\'Calendar.php?Remove='.$row['TaskID'].'\'"></td>';
			echo '</tr>';
		}



	?>



</table>

<p />

<div style="display:none;" id="AddEventMenu">


<!-- This is the add event code --!>

<table border="3">
	<tr>
	<td colspan="2" align="center"><b>Add Event</b></td>
	</tr>
	<tr>
	<td><b>Task Name</b></td>
	<td><input type="text" name="ShortTask"/></td>
	</tr>
	<tr>
	<td><b>Task</b></td>
	<td><textarea cols="40" rows="10" name="Task"></textarea></td>
	</tr>
	<tr>
	<td><b>Importance</b></td>
	<td><select name="Importance">
		<option value="None"></option>
		<option value="1">High</option>
		<option value="2">Medium</option>
		<option value="3">Low</option>
	</select></td>
	</tr>
	<tr>
	<td><b>Complete By</b></td>
	<td><select name= "Month">
		<option value="None"></option>
		<option value="Jan">Jan</option>
		<option value="Feb">Feb</option>
		<option value="Mar">Mar</option>
		<option value="May">May</option> 
		<option value="Jun">Jun</option>
		<option value="Jul">Jul</option>
		<option value="Aug">Aug</option>
		<option value="Sep">Sep</option>
		<option value="Oct">Oct</option>
		<option value="Nov">Nov</option>
		<option value="Dec">Dec</option>
		</select>
		<select name="Day"> 
			<option value="None"></option>
			<?php
			
				for($x=1; $x<32; $x++) {
					echo '<option value="'.$x.'">'.$x.'</option>';
					}
				echo "</select>";
				
				echo '<select name="Year">';
				echo '<option value="None"></option>';
				
				for($x=2007; $x < 2010; $x++) {
					echo '<option value="'.$x.'">'.$x.'</option>';
				}	
				echo '</select>';	
		?>	
					
	</tr>
	<tr>
	<td><b>Today's Date is: </b></td>
	<?php
		echo '<td>'.date("l") .'-'.date("F").'-'.date("Y").'</td>';
	?>
	</tr>
	<tr>
	<td align="center" colspan="2"><input type="submit" value="Add Task" name="Submit"/>
		<input type="button" value="cancel" onclick="document.getElementById('AddEventMenu').style.display='none'"/></td>
	</tr>

</table>
</div>
</form>
</body>
</html>