Menu
Hi Below is code that displays a calendar which offers links for each day of the week. which opens a form to add information to a data base.
I’m trying to add a link undereach date where there is a schedualed event.
so far i have this which does nothing
[code=php]
include ‘db.php’;
$dlink = mysql_query(“SELECT * FROM calendar WHERE event_date = ‘$linkdate'”);
while ($row=mysql_fetch_assoc($dlink)){
$description = $row[‘event_description’];
echo “<a href=results.php?eventid=$link_date> $description </a></td>”;
}
complete calendar code
[code=php]
<?php
echo ”
<html>
<head>
<title>Calendar</title>
<body bgcolor=#FFFFFF>
<center>”;
// Check for a Month Change submission
if ($_POST) {
// Subtract one from the month for previous, add one for next
if ($_POST[“submit”] == “Prev”) {
$_POST[“month_now”]–;
} else {
$_POST[“month_now”]++; }
$date = getdate(mktime(0,0,0,
$_POST[“month_now”],1,
$_POST[“year_now”]));
} else {
$date = getdate();
}
$month_num = $date[“mon”];
$month_name = $date[“month”];
$year = $date[“year”];
$date_today = getdate(mktime(0,0,0,$month_num,1,$year));
$first_week_day = $date_today[“wday”];
$cont = true;
$today = 27;
while (($today <= 32) && ($cont)) {
$date_today = getdate(mktime(0,0,0,$month_num,$today,$year));
if ($date_today[“mon”] != $month_num) {
$lastday = $today – 1;
$cont = false;
}
$today++;
}
// allow for form submission to the script for forward and backwards
echo”
<form method=’POST’ name=’calendar’ action=’cal.php’>
<input type=’hidden’ name=’month_now’ value=’$month_num’>
<input type=’hidden’ name=’year_now’ value=’$year’>
<table width=’200′>
<tr><td><input type=’submit’ name=’submit’ value=’Prev’></td>
<td align=right><input
type=’submit’ name=’button’ value=’Next’></td>
</tr>
</table>
</form>
<table width=’160′ border=’1′ cellspacing=0 cellpadding=2>
<tr><td colspan=’7′>$month_name $year</td></tr>
<tr><td>Su</td><td>M</td><td>T</td><td>W</td><td>Th</td><td>F</td><td>Sat</td></
tr>”;
// begin placement of days according to their beginning weekday
$day = 1;
$wday = $first_week_day;
$firstweek = true;
while ( $day <= $lastday) {
if ($firstweek) {
echo “<TR>”;
for ($i=1; $i<=$first_week_day; $i++) {
echo “<TD> </td>”;
}
$firstweek = false;
}
if ($wday==0) {
echo “<tr>”;
}
// make each day linkable to the following result.php page
if ( intval($month_num) < 10) { $new_month_num = “0$month_num”; }
elseif (intval($month_num) >= 10) { $new_month_num = $month_num; }
if ( intval($day) < 10) { $new_day = “0$day”; }
elseif (intval($day) >= 10) { $new_day = $day; }
$link_date = “$year-$new_month_num-$new_day”;
// add some color and make todays dat stand out
$today_year = date(“Y”);
$today_month = date(“F”);
$today_day = date(“j”);
if($day == $today_day && $month_name ==
$today_month && $year == $today_year)
$colour = orange;
else
$colour = silver;
echo “<td align=center bgcolor=$colour><a href=results.php?eventid=$link_date> $day </a></td>”;
// show event description
include ‘db.php’;
$dlink = mysql_query(“SELECT * FROM calendar WHERE event_date = ‘$linkdate'”);
while ($row=mysql_fetch_assoc($dlink)){
$description = $row[‘event_description’];
echo “<a href=results.php?eventid=$link_date> $description </a></td>”;
}
if ($wday==6) {
echo “</tr>n”;
}
$wday++;
$wday = $wday % 7;
$day++;
}
echo”
</table>
</body>
</html>
“;
?>