adding calendar data
Posted: Fri Jan 16, 2004 11:52 am
The following code prints a calendar with each day being a link to a new window, where users can add events. My problem is, I can't figure out how to print events to the calendar. Where in the code would I put it?
Code: Select all
<?php
<?php
define("ADAY", (60*60*24));
if (!checkdate($_POST[month], 1, $_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><?php print "\n<SCRIPT LANGUAGE=JAVASCRIPT TYPE= "TEXT/JAVASCRIPT">"; ?>
<?php print "\nfunction newWindow() {\ncalinsertWindow=window.open('eventinsert.php','calinsertWin','width=350,height=350')\n}\n</SCRIPT>"; ?>
<?php print "\n<title>Calendar:".$firstDayArray['month']." ".$firstDayArray['year'] ?></title>
</head>
<body>
<form method="post" action="<?php print "$_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++) {
print "\t<option value="$x"";
print ($x == $month)?" SELECTED":"";
print ">".$months[$x-1]."\n";
}
?>
</select>
<select name="year">
<?php
for ($x=2003; $x<2010; $x++) {
print "\t<option";
print ($x == $year)?" SELECTED":"";
print ">$x\n";
}
?>
</select>
<input type="submit" value="Go!">
</form>
<br>
<?php
$days = Array("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", "Friday", "Saturday");
print "<table width="90%" height="100%" border="1" bordercolor="#666666">\n";
foreach ($days as $day) {
print "\t<td height="15" bgcolor="#3399FF"><b><center>$day</center></b></td>\n";
}
for ($count=0; $count < (6*7); $count++) {
$dayArray = getdate($start);
if (($count % 7) == 0) {
if ($dayArray['mon'] != $month) {
break;
} else {
print "</tr><tr>\n";
if ($count < $firstDayArray['wday'] || $dayArray['mon'] != $month) {
print "\t<td width="80"><br></td>\n";
} else {
print "\t<td width="80" align="left" valign="top"><a href= "javascript:newWindow()">".$dayArray['mday']."
</a>
$sql = ("SELECT title FROM calendar_mssgs WHERE d = $dayarray[mday]");
$result = mysql_query($sql, $conn);
$cal_data[] = mysql_fetch_array($result);
print $cal_data[3];
</td>\n";
$start += ADAY;
}
}
print "</tr></table>";
?>
?>