. */ /** * Note to anyone feeling the need to edit this file... * You MUST declare $db as global inside your functions in order access MySQL from here. */ /** * PrintCalendar() - prints the calendar with events */ function PrintCalendar(){ $date = time(); date_default_timezone_set("America/New_York"); //EASTERN TIME ZONE $day = date('d', $date); $today = date('j', $date); $month = date('m', $date); $monthNum = date('n', $date); $year = date('Y', $date); /* Accounts for the last couple days from the previous months */ $first_day = mktime(0,0,0,$monthNum, 1, $year); $title = date('F', $first_day); $day_of_week = date('D', $first_day); switch($day_of_week){ case "Sun": $blank = 0; break; case "Mon": $blank = 1; break; case "Tue": $blank = 2; break; case "Wed": $blank = 3; break; case "Thu": $blank = 4; break; case "Fri": $blank = 5; break; case "Sat": $blank = 6; break; } /* calculates the days in the current month */ $days_in_month = cal_days_in_month(0, $monthNum, $year); //makes sure that previous year is not year 0 if($monthNum == 1){ $previous_month = 12; $previous_year = $year-1; }else{ $previous_month = $monthNum-1; $previous_year = $year; } //makes sure the next year is not year 13 if($monthNum == 12){ $next_month = 1; $next_year = $year+1; }else{ $next_month = $monthNum+1; $next_year = $year; } ?>
0){ $blank = $blank-1; $days_before = $days_monthbefore-$blank; echo ''; //'.$days_before.''; $day_count++; } $sqlToday = $year.'-'.$monthNum.'-'.$today; $events = GetEventsOnInterval("{$year}-{$monthNum}-01","{$year}-{$monthNum}-{$days_in_month}"); //loop printing each day of the CURRENT month ONLY while($day_num <= $days_in_month){ if($day_count==1 || $day_count==7){ echo ''; $day_num++; $day_count++; if($day_count > 7){ echo ''; $day_count = 1; } } $days_after = 1; //loop for printing the days for the next month while($day_count > 1 && $day_count <=7){ echo ''; //'.$days_after.''; $days_after++; $day_count++; } ?>
    
SunMonTueWed ThuFriSat
'.$days_before.''; //weekends }else{ echo ''; //weekdays } $sqlDate = $year.'-'.$monthNum.'-'.$day_num; //old way NOT unix //checks to see if the current day has events $isEvent=false; foreach($events as $event){ if($event['date'] == $sqlDate){ $isEvent = true; if($event['date'] == $sqlToday){ $todaysEvents[] = $event; } } } /* global $db; $result = $db->Query("SELECT title,color,date,time FROM `bayonet_events` WHERE `date` = '$sqlDate' ORDER BY `date` DESC"); while(($row = $db->Fetch($result))!=false) { $isEvent = true; if($day_num == $today){ $todaysEvents[] = $row; } } */ if($day_num == $today && $isEvent==true){ echo '
'.$day_num.'
'; }else if($day_num == $today && $isEvent==false){ echo '
'.$day_num.'
'; }else if($day_num != $today && $isEvent==true){ echo '
'; echo $day_num; echo '
'; }else{ echo $day_num; } echo '
'.$days_after.'
0){ echo "

Today's Events

"; foreach($todaysEvents as $event){ $time = date("g:i a", strtotime($event['date']." ".$event['time'])); echo "   {$event['title']} @ {$time}
"; } } } function GetEventsOnInterval($start,$end){ global $db; $result = $db->Query("SELECT `event_id`, `title`, `color`, `date`, `time` FROM `bayonet_events` WHERE `date` BETWEEN '$start' AND '$end' ORDER BY `time` ASC"); $events = $db->Fetch($result); return $events; } ?>