I've built a calendar and people are free to add/delete/modify events on their calendar as they wish. However, I have no idea how to get an icon to show up on the date they've booked an event.
All the activities are stored in a MySQL database table called activities.
I hope someone can help me out.
My coding is as follows:
<?PHP
mk_drawCalendar($m,$y);
?></div>
<div align="center">
<?PHP
// Draw the Calendar
function mk_drawCalendar($m,$y)
{
if ((!$m) || (!$y))
{
$m = date("m",mktime());
$y = date("Y",mktime());
if ($m==1)
$themonth="jan";
else if ($m==2)
$themonth="feb";
else if ($m==3)
$themonth="mar";
else if ($m==4)
$themonth="apr";
else if ($m==5)
$themonth="may";
else if ($m==6)
$themonth="jun";
else if ($m==7)
$themonth="jul";
else if ($m==8)
$themonth="aug";
else if ($m==9)
$themonth="sept";
else if ($m==10)
$themonth="oct";
else if ($m==11)
$themonth="nov";
else if ($m==12)
$themonth="dec";
}
// get what weekday the first is on /
$tmpd = getdate(mktime(0,0,0,$m,1,$y));
$month = $tmpd["month"];
$firstwday= $tmpd["wday"];
$lastday = mk_getLastDayofMonth($m,$y);
?>
Click on date to see details
<table cellpadding=2 cellspacing=0 border=1>
<tr>
<td colspan=7 bgcolor="#cccc99">
<table cellpadding=0 cellspacing=0 border=0 width="100%">
<tr>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m-1)<1) ? 12 : $m-1 ?>&y=<?=(($m-1)<1) ? $y-1 : $y ?>"><<</a>
</th>
<th><?="$month $y"?></th>
<th width="100">
<a href="<?=$SCRIPT_NAME?>?m=<?=(($m+1)>12) ? 1 : $m+1 ?>&y=<?=(($m+1)>12) ? $y+1 : $y ?>">>></a>
</th>
</tr>
</table>
</td>
</tr>
<tr>
<th width=100 class="tcell">Sunday</th>
<th width=100 class="tcell">Monday</th>
<th width=100 class="tcell">Tuesday </th>
<th width=100 class="tcell">Wednesday</th>
<th width=100 class="tcell">Thursday</th>
<th width=100 class="tcell">Friday</th>
<th width=100 class="tcell">Saturday</th>
</tr>
<?PHP
$d = 1;
$wday = $firstwday;
$firstweek = true;
//Loop Through to last day
while ( $d <= $lastday)
{
//blanks for first week
if ($firstweek) {
print "<tr>";
for ($i=1; $i<=$firstwday; $i++)
{ print "<th height=100 bgcolor=#CCCCCC> </th>"; }
$firstweek = false;
}
/
$select = "SELECT FROM activities, clientactivity WHERE CUserName='$CUserName'";
$result = mysql_query($select);
$numrows = mysql_num_rows($result);
*/
//checks for event
if($numrows>=1)
{
//Event exists
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">
<a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y target=\"new_window\">$d</a>
</td>";
}
else
{
//Event doesn't exist
print "<td class='tcell' bgcolor=#CCCCCC valign=\"top\" height=\"100\">
<a href=calendardetails.php?ADay=$d&AMonth=$themonth&AYear=$y target=\"new_window\">$d</a>
</td>";
}
//Saturday end week with <tr>
// if ($wday==6) { print "<th height=150 bgcolor=#00ff00></tr>\n</th>"; }
$wday++;
$wday = $wday % 7;
$d++;
// Sunday start week with <tr>
if ($wday==0) { print "<th height=100 bgcolor=#ffffff><tr></th>"; }
//blanks for last week
if ($lastweek) {
print "<tr>";
for ($lastday=28; $tlastday<=31; $lastday++)
{ print "<th height=100 bgcolor=#AAAAAA></th> "; }
$lastweek = false;
}
}
?>
</tr></table>
Click on date to see details
<br>
<?PHP
//end calendar Draw Function
}
//Show the last day of the month
function mk_getLastDayofMonth($mon,$year)
{
for ($tday=28; $tday <= 31; $tday++)
{
$tdate = getdate(mktime(0,0,0,$mon,$tday,$year));
if ($tdate["mon"] != $mon)
{ break; }
}
$tday--;
return $tday;
}
?>
