Royal_Son

<?php$mysqli = mysqli_connect("localhost", "joeuser", "somepass", "testDB");define("ADAY", (60*60*24));if ((!isset($_POST["month"])) || (!isset($_POST["year"]))) {	$nowArray = getdate();	$month = $nowArray["mon"];	$year = $nowArray["year"];} else {	$month = $_POST["month"];	$year = $_POST["year"];}$start = mktime (12,0,0,$month,1,$year);$firstDayArray = getdate($start);?><html><head><title><?php echo "Calendar:".$firstDayArray["month"]."".$firstDayArray["year"]; ?></title><head><script type="text/javascript">function eventWindow(url);	event_popupWin = window.open(url, 'event',	'resizeable=yes,scrollbars=yes,toolbar=no,width=400,height=400');	event_popupWin.opener = self;}</script><body><h1>Select a Month/Year Combination</h1><form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>"><select name ="month"><?php$months = Array("January", "February", "March", "April", "May","June", "July", "August","September", "October", "November", "December");for ($x=1; $x <= count($months); $x++) {	echo "<option value=\"$x\"";	if ($x == $month) {		echo " selected";	}	echo ">".$months[$x-1]."</option>";}?></select><select name="year"><?phpfor ($x=$year-1; $x<=($year+1); $x++) {	echo "<option";	if ($x == $year) {		echo " selected";	}	echo ">$x</option>";}?></select><input type="submit" name="submit" value="Go!"></form><br/><?php$days = Array("Sun","Mon","Tue","Wed","Thu","Fri","Sat");echo "<table border=\"1\" cellpadding=\"5\"><tr>\n";foreach ($days as $day) {	echo "<td style=\"background-color: #CCCCCC;	text-align: center; width: 14%\"><strong>$day</strong></td>\n";}for ($count=0; $count < (6*7); $count++) {	$dayArray = getDate($start);	if (($count % 7) == 0) {		if ($dayArray["mon"] != $month) {			break;		} else {			echo "</tr><tr>\n";		}	}	if ($count < $firstDayArray["wday"] || $dayArray["mon"] !=$month) {		echo "<td>&nbsp;</td>\n";	} else {		$chkEvent_sql = "SELECT event_title FROM calendar_events WHERE						 month(event_start) = '".month."' AND						 dayofmonth(event_start) = '".$dayArray["mday"]."'						 AND year(event_start) = '".$year."'						 ORDER BY event_start";		$chkEvent_res = mysqli_query($mysqli, $chkEvent_sql)						or die(mysqli_error($mysqli));				if (mysqli_num_rows($chkEvent_res) > 0) {			$event_title = "<br/>";			while ($ev = mysqli_fetch_array($chkEvent_res)) {				$event_title = stripslashes($ev["event_title"])."<br/>";			}			mysqli_free_result($chkEvent_res);		} else {			$event_title = "";		}		echo "<td valign=\"top\"><a href=\"javascript:eventWindow('event.php?		m=".$month."&d=".$dayArray["mday"]."&y=$year');\">".$dayArray["mday"].		"</a><br/>".$event_title."</td>\n";		unset($event_title);		$start += ADAY;	}}echo "</tr></table>";mysqli_close($mysqli);?></body></html>