Hi

I'm having a bit of trouble getting a calendar script to work.  I can get it to print out correctky, but what I would like is to tie it to a musql database, so if for example there is an event in the database for 1st april 2007, the 1st would be highlighted as a link, but if no events are on no link would be there.

So far the calendar is working on its own, also I can get the information out of teh database, but can't seem to do both at the same time

Here is the calendar script:

Code:

<?php $PageTitle = "Calendar"; $Month=$_GET['Month']; $Year=$_GET['Year']; require ("header.php"); // If the $Month and $Year values don't exist, make them the current month and year.       if ((!$Month) && (!$Year)) {      $Month = date ("m");      $Year = date ("Y"); } //  Calculate the viewed Month. $Timestamp = mktime (0, 0, 0, $Month, 1, $Year); $MonthName  =  date("F", $Timestamp); //  Make a table with the proper month. ?> <TABLE BORDER=0 CELLPADDING=3 CELLSPACING=0 ALIGN=CENTER> <TR><TD COLSPAN=7 ALIGN=CENTER><FONT COLOR=blue><?php print"$MonthName $Year"; ?></TD></TR> <TR><TD>Su</TD> <TD>M</TD> <TD>Tu</TD> <TD>W</TD> <TD>Th</TD> <TD>F</TD> <TD>Sa</TD></TR> <?php $MonthStart = date("w", $Timestamp); if ($MonthStart == 0) {      $MonthStart = 7; } $LastDay = date("d", mktime (0, 0, 0, $Month+1, 0, $Year)); $StartDate = -$MonthStart; #this just proves info is present in the database $conn= mysql_connect("localhost","username","password") or die("connection problem"); $db= mysql_select_db("calendar",$conn) or die("database problem"); $sql="select * from cal"; $ex=mysql_query($sql, $conn); while($row=mysql_fetch_array($ex)){      echo"$row[id], $row[date] $row[event] <br>"; } for ($k = 1; $k <= 6; $k++) { // Print 6 rows.      print ("<TR BGCOLOR=WHITE>");      for ($i = 1; $i <= 7; $i++) { // Use 7 columns            $StartDate++;            if (($StartDate <= 0) || ($StartDate > $LastDay)) {                  print ("<TD BGCOLOR=white>&nbsp</TD>");            } elseif (($StartDate >= 1) && ($StartDate <= $LastDay)) { #this is where I need another if statement, but not sure what!!                  print ("<TD ALIGN=CENTER>: $StartDate :</TD>");                  }                  else {                  print ("<TD ALIGN=CENTER>$StartDate</TD>");                  }            }      }          print ("</TR>\n"); } print ("</TABLE>\n"); // Make the form. print ("<FORM ACTION=\"calendar.php\" METHOD=GET>\n"); print ("Select a new month to view:\n"); print ("<SELECT NAME=Month><OPTION VALUE=1>January</OPTION>\n<OPTION VALUE=2>February</OPTION>\n<OPTION VALUE=3>March</OPTION>\n<OPTION VALUE=4>April</OPTION>\n<OPTION VALUE=5>May</OPTION>\n<OPTION VALUE=6>June</OPTION>\n<OPTION VALUE=7>July</OPTION>\n<OPTION VALUE=8>August</OPTION>\n<OPTION VALUE=9>September</OPTION>\n<OPTION VALUE=10>October</OPTION>\n<OPTION VALUE=11>November</OPTION>\n<OPTION VALUE=12>December</OPTION>\n</SELECT>\n"); print ("<SELECT NAME=Year><OPTION VALUE=2007>2007</OPTION>\n<OPTION VALUE=2008>2008</OPTION>\n<OPTION VALUE=2009>2009</OPTION>\n<OPTION VALUE=2010>2010</OPTION>\n<OPTION VALUE=2011>2011</OPTION>\n</SELECT>\n"); print ("<INPUT TYPE=SUBMIT NAME=SUBMIT VALUE=\"Submit!\">\n"); print ("</FORM>\n"); require ("footer.php"); ?>

The mysql database/table has 3 fields, ID, Date and event,

I've put where I think I need another IF statement, what I don;t know is how to compare the date from the calendar to the date in the datebase , any pointers gratefully received?

Thanks

Chris


Chris, I'm feeling pretty tired at the moment and that's a lot of code for a Wednesday afternoon.  

However.

I've been asked (as it happens) to work on a calendar example with my class tomorrow - not your code directly but I SHALL be coming up with a calendar handling example that has links on som edays but not on others - worked on one recently that related to hotel availability, funnily enough!  I'll come back and post a follow up

That would be great, thank you.


What I desribed as my "hot diary" script is here ... and you can run it from there too.  Looking at it v your question I'm not really sure it will help much - although I do have a modified varient that passes a parameter into each day cell and colours it depending on room availablility. The code for THAT is - err - contorted and something I'm not proud of.

Hi Graham,

Firstly thanks for posting this and sorry for the delay in responding, been up to my neck in it last few days.

Haven't had a good chance to have a play with this script, but hopefully (once kids are in bed) will do tonight

I think I've narrowed down where I'm stuck, in the loop :

Code:

for ($k = 1; $k <= 6; $k++) { // Print 6 rows.  print ("<TR BGCOLOR=WHITE>");  for ($i = 1; $i <= 7; $i++) { // Use 7 columns   $StartDate++;   if (($StartDate <= 0) || ($StartDate > $LastDay)) {    print ("<TD BGCOLOR=white>&nbsp</TD>");     } elseif (($StartDate >= 1) && ($StartDate <= $LastDay)) { #this is where I need another if statement, but not sure what!!    print ("<TD ALIGN=CENTER>: $StartDate :</TD>");     }   else {    print ("<TD ALIGN=CENTER>$StartDate</TD>");     }   }    }

What I think I have to do is for each date look and see if there is an equivelent date stored in the mysql database, if so make that number a hyperlink to execute the query of bring up the event details for that date.

Will let you know how I get on.

Thanks again.

Like you, Chris, rushed off my tootsie!   I note you'll report back ... yes, please do.  I have a Perl course tomorrow, sandwiched between Dilton Marsh Halt at 06:27 and a phone call from a top civil servant in the evening.  A long story ...

I have a (somewhat) related question.  I have a form that needs a dropbox showing the next 7 days, converted from this format: "2007-03-19" to this format: "Monday, March 19".

That didn't make much sense, did it?  Let's try again.

The dropbox has Monday, March 19, but when it writes the value to the form field it would be 2007-03-19.

Drop Box                          Value Written
Monday, March 19            2007-03-19
Tuesday, March 20           2007-03-20
Wednesday, March 21     2007-03-21
Thursday, March 22         2007-03-22
Friday, March 23              2007-03-23
Saturday, March 24         2007-03-24
Sunday, March 25            2007-03-25

Two questions...is that possible, and if so, can someone steer me in the right direction?

Thanks.

Brian

Try this ...

If it's right, here's the source:
Code:

<?php function daysahead($ndays) {   $now = time();   for ($step = 0; $step < $ndays; $step ++) {        $report = $now + $step * 24 * 3600;        $form1 = date("Y-m-d",$report);        $form2 = date("j F",$report);        $selbox .= "<option value=$form1>$form2</option>";        }   return "<select name=whichday>$selbox</select>"; } ?> <html> <head> <title>Selection box - the week ahead</title> </head> <body> <h1>The week ahead</h1> <?php if ($_REQUEST[whichday]) {        print ("previous selection was $_REQUEST[whichday]"); } else {        print ("Results will come here"); } ?> <br /><form> <?php print(daysahead(14)); ?> <br /><input type=submit></form><br /> Please choose the day. </body> </html>

Thanks, Graham...that was it!

---