Page 1 of 1

adding calendar data

Posted: Fri Jan 16, 2004 11:52 am
by bluesman333
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>"; 

?> 

?>

Posted: Fri Jan 16, 2004 4:33 pm
by mwong
I really don't understand your while and for statements. What are you trying to loop?