I still see the message when I look at it…
here’s the link for what the page should look like:
http://projects.mattvanblari.com/calendarTest.php
here’s the code
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT" );
header("Last-Modified: " . gmdate( "D, d M Y H:i:s" ) . "GMT" );
header("Cache-Control: no-cache, must-revalidate" );
header("Pragma: no-cache" );
header("Content-Type: text/xml; charset=utf-8");
//////////////////////////////////////
// set these variables for your MySQL
$dbhost = 'dbhost'; // usually localhost
$dbuser = 'user'; // database username
$dbpass = 'password'; // database password
$database = 'databaseName'; // database
//////////////////////////////////////
$db = @mysqli_connect($dbhost, $dbuser, $dbpass, $database) or die ("<?xml version=\\"1.0\\" ?><response><content><![CDATA[<span class='error'>Database connection failed.</span>]]></content></response>");
$xml = '<?xml version="1.0" ?><response><content><![CDATA[';
$month = $_GET['month'];
$year = $_GET['year'];
if($month == '' && $year == '') {
$time = time();
$month = date('n',$time);
$year = date('Y',$time);
}
$date = getdate(mktime(0,0,0,$month,1,$year));
$today = getdate();
$hours = $today['hours'];
$mins = $today['minutes'];
$secs = $today['seconds'];
if(strlen($hours)<2) $hours="0".$hours;
if(strlen($mins)<2) $mins="0".$mins;
if(strlen($secs)<2) $secs="0".$secs;
$days=date("t",mktime(0,0,0,$month,1,$year));
$start = $date['wday']+1;
$name = $date['month'];
$year2 = $date['year'];
$offset = $days + $start - 1;
if($month==12) {
$next=1;
$nexty=$year + 1;
} else {
$next=$month + 1;
$nexty=$year;
}
if($month==1) {
$prev=12;
$prevy=$year - 1;
} else {
$prev=$month - 1;
$prevy=$year;
}
if($offset <= 28) $weeks=28;
elseif($offset > 35) $weeks = 42;
else $weeks = 35;
$xml .= "<div id='left'>
<table class='calHead'>
<tr>
<td class='date'>
$name $year2
</td>
</tr>
<tr>
<td class='calNav'>
<input type='button' onClick='navigate($prev,$prevy,\\"\\")' value='Last' />
<input type='button' onClick='navigate(\\"\\",\\"\\",\\"\\")' value='Current' />
<input type='button' onClick='navigate($next,$nexty,\\"\\")' value='Next' />
<input type='button' onClick='showJump(this)' value='Jump To:' />
</td>
</tr>
</table>
<table class='cal'>
<tr class='dayhead'>
<td>Sun</td>
<td>Mon</td>
<td>Tue</td>
<td>Wed</td>
<td>Thu</td>
<td>Fri</td>
<td>Sat</td>
</tr>";
$col=1;
$cur=1;
$next=0;
for($i=1;$i<=$weeks;$i++) {
if($next==3) $next=0;
if($col==1) $xml.="\
<tr class='dayrow'>";
$xml.="\ <td onMouseOver=\\"this.className='dayover'\\" onMouseOut=\\"this.className='dayout'\\">";
if($i <= ($days+($start-1)) && $i >= $start)
{
$xml.="<p";
if(($cur==$today[mday]) && ($name==$today[month]) && ($year2==$today[year]))
{
$xml.=" class='currDay'";
}
$xml.=">$cur";
$sql = "SELECT eventCal_occ.eventID, eventCal_info.eventID, eventCal_occ.date, eventCal_occ.startTime FROM eventCal_info, eventCal_occ WHERE eventCal_occ.date ='$year-$month-$cur'AND eventCal_occ.eventID = eventCal_info.eventID";
$result = mysqli_query($db, $sql);
$events = mysqli_num_rows($result);
if( mysqli_num_rows($result) > 0)
{
$row = mysqli_fetch_row($result);
$xml.="<a href='javascript:navigate($month,$year,\\"".$row[2]."\\")'>$events Event(s)</a>";
}
$xml.="\
\ </p></td>\
";
$cur++;
$col++;
}
else
{
$xml.=" \
\ </td>\
";
$col++;
}
if($col==8)
{
$xml.="\
</tr>\
";
$col=1;
}
}
$xml.="</table></div>";
if($_GET['event'] != '')
{
$xml .= "<div id='eventDetails'>";
$fields = explode("-",$_GET['event']);
$sql = "SELECT dateID, eventCal_occ.eventID, eventName, DATE_FORMAT(date, '%m/%d/%Y') AS date, description, eventType, contactName, contactEmail, contactPhone, DATE_FORMAT(startTime,'%l:%i') AS startTime, DATE_FORMAT(endTime,'%l:%i%p') AS endTime FROM eventCal_occ, eventCal_info WHERE date = '".$_GET['event']."' AND eventCal_occ.eventID = eventCal_info.eventID";
$result = mysqli_query($db, $sql);
while($row = mysqli_fetch_array($result))
{
$xml .= "<div id='event'>";
$xml .= "<div class='heading'>";
$xml .= "<div><p class='back'><a href='javascript:navigate($month,$year,\\"\\")'>Close Event(s)</a></p></div>";
$xml .= "<div><p class='title'>".$row['eventName']."</p></div>";
$xml .= "<div><p class='posted'>".$row['date']." ".$row['startTime']." - ".$row['endTime']."</p></div>";
$xml .= "</div>";//end heading div
$xml .= "<div><p class='description'>".$row['description']."</p></div>";
$xml .="<div><p class='contactInfo'>For more information, please contact ".$row['contactName']." at ".$row['contactEmail'].", or ".$row['contactPhone']."</p></div>";
$xml .= "</div>";//end EVENT div
}
$xml .="</div>";
}
$xml .= "]]></content></response>";
echo $xml;
?>