. */ /** * 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 */ ?>
0){ $blank = $blank-1; $days_before = $days_monthbefore-$blank; echo ''; //'.$days_before.''; $day_count++; } $sqlToday = date("Y-m-d", mktime(0, 0, 0, $monthNum, $today, $year)); $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 = date("Y-m-d", mktime(0, 0, 0, $monthNum, $day_num, $year)); //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; } } } 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; } ?>