Below is what I have this far. The function is not working. not sure why
<?
include ("../Connections/db.php");
// Database connection variables
function getEventDays($month, $year) {
$days = array();
$sql = mysql_query("SELECT DAY(event_date) AS day, COUNT(event_id) FROM calendar_events WHERE MONTH(event_date) = '$month' AND YEAR(event_date) = '$year' GROUP BY day");
if (mysql_num_rows($sql) > 0) {
while ($row = mysql_fetch_array($sql)) $days[] = $row['day'];
}
return $days;
}
function entryInfoQuery($date,$month,$monthname,$year) {
$query_result = mysql_query("SELECT * FROM calendar_events WHERE DAY(event_date)='$date' AND MONTH(event_date)='$month' AND YEAR(event_date)='$year'");
$num = mysql_numrows($query_result);
if ($num > 1) {
$i=0;
while ($i < $num) {
$event = mysql_result($query_result,$i,"event_title");
$time = mysql_result($query_result,$i,"event_time");
$body[$i] = "$event @ $time";
$i++;
}
$body_var = join("<br />",$body);
$title = "title=\"header=[$date $monthname $year] body=[$body_var]\"";
unset ($event_array); //CLEAR THE ARRAY FOR THE NEXT TIME THE FUNCTION IS CALLED
return $title;
}
elseif ($num == 1) {
$event = mysql_result($query_result,0,"title");
$time = mysql_result($query_result,0,"time");
return "title=\"header=[$date $monthname $year] body=[$event @ $time]\"";
}
else {
return "";
}
}
function drawCalendar($month, $year) {
// set variables we will need to help with layouts
$first = mktime(0,0,0,$month,1,$year); // timestamp for first of the month
$offset = date('w', $first); // what day of the week we start counting on
$daysInMonth = date('t', $first);
$monthName = date('F', $first);
$weekDays = array('Su', 'M', 'Tu', 'W', 'Th', 'F', 'Sa');
$eventDays = getEventDays($month, $year);
// Start drawing calendar
$out = "<table id=\"myCalendar\">\n";
$out .= "<tr><th colspan=\"7\">$monthName $year</th></tr>\n";
$out .= "<tr>\n";
foreach ($weekDays as $wd) $out .= "<td class=\"weekDays\">$wd</td>\n";
$i = 0;
for ($d = (1 - $offset); $d <= $daysInMonth; $d++) {
if ($i % 7 == 0) $out .= "<tr>\n"; // Start new row
if ($d < 1) $out .= "<td class=\"nonMonthDay\"> </td>\n";
else {
if (in_array($d, $eventDays)) {
$title = "";entryInfoQuery($d,($month-1),$prevMonth_name,$prevMonthYear);
$out .= "<td class=\"monthDay\">\n";
$out .= "<a href=\"?year=$year&month=$month&day=$d\">$d</a>\n<br />";
$out .= "$title";
$out .= "</td>\n";
} else $out .= "<td class=\"monthDay\">$d</td>\n";
}
++$i; // Increment position counter
if ($i % 7 == 0) $out .= "</tr>\n"; // End row on the 7th day
}
// Round out last row if we don't have a full week
if ($i % 7 != 0) {
for ($j = 0; $j < (7 - ($i % 7)); $j++) {
$out .= "<td class=\"nonMonthDay\"> </td>\n";
}
$out .= "</tr>\n";
}
$out .= "</table>\n";
return $out;
}
$year = isset($_GET['year']) ? $_GET['year'] : date('Y');
$month = isset($_GET['month']) ? $_GET['month'] : date('m');
echo drawCalendar($month, $year);
// Previous month link
$prevTS = strtotime("$year-$month-01 -1 month"); // timestamp of the first of last month
$pMax = date('t', $prevTS);
$pDay = ($day > $pMax) ? $pMax : $day;
list($y, $m) = explode('-', date('Y-m', $prevTS));
echo "<p>\n";
echo "<a href=\"?year=$year&month=$m&day=$pDay\">« Prev</a> |\n";
// Next month link
$nextTS = strtotime("$year-$month-01 +1 month");
$nMax = date('t', $nextTS);
$nDay = ($day > $nMax) ? $nMax : $day;
list($y, $m) = explode('-', date('Y-m', $nextTS));
echo "<a href=\"?year=$y&month=$m&day=$nDay\">Next »</a>\n";
echo "</p>\n";
// Calendar is done, let's list events for selected day
$sql = mysql_query("SELECT * FROM calendar_events WHERE event_date = '$year-$month-$day'");
if (mysql_num_rows($sql) > 0) {
while ($e = mysql_fetch_array($sql)) {
echo "<p>$e[event_title]</p>\n";
}
} else {
echo "<p>No events today</p>\n";
}
?>