Highlighting dates on a calendar

ciaranmg

I'm sure this has come up before but I tried the search and couldn't find an answer.

It's a fairly straightforward problem but I just can't get my head around it.

I have a calendar script that displays by month. I want to be able to highlight dates on that calendar based on records stored in my database.

My database table stores bookings: START_DATE, END_DATE, ID, etc.

Without running a query for every day of the month to check if that date is available or not how do I do what I need?

Any help is greatly appreciated.

LordShryku

Just run the query to select all dates for the month. Then load the dates in an array and use [man]in_array[/man] to check for highlighting.

ciaranmg

Thanks!

I knew I was missing something simple.

is there an easy way to populate the array with the dates. E.g.

A booking that starts at 9/9/2004 and ends at 9/16/2004 won't natively go into the array as 9/9, 9/10, 9/11, 9/12 etc... I'll have to work out some way to fill in the dates between the START_DATE and END_DATE

Or am I coming at this the wrong way?

LordShryku

No, that's the right way. Here's an idea...

$month = 9; # our month to use
$year  = 2004; # year to use

$sql = "SELECT start_date,
               end_date
          FROM table
         WHERE month(start_date) = ".$month."
           AND year(start_date) = ".$year;
$res = mysql_query($sql);

if(mysql_num_rows($res) > 0) {
   $dates = array(); # blank array to hold dates

   while($row = mysql_fetch_array($res)) {
      # pull out the days
      $start = date("d", strtotime($row['start_date']));
      $end   = date("d", strtotime($row['end_date']));

  # check if it exists in the array
  # if not, add it
  if($end > $start) {
     for($i=$start;$i<=$end;$i++) {
        if(!in_array($year.'-'.$month.'-'.$i, $dates))
           $dates[] = $year.'-'.$month.'-'.$i;
     }
  }
  else {
     # start should be the same as end
     # if it's less than end, you have a data problem
     if(!in_array($row['start_date'], $dates))
        $dates[] = $row['start_date'];
  }
   }
}
else {
   echo 'No rows found';
}

Should give you your array of dates ($dates). Might not though. Just threw it together :bemused:

ciaranmg

Excellent! It looks pretty good, I reckon I can make it work if it's not 100% anyway.

Thanks for the help.