Calendar help

mattastic

Hi,

I have the attached code but I would like to modify it slightly so if any events occur on each day, they are hightlighted.

Could I create the query as a function?

Thankyou

<html>
<head>
<title>PHP Calendar</title>
<style type="text/css">
<!--
.table.calendar {border: 1px solid #000000; border-collapse: collapse; color: #000000; background: #FFFFFF; }
.td.today { border: 1px solid white; color: #000000; background: #EFEFEF; font-weight: bold;}
.td.monthdays {border: 1px solid #434470; color: #000000; background: #FFFFFFF; }
.td.nonmonthdays { border: 1px solid white; color: #000000; background: #EFEFEF;}
-->
</style>
<body>

<?php
error_reporting('0');
ini_set('display_errors', '0');
// Gather variables from
// user input and break them
// down for usage in our script

if(!isset($_REQUEST['date'])){
   $date = mktime(0,0,0,date('m'), date('d'), date('Y'));
} else {
   $date = $_REQUEST['date'];
}

$day = date('d', $date);
$month = date('m', $date);
$year = date('Y', $date);

// Get the first day of the month
$month_start = mktime(0,0,0,$month, 1, $year);

// Get friendly month name
$month_name = date('M', $month_start);

// Figure out which day of the week
// the month starts on.
$month_start_day = date('D', $month_start);

switch($month_start_day){
    case "Sun": $offset = 0; break;
    case "Mon": $offset = 1; break;
    case "Tue": $offset = 2; break;
    case "Wed": $offset = 3; break;
    case "Thu": $offset = 4; break;
    case "Fri": $offset = 5; break;
    case "Sat": $offset = 6; break;
}

// determine how many days are in the last month.
if($month == 1){
   $num_days_last = cal_days_in_month(0, 12, ($year -1));
} else {
   $num_days_last = cal_days_in_month(0, ($month -1), $year);
}
// determine how many days are in the current month.
$num_days_current = cal_days_in_month(0, $month, $year);

// Build an array for the current days
// in the month
for($i = 1; $i <= $num_days_current; $i++){
    $num_days_array[] = $i;
}

// Build an array for the number of days
// in last month
for($i = 1; $i <= $num_days_last; $i++){
    $num_days_last_array[] = $i;
}

// If the $offset from the starting day of the
// week happens to be Sunday, $offset would be 0,
// so don't need an offset correction.

if($offset > 0){
    $offset_correction = array_slice($num_days_last_array, -$offset, $offset);
    $new_count = array_merge($offset_correction, $num_days_array);
    $offset_count = count($offset_correction);
}

// The else statement is to prevent building the $offset array.
else {
    $offset_count = 0;
    $new_count = $num_days_array;
}

// count how many days we have with the two
// previous arrays merged together
$current_num = count($new_count);

// Since we will have 5 HTML table rows (TR)
// with 7 table data entries (TD)
// we need to fill in 35 TDs
// so, we will have to figure out
// how many days to appened to the end
// of the final array to make it 35 days.


if($current_num > 35){
   $num_weeks = 6;
   $outset = (42 - $current_num);
} elseif($current_num < 35){
   $num_weeks = 5;
   $outset = (35 - $current_num);
}
if($current_num == 35){
   $num_weeks = 5;
   $outset = 0;
}
// Outset Correction
for($i = 1; $i <= $outset; $i++){
   $new_count[] = $i;
}

// Now let's "chunk" the $all_days array
// into weeks. Each week has 7 days
// so we will array_chunk it into 7 days.
$weeks = array_chunk($new_count, 7);


// Build Previous and Next Links
$previous_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=";
if($month == 1){
   $previous_link .= mktime(0,0,0,12,$day,($year -1));
} else {
   $previous_link .= mktime(0,0,0,($month -1),$day,$year);
}
$previous_link .= "\"><< Prev</a>";

$next_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=";
if($month == 12){
   $next_link .= mktime(0,0,0,1,$day,($year + 1));
} else {
   $next_link .= mktime(0,0,0,($month +1),$day,$year);
}
$next_link .= "\">Next >></a>";

// Build the heading portion of the calendar table
echo "<table border=\"1\" cellpadding=\"2\" cellspacing=\"0\" width=\"300\" class=\"calendar\">\n".
     "<tr>\n".
     "<td colspan=\"7\">\n".
     "<table align=\"center\">\n".
     "<tr>\n".
     "<td colspan=\"2\" width=\"75\" align=\"left\">$previous_link</td>\n".
     "<td colspan=\"3\" width=\"150\" align=\"center\">$month_name $year</td>\n".
     "<td colspan=\"2\" width=\"75\" align=\"right\">$next_link</td>\n".
     "</tr>\n".
     "</table>\n".
     "</td>\n".
     "<tr>\n".
     "<td>S</td><td>M</td><td>T</td><td>W</td><td>T</td><td>F</td><td>S</td>\n".
     "</tr>\n";

// Now we break each key of the array 
// into a week and create a new table row for each
// week with the days of that week in the table data

$i = 0;
foreach($weeks AS $week){
       echo "<tr>\n";
       foreach($week as $d){
         if($i < $offset_count){
             $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month -1,$d,$year)."\">$d</a>";
             echo "<td class=\"nonmonthdays\">$day_link</td>\n";
         }
         if(($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)){
            $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month,$d,$year)."\">$d</a>";
           if($date == mktime(0,0,0,$month,$d,$year)){
               echo "<td class=\"today\">$d</td>\n";
           } else {
               echo "<td class=\"days\">$day_link</td>\n";
           }
        } elseif(($outset > 0)) {
            if(($i >= ($num_weeks * 7) - $outset)){
               $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month +1,$d,$year)."\">$d</a>";
               echo "<td class=\"nonmonthdays\">$day_link</td>\n";
           }
        }
        $i++;
      }
      echo "</tr>\n";   

}

// Close out your table and that's it!
echo '<tr><td colspan="7" class="days"> </td></tr>';
echo '</table>';
?>
</body>
</html>

Installer

I got it to highlight "event" days, just for testing, like this:

I added these two styles:

.td.eventtoday { border: 1px solid white; color: #000000; background: #7fffd4; font-weight: bold;} 
.td.eventmonthdays {border: 1px solid #434470; color: #000000; background: #00FFFF; }

I changed/added this code:

$event_array = event_array(); 
foreach($weeks AS $week){

and:

         if(($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)){

        if (array_key_exists($d, $event_array)) {
            $today_class = 'eventtoday';
            $days_class = 'eventmonthdays';
        } else {
            $today_class = 'today';
            $days_class = 'monthdays';
        }

        $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month,$d,$year)."\">$d</a>"; 
       if($date == mktime(0,0,0,$month,$d,$year)){
           echo "<td class=\"" . $today_class . "\">$d</td>\n"; 
       } else { 
           echo "<td class=\"" . $days_class . "\">$day_link</td>\n"; 
       }

and added this function

function event_array()
{
    $events = array(9 => 'event', 13 => 'event', 24 => 'event');
    return $events;
}

This only sort of "proof of concept" stuff, but maybe it can get you started. The "event_array()" function would have to be adapted to your database, of course.

BTW, you use a CSS class called "days". Did you mean "monthdays"? And a couple of your color hex numbers have seven characters.

mattastic

thanks for this.

Could you you tell me where I put these code snippets in my script?

Thankyou

Installer

I left parts of your code in there so you could tell where they went. The style lines go in your style block. The first PHP goes right after "$i = 0" and right before "foreach($weeks AS $week){". The next one goes right after the line that starts "if(($i >= $offset_count)". The last one is a function. You can put it about anywhere; at the very bottom of your code will work fine.

Installer

Here's the entire script, with the changes in place. Run it as is first to see how it works.

<html> 
<head> 
<title>PHP Calendar</title> 
<style type="text/css"> 
<!-- 
.table.calendar {border: 1px solid #000000; border-collapse: collapse; color: #000000; background: #FFFFFF; } 
.td.today { border: 1px solid white; color: #000000; background: #EFEFEF; font-weight: bold;} 
.td.monthdays {border: 1px solid #434470; color: #000000; background: #FFFFFFF; } 
.td.nonmonthdays { border: 1px solid white; color: #000000; background: #EFEFEF;} 
.td.eventtoday { border: 1px solid white; color: #000000; background: #7fffd4; font-weight: bold;} 
.td.eventmonthdays {border: 1px solid #434470; color: #000000; background
--> 
</style> 
<body> 

<?php 
error_reporting('0'); 
ini_set('display_errors', '0'); 
// Gather variables from 
// user input and break them 
// down for usage in our script 

if(!isset($_REQUEST['date'])){ 
   $date = mktime(0,0,0,date('m'), date('d'), date('Y')); 
} else { 
   $date = $_REQUEST['date']; 
} 

$day = date('d', $date); 
$month = date('m', $date); 
$year = date('Y', $date); 

// Get the first day of the month 
$month_start = mktime(0,0,0,$month, 1, $year); 

// Get friendly month name 
$month_name = date('M', $month_start); 

// Figure out which day of the week 
// the month starts on. 
$month_start_day = date('D', $month_start); 

switch($month_start_day){ 
    case "Sun": $offset = 0; break; 
    case "Mon": $offset = 1; break; 
    case "Tue": $offset = 2; break; 
    case "Wed": $offset = 3; break; 
    case "Thu": $offset = 4; break; 
    case "Fri": $offset = 5; break; 
    case "Sat": $offset = 6; break; 
} 

// determine how many days are in the last month. 
if($month == 1){ 
   $num_days_last = cal_days_in_month(0, 12, ($year -1)); 
} else { 
   $num_days_last = cal_days_in_month(0, ($month -1), $year); 
} 
// determine how many days are in the current month. 
$num_days_current = cal_days_in_month(0, $month, $year); 

// Build an array for the current days 
// in the month 
for($i = 1; $i <= $num_days_current; $i++){ 
    $num_days_array[] = $i; 
} 

// Build an array for the number of days 
// in last month 
for($i = 1; $i <= $num_days_last; $i++){ 
    $num_days_last_array[] = $i; 
} 

// If the $offset from the starting day of the 
// week happens to be Sunday, $offset would be 0, 
// so don't need an offset correction. 

if($offset > 0){ 
    $offset_correction = array_slice($num_days_last_array, -$offset, $offset); 
    $new_count = array_merge($offset_correction, $num_days_array); 
    $offset_count = count($offset_correction); 
} 

// The else statement is to prevent building the $offset array. 
else { 
    $offset_count = 0; 
    $new_count = $num_days_array; 
} 

// count how many days we have with the two 
// previous arrays merged together 
$current_num = count($new_count); 

// Since we will have 5 HTML table rows (TR) 
// with 7 table data entries (TD) 
// we need to fill in 35 TDs 
// so, we will have to figure out 
// how many days to appened to the end 
// of the final array to make it 35 days. 


if($current_num > 35){ 
   $num_weeks = 6; 
   $outset = (42 - $current_num); 
} elseif($current_num < 35){ 
   $num_weeks = 5; 
   $outset = (35 - $current_num); 
} 
if($current_num == 35){ 
   $num_weeks = 5; 
   $outset = 0; 
} 
// Outset Correction 
for($i = 1; $i <= $outset; $i++){ 
   $new_count[] = $i; 
} 

// Now let's "chunk" the $all_days array 
// into weeks. Each week has 7 days 
// so we will array_chunk it into 7 days. 
$weeks = array_chunk($new_count, 7); 


// Build Previous and Next Links 
$previous_link = "<a href=\"".$_SERVER['PHP_SELF']."?date="; 
if($month == 1){ 
   $previous_link .= mktime(0,0,0,12,$day,($year -1)); 
} else { 
   $previous_link .= mktime(0,0,0,($month -1),$day,$year); 
} 
$previous_link .= "\"><< Prev</a>"; 

$next_link = "<a href=\"".$_SERVER['PHP_SELF']."?date="; 
if($month == 12){ 
   $next_link .= mktime(0,0,0,1,$day,($year + 1)); 
} else { 
   $next_link .= mktime(0,0,0,($month +1),$day,$year); 
} 
$next_link .= "\">Next >></a>"; 

// Build the heading portion of the calendar table 
echo "<table border=\"1\" cellpadding=\"2\" cellspacing=\"0\" width=\"300\" class=\"calendar\">\n". 
     "<tr>\n". 
     "<td colspan=\"7\">\n". 
     "<table align=\"center\">\n". 
     "<tr>\n". 
     "<td colspan=\"2\" width=\"75\" align=\"left\">$previous_link</td>\n". 
     "<td colspan=\"3\" width=\"150\" align=\"center\">$month_name $year</td>\n". 
     "<td colspan=\"2\" width=\"75\" align=\"right\">$next_link</td>\n". 
     "</tr>\n". 
     "</table>\n". 
     "</td>\n". 
     "<tr>\n". 
     "<td>S</td><td>M</td><td>T</td><td>W</td><td>T</td><td>F</td><td>S</td>\n". 
     "</tr>\n"; 

// Now we break each key of the array 
// into a week and create a new table row for each 
// week with the days of that week in the table data 

$i = 0; 
$event_array = event_array(); 
foreach($weeks AS $week){ 
       echo "<tr>\n"; 
       foreach($week as $d){ 
         if($i < $offset_count){ 
             $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month -1,$d,$year)."\">$d</a>"; 
             echo "<td class=\"nonmonthdays\">$day_link</td>\n"; 
         } 
        if(($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)){ 

            if (array_key_exists($d, $event_array)) { 
                $today_class = 'eventtoday'; 
                $days_class = 'eventmonthdays'; 
            } else { 
                $today_class = 'today'; 
                $days_class = 'monthdays'; 
            } 

            $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month,$d,$year)."\">$d</a>"; 
           if($date == mktime(0,0,0,$month,$d,$year)){ 
               echo "<td class=\"" . $today_class . "\">$d</td>\n"; 
           } else { 
               echo "<td class=\"" . $days_class . "\">$day_link</td>\n"; 
           } 

     } elseif(($outset > 0)) { 
        if(($i >= ($num_weeks * 7) - $outset)){ 
           $day_link = "<a href=\"".$_SERVER['PHP_SELF']."?date=".mktime(0,0,0,$month +1,$d,$year)."\">$d</a>"; 
           echo "<td class=\"nonmonthdays\">$day_link</td>\n"; 
       } 
    } 
    $i++; 
  } 
  echo "</tr>\n";    
} 

// Close out your table and that's it! 
echo '<tr><td colspan="7" class="days"> </td></tr>'; 
echo '</table>';

function event_array() 
{ 
    $events = array(9 => 'event', 13 => 'event', 24 => 'event'); 
    return $events; 
} 

?> 
</body> 
</html>

Edit: Except now it's not highlighting. I must have made another change that I forgot about, and I'd deleted the code from my editor. Give me a little while, and when I get back I'll help you with it some more. Or meanwhile someone else will.

mattastic

Edit: thanks for all your help, very much appreciated.

mattastic

double post

Installer

Here's the working script. The only other changes are replacing the offset-calculating block with $offset = date('w', $month_start);, and a bunch of reformatting. It didn't work when I posted it above because I screwed up the copy and paste.

<html> 
<head> 
<title>PHP Calendar</title> 
<style type="text/css"> 
<!-- 
.table.calendar {border: 1px solid #000000; border-collapse: collapse; color: #000000; background: #FFFFFF;} 
.td.today {border: 1px solid white; color: #000000; background: #EFEFEF; font-weight: bold;} 
.td.monthdays {border: 1px solid #434470; color: #000000; background: #FFFFFF;} 
.td.nonmonthdays {border: 1px solid white; color: #000000; background: #EFEFEF;} 
.td.eventtoday {border: 1px solid white; color: #000000; background: #7fffd4; font-weight: bold;} 
.td.eventmonthdays {border: 1px solid #434470; color: #000000; background: #00ffff}
--> 
</style> 
<body> 

<?php 
error_reporting('0'); 
//ini_set('display_errors', '0'); 

if (!isset($_REQUEST['date'])){ 
    $date = mktime(0, 0, 0, date('m'), date('d'), date('Y')); 
} else { 
    $date = $_REQUEST['date']; 
} 

$day   = date('d', $date); 
$month = date('m', $date); 
$year  = date('Y', $date);

$month_start = mktime(12, 0, 0, $month, 1, $year); 
$month_name = date('M', $month_start); 
$month_start_day = date('D', $month_start); 
$offset = date('w', $month_start);

if ($month == 1) { 
    $num_days_last = cal_days_in_month(0, 12, ($year - 1)); 
} else { 
    $num_days_last = cal_days_in_month(0, ($month - 1), $year); 
}

$num_days_current = cal_days_in_month(0, $month, $year); 
for ($i = 1; $i <= $num_days_current; $i++) { 
    $num_days_array[] = $i; 
} 
for ($i = 1; $i <= $num_days_last; $i++) { 
    $num_days_last_array[] = $i; 
}

if ($offset > 0) { 
    $offset_correction = array_slice($num_days_last_array, -$offset, $offset); 
    $new_count = array_merge($offset_correction, $num_days_array); 
    $offset_count = count($offset_correction); 
} else { 
    $offset_count = 0; 
    $new_count = $num_days_array; 
}

$current_num = count($new_count); 
if ($current_num > 35) { 
    $num_weeks = 6; 
    $outset = (42 - $current_num); 
} elseif ($current_num < 35) { 
    $num_weeks = 5; 
    $outset = (35 - $current_num); 
} 
if ($current_num == 35) { 
    $num_weeks = 5; 
    $outset = 0; 
} 
for ($i = 1; $i <= $outset; $i++) { 
    $new_count[] = $i; 
} 
$weeks = array_chunk($new_count, 7); 

$previous_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date='; 
if ($month == 1) { 
    $previous_link .= mktime(0, 0, 0, 12, $day, ($year - 1)); 
} else { 
    $previous_link .= mktime(0, 0, 0, ($month - 1), $day, $year); 
} 
$previous_link .= '"><< Prev</a>'; 

$next_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date='; 
if ($month == 12) { 
    $next_link .= mktime(0, 0, 0, 1, $day, ($year + 1)); 
} else { 
    $next_link .= mktime(0, 0, 0, ($month + 1), $day, $year); 
} 
$next_link .= '">Next >></a>'; 

echo '<table border="1" cellpadding="2" cellspacing="0" width="300" class="calendar">' . "\n" . 
     '<tr>' . "\n" . 
     '<td colspan="7">' . "\n" . 
     '<table align="center">' . "\n" .
     '<tr>' . "\n" . 
     '<td colspan="2" width="75" align="left">' . $previous_link . '</td>' . "\n" . 
     '<td colspan="3" width="150" align="center">' . $month_name . $year . '</td>' . "\n" . 
     '<td colspan="2" width="75" align="right">' . $next_link . '</td>' . "\n" . 
     '</tr>' . "\n" .
     '</table>' . "\n" . 
     '</td>' . "\n" . 
     '<tr>' . "\n" . 
     '<td>S</td><td>M</td><td>T</td><td>W</td><td>T</td><td>F</td><td>S</td>' . "\n" . 
     '</tr>' . "\n" .

$i = 0; 
$event_array = event_array(); 
foreach($weeks AS $week) { 
    echo "<tr>\n"; 
    foreach ($week as $d) { 
        if ($i < $offset_count) { 
            $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month - 1, $d, $year) . '">' . $d . '</a>'; 
            echo '<td class="nonmonthdays">' . $day_link . '</td>' . "\n"; 
        } 
        if (($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)) { 

        if (array_key_exists($d, $event_array)) { 
            $today_class = 'eventtoday'; 
            $days_class = 'eventmonthdays'; 
        } else { 
            $today_class = 'today'; 
            $days_class = 'monthdays'; 
        } 

        $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month, $d, $year) . '">' . $d . '</a>'; 
        if ($date == mktime(0, 0, 0, $month, $d, $year)) { 
            echo '<td class="' . $today_class . '">' . $d . '</td>'. "\n"; 
        } else { 
            echo '<td class="' . $days_class . '">' . $day_link . '</td>' . "\n"; 
        } 

    } elseif (($outset > 0)) { 
        if (($i >= ($num_weeks * 7) - $outset)) { 
            $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month + 1, $d, $year) . '">' . $d . '</a>'; 
            echo '<td class="nonmonthdays">' . $day_link . '</td>' . "\n"; 
        } 
    } 
    $i++; 
} 
echo '</tr>' . "\n";    
} 

echo '<tr><td colspan="7" class="days">&nbsp;</td></tr>'; 
echo '</table>';

function event_array() 
{ 
    $events = array(9 => 'event', 13 => 'event', 24 => 'event', 25 => 'event'); 
    return $events; 
} 

?> 
</body> 
</html>

mattastic

Thanks again thats great.

I have a db of event startdates and enddates, could I now query these, and highlight the appropriate days?

Then I would have my own little year planner.

I have my query code below:

<?php
$host = "localhost";
$user = "root";
$pass = "";
$dbname = "test";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);



$currentdate = "2006-04-12";
// check for events
// check for events
$sql = "SELECT * FROM date where '$currentdate' >= eventdate AND '$currentdate' <= enddate";


 $result = mysql_query($sql);
if (!$result) {
   die('Invalid query: ' . mysql_error());
}



if($result){

// now check for rows

$num_rows = mysql_num_rows($result);

if ($num_rows > 0){
$event = 1;
}
else{
$event = 0;
}

}
else{

'Could not perform database query.<br>';

}
?>

Installer

Yeah, it shouldn't be too hard to do. You'd want to query for events for the whole month, rather than one day, and put the results into "$event_array". Then, as the calendar is built, construct each day to match the db format, and check the array for that date.

I'll see what else I can come up to suggest. What is "enddate" and what other fields do you have in the table?

mattastic

Hi Installer and thanks again for your reply.

enddate is the day the event ends, as a date field, startdate is the day the event starts, as is a date field too. The other field I have is eventtitle, which is a varchar.

If there was an event that lasted a week in total, i wouldl ike that week to be highlighted, if there was an event that ended and started on the same day, I would like to just highlight that day.

I managed to get something basic setup, that would highlight the appropriate days, but the offset days messed me up.

I have all my admin pages in place, I just need to get the calendar page setup, that hightlights all the events, its a little too advanced for me.

Installer

I've been wondering about those offset days myself.

Given all the calendar scripts out there, this might be considered as reinventing the wheel, but that, too, can be fun and a good way to learn. So hopefully we'll both get something out of this.

I'll post some more code when (if) I get it working. Should be later today.

mattastic

Hi Installer,

Thanks very much.

I've seen quite a few calendar scripts, but like you said I would rather start from scratch and see how it all comes together.

mattastic

I've managed to query the db and insert the values into the events array

//get current month
$month_start = date('Y/m/d',mktime(12, 0, 0, $month, 1, $year));
$month_end = date('Y/m/d',mktime(12, 0, 0, $month + 1, - 1, $year));

 // query for events
$sql = "
SELECT *
FROM date
WHERE eventdate >= '$month_start'
AND enddate <= '$month_end'";

$result = mysql_query($sql);
if (!$result) {
   die('Invalid query: ' . mysql_error());
}

while ($row = mysql_fetch_assoc($result)) {
$events = array( 'eventtitle'=>$row["title"] );
$events['startdate'] = $row["eventdate"];
$events['enddate'] = $row["enddate"];
}

foreach ($events as $key => $value)
 echo $key.'=>'.$value.'<br />';

mattastic

Hi,

Could anyone help me with the code below?

I have this nearly working, but I can only get the last element in my event array to be highlighted on the calendar.

Can anbody help, Im very stuck.

Thankyou

<html>
<head>
<title>PHP Calendar</title>
<style type="text/css">
<!--
.calendar {border: 1px solid #000000; border-collapse: collapse; color: #000000; background: #FFFFFF;}
.today {border: 1px solid white; color: #000000; background: #EFEFEF; font-weight: bold;}
.monthdays {border: 1px solid #434470; color: #000000; background: #FFFFFF;}
.nonmonthdays {border: 1px solid white; color: #000000; background: #EFEFEF;}
.eventtoday {border: 1px solid white; color: #000000; background: #7fffd4; font-weight: bold;}
.eventmonthdays {border: 1px solid #434470; color: #000000; background: #00ffff}
-->
</style>
<body>

<?php

$host = "localhost";
$user = "root";
$pass = "";
$dbname = "test";

$connection = mysql_connect($host,$user,$pass) or die (mysql_errno().": ".mysql_error()."<BR>");
mysql_select_db($dbname);




error_reporting('0');
//ini_set('display_errors', '0');

if (!isset($_REQUEST['date'])){
    $date = mktime(0, 0, 0, date('m'), date('d'), date('Y'));
} else {
    $date = $_REQUEST['date'];
}

$day   = date('d', $date);
$month = date('m', $date);
$year  = date('Y', $date);

$month_start = mktime(12, 0, 0, $month, 1, $year);
$month_end = mktime(12, 0, 0, $month + 1, 1, $year);
$month_name = date('M', $month_start);
$month_start_day = date('D', $month_start);
$offset = date('w', $month_start);

if ($month == 1) {
    $num_days_last = cal_days_in_month(0, 12, ($year - 1));
} else {
    $num_days_last = cal_days_in_month(0, ($month - 1), $year);
}

$num_days_current = cal_days_in_month(0, $month, $year);
for ($i = 1; $i <= $num_days_current; $i++) {
    $num_days_array[] = $i;
}
for ($i = 1; $i <= $num_days_last; $i++) {
    $num_days_last_array[] = $i;
}

if ($offset > 0) {
    $offset_correction = array_slice($num_days_last_array, -$offset, $offset);
    $new_count = array_merge($offset_correction, $num_days_array);
    $offset_count = count($offset_correction);
} else {
    $offset_count = 0;
    $new_count = $num_days_array;
}

$current_num = count($new_count);
if ($current_num > 35) {
    $num_weeks = 6;
    $outset = (42 - $current_num);
} elseif ($current_num < 35) {
    $num_weeks = 5;
    $outset = (35 - $current_num);
}
if ($current_num == 35) {
    $num_weeks = 5;
    $outset = 0;
}
for ($i = 1; $i <= $outset; $i++) {
    $new_count[] = $i;
}
$weeks = array_chunk($new_count, 7);

$previous_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=';
if ($month == 1) {
    $previous_link .= mktime(0, 0, 0, 12, $day, ($year - 1));
} else {
    $previous_link .= mktime(0, 0, 0, ($month - 1), $day, $year);
}
$previous_link .= '"><< Prev</a>';

$next_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=';
if ($month == 12) {
    $next_link .= mktime(0, 0, 0, 1, $day, ($year + 1));
} else {
    $next_link .= mktime(0, 0, 0, ($month + 1), $day, $year);
}
$next_link .= '">Next >></a>';

// format month dates
$month_start = date('Y-m-d', $month_start);
$month_end = date('Y-m-d', $month_end);


 // query for events
$query = "
SELECT *
FROM date
WHERE startdate >= '$month_start'
AND enddate <= '$month_end'";
echo $query;




$result = mysql_query($query);
if(!$result) error_message(sql_error());

$i = 1;
while ($row = mysql_fetch_assoc($result)) {
//format sql dates in php date
$startdatevalues = explode("-", $row["startdate"]);
$startdate = mktime(0, 0, 0, $startdatevalues[1], $startdatevalues[2], $startdatevalues[0]);
$enddatevalues = explode("-", $row["enddate"]);
$enddate = mktime(0, 0, 0, $enddatevalues[1], $enddatevalues[2], $enddatevalues[0]);
//add to array
    $events['event'.$i]['title'] = $row['eventtitle'];
    $events['event'.$i]['startdate'] = $startdate;
    $events['event'.$i]['enddate'] = $enddate;
    $i++; 


}






echo '<table border="1" cellpadding="2" cellspacing="0" width="300" class="calendar">' . "\n" .
     '<tr>' . "\n" .
     '<td colspan="7">' . "\n" .
     '<table align="center">' . "\n" .
     '<tr>' . "\n" .
     '<td colspan="2" width="75" align="left">' . $previous_link . '</td>' . "\n" .
     '<td colspan="3" width="150" align="center">' . $month_name . $year . '</td>' . "\n" .
     '<td colspan="2" width="75" align="right">' . $next_link . '</td>' . "\n" .
     '</tr>' . "\n" .
     '</table>' . "\n" .
     '</td>' . "\n" .
     '<tr>' . "\n" .
     '<td>S</td><td>M</td><td>T</td><td>W</td><td>T</td><td>F</td><td>S</td>' . "\n" .
     '</tr>' . "\n" .

$i = 0;
foreach($weeks AS $week) {
    echo "<tr>\n";
    foreach ($week as $d) {
        if ($i < $offset_count) {
            $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month - 1, $d, $year) . '">' . $d . '</a>';
            echo '<td class="nonmonthdays">' . $day_link . '</td>' . "\n";
        }
        if (($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)) {

	$i = 1;
while (isset($events['event'.$i])) 
		{

	if (
	(date('d',$events['event'.$i]['startdate'])  < $d AND date('d',$events['event'.$i]['enddate'])  > $d )
	OR
	(date('d',$events['event'.$i]['startdate']) == $d
	OR
	date('d',$events['event'.$i]['enddate'])  == $d 
	))
	{
	    	$today_class = 'eventtoday';
            $days_class = 'eventmonthdays';
	}else{
	       $today_class = 'today';
            $days_class = 'monthdays';
	}
$i++;

	}





        $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month, $d, $year) . '">' . $d . '</a>';
        if ($date == mktime(0, 0, 0, $month, $d, $year)) {
            echo '<td class="' . $today_class . '">' . $d . '</td>'. "\n";
        } else {
            echo '<td class="' . $days_class . '">' . $day_link . '</td>' . "\n";
        }

    } elseif (($outset > 0)) {
        if (($i >= ($num_weeks * 7) - $outset)) {
            $day_link = '<a href="' . $_SERVER['PHP_SELF'] . '?date=' . mktime(0, 0, 0, $month + 1, $d, $year) . '">' . $d . '</a>';
            echo '<td class="nonmonthdays">' . $day_link . '</td>' . "\n";
        }
    }
    $i++;
}
echo '</tr>' . "\n";    
}

echo '<tr><td colspan="7" class="days">&nbsp;</td></tr>';
echo '</table>';







?>
</body>
</html>