[RESOLVED] Dynamic Calendar

[parabuck]

So, I'm a newbie and I've searched many places looking for the answer...I think I'm getting close but I just can't seem to figure out my problem. I'm trying to populate my calendar from a database but it's just not working. I've been able to show just one record on each day, and I've been able to show every record on everyday, but I can't seem to marry up the database date with the calendar date and show it correctly on the calendar. See my code below, thanks for all the help!!

<?php
$timestamp = (isset($GET['t'])) ? $GET['t'] : time();

list($month, $day, $year) = explode('/', date('m/d/Y', $timestamp));
$first_day_of_month = date('w', mktime(0,0,0,$month,1,$year));
$total_days = date('t', $timestamp);

// output table header
ob_start();
echo '<table id="calendar" border=0 cellpadding=0 cellspacing=0 class=totalborder align=center>';
echo '<tr id="calendar_header"><td colspan="7" class=calendar_header>';
echo '<a href="' . htmlspecialchars($SERVER['PHP_SELF']) . '?t=' . strtotime('-1 month', $timestamp) . '">&laquo;</a> &nbsp;';
echo date('F', $timestamp) . ' ' . $year;
echo '&nbsp; <a href="' . htmlspecialchars($SERVER['PHP_SELF']) . '?t=' . strtotime('+1 month', $timestamp) . '">&raquo;</a>';
echo '</td></tr>';
echo '<tr class=style3><th>Sunday</th><th>Monday</th><th>Tuesday</th><th>Wednesday</th><th>Thursday</th><th>Friday</th><th>Saturday</th></tr>';

// output date cells
$current = 1;
while ($current <= $total_days)
{
echo '<tr>';
for ($i = 0; $i < 7; $i++)
{
if (($current == 1 && $i < $first_day_of_month) || ($current > $total_days))
{
echo '<td class=calendar_dates>&nbsp;</td>';
continue;
}

		echo '<td class=dayborder>';

			echo '<table border=0 cellpadding=2 cellspacing=0>
					<tr align=right>
						<td class=numberdayC colspan=2>';
			echo $current;
			echo '</td></tr>';

$query = "SELECT CalendarID, CalDate, CalStation, CalEmp1, CalEmp2, Shift, CalStation2, Sta2Emp1, Sta2Emp2, CalStation3, Sta3Emp1, Sta3Emp2, Sta3StartTime, CalStation4, Sta4Emp1, Sta4Emp2, CalStation5, Sta5Emp1, Sta5Emp2, CalStation6, Sta6Emp1, Sta6Emp2 FROM calendar LEFT JOIN employees ON CalEmp1 = EmpName WHERE Year(CalDate) = " . $year . " AND MONTH(CalDate) = " . $month;
$result = mysql_query($query, $Lifeline) or die(mysql_error());

		if (mysql_num_rows($result))
		{
			while ($row_Calendar = mysql_fetch_array($result))
			{

				echo '<tr align=center><td class=station>';
				echo $row_Calendar['CalStation'];
				echo '</td><td class=station>';
				echo $row_Calendar['CalStation3'];
				echo '</td></tr><tr align=center><td class=small>';
				echo $row_Calendar['CalEmp1'];
				echo '</td><td class=small>';
				echo $row_Calendar['Sta3Emp1'];
				echo '</td></tr><tr align=center><td class=small>';
				echo $row_Calendar['CalEmp2'];
				echo '</td><td class=small>';
				echo $row_Calendar['Sta3Emp2'];
				echo '</td></tr><tr align=center><td class=station>';
				echo $row_Calendar['CalStation2'];
				echo '</td><td class=station>';
				echo $row_Calendar['CalStation5'];
				echo '</td></tr><tr align=center><td class=small>';
				echo $row_Calendar['Sta2Emp1'];
				echo '</td><td class=small>';
				echo $row_Calendar['Sta5Emp1'];
				echo '</td></tr><tr align=center><td class=small>';
				echo $row_Calendar['Sta2Emp2'];
				echo '</td><td class=small>';
				echo $row_Calendar['Sta5Emp2'];
				echo '</td></tr><tr align=center><td class=station>';
				echo $row_Calendar['CalStation4'];
				echo '</td><td class=station></td></tr><tr align=center><td class=small>';
				echo $row_Calendar['Sta4Emp1'];
				echo '</td><td></td></tr><tr align=center><td class=small>';
				echo $row_Calendar['Sta4Emp2'];
				echo '</td></tr>';
			}
		}
		else
		{
			echo '&nbsp;';
		}
		mysql_free_result($result);
		echo '</table></td>';
		$current++;
	}
	echo '</tr>';
}
echo '</table>';
$GLOBALS['TEMPLATE']['content'] = ob_get_clean();

// assign styles for calendar
$GLOBALS['TEMPLATE']['extra_head'] = '<link rel="stylesheet" type="text/css" href="stylesheet.css"/>';

// display page
include 'template-page.php';

?>

[Krik]

First, with that much code please use the php code wrapper tags. It makes code much easier to read especially that amount of code and saves us from having to spend time copying it out to our editors and formatting it for readability.

<?php
$timestamp = (isset($_GET['t'])) ? $_GET['t'] : time();

list($month, $day, $year) = explode('/', date('m/d/Y', $timestamp));
$first_day_of_month = date('w', mktime(0,0,0,$month,1,$year));
$total_days = date('t', $timestamp);


// output table header
ob_start();
echo '<table id="calendar" border=0 cellpadding=0 cellspacing=0 class=totalborder align=center>';
echo '<tr id="calendar_header"><td colspan="7" class=calendar_header>';
echo '<a href="' . htmlspecialchars($_SERVER['PHP_SELF']) . '?t=' . strtotime('-1 month', $timestamp) . '">&laquo;</a> &nbsp;';
echo date('F', $timestamp) . ' ' . $year;
echo '&nbsp; <a href="' . htmlspecialchars($_SERVER['PHP_SELF']) . '?t=' . strtotime('+1 month', $timestamp) . '">&raquo;</a>';
echo '</td></tr>';
echo '<tr class=style3><th>Sunday</th><th>Monday</th><th>Tuesday</th><th>Wednesday</th><th>Thursday</th><th>Friday</th><th>Saturday</th></tr>';

// output date cells
$current = 1;
	while ($current <= $total_days)
	{
	echo '<tr>';
		for ($i = 0; $i < 7; $i++)
		{
			if (($current == 1 && $i < $first_day_of_month) || ($current > $total_days))
			{
			echo '<td class=calendar_dates>&nbsp;</td>';
			continue;
			}

	echo '<td class=dayborder>';

	echo '<table border=0 cellpadding=2 cellspacing=0>
	<tr align=right>
	<td class=numberdayC colspan=2>';
	echo $current;
	echo '</td></tr>';

	$query = "SELECT CalendarID, CalDate, CalStation, CalEmp1, CalEmp2, Shift, CalStation2, Sta2Emp1, Sta2Emp2, CalStation3, Sta3Emp1, Sta3Emp2, Sta3StartTime, CalStation4, Sta4Emp1, Sta4Emp2, CalStation5, Sta5Emp1, Sta5Emp2, CalStation6, Sta6Emp1, Sta6Emp2 FROM calendar LEFT JOIN employees ON CalEmp1 = EmpName WHERE Year(CalDate) = " . $year . " AND MONTH(CalDate) = " . $month;

	$result = mysql_query($query, $Lifeline) or die(mysql_error());

		if (mysql_num_rows($result))
		{
			while ($row_Calendar = mysql_fetch_array($result))
			{

			echo '<tr align=center><td class=station>';
			echo $row_Calendar['CalStation'];
			echo '</td><td class=station>';
			echo $row_Calendar['CalStation3'];
			echo '</td></tr><tr align=center><td class=small>';
			echo $row_Calendar['CalEmp1'];
			echo '</td><td class=small>';
			echo $row_Calendar['Sta3Emp1'];
			echo '</td></tr><tr align=center><td class=small>';
			echo $row_Calendar['CalEmp2'];
			echo '</td><td class=small>';
			echo $row_Calendar['Sta3Emp2'];
			echo '</td></tr><tr align=center><td class=station>';
			echo $row_Calendar['CalStation2'];
			echo '</td><td class=station>';
			echo $row_Calendar['CalStation5'];
			echo '</td></tr><tr align=center><td class=small>';
			echo $row_Calendar['Sta2Emp1'];
			echo '</td><td class=small>';
			echo $row_Calendar['Sta5Emp1'];
			echo '</td></tr><tr align=center><td class=small>';
			echo $row_Calendar['Sta2Emp2'];
			echo '</td><td class=small>';
			echo $row_Calendar['Sta5Emp2'];
			echo '</td></tr><tr align=center><td class=station>';
			echo $row_Calendar['CalStation4'];
			echo '</td><td class=station></td></tr><tr align=center><td class=small>';
			echo $row_Calendar['Sta4Emp1'];
			echo '</td><td></td></tr><tr align=center><td class=small>';
			echo $row_Calendar['Sta4Emp2'];
			echo '</td></tr>';
			}
		}
		else
		{
		echo '&nbsp;';
		}
	mysql_free_result($result);
	echo '</table></td>';
	$current++;
	}
echo '</tr>';
}
echo '</table>';
$GLOBALS['TEMPLATE']['content'] = ob_get_clean();

// assign styles for calendar
$GLOBALS['TEMPLATE']['extra_head'] = '<link rel="stylesheet" type="text/css" href="stylesheet.css"/>';

// display page
include 'template-page.php';
?>

Now to the question. To get the data to match each day your WHERE needs to look for the day that matches the "current" day. Right now it looks to be only looking for the month and year, but not the day.

[parabuck]

Krik, thank you for your response. I do apologize for not putting the code in the wrapper tags. I will learn more about those...

I have tried putting the current date in and all it returns is that days record for the respective month and displays that same record for each and every day. For example, 2009-02-12 is displayed for each day throughout the month of February, 2009-03-12 is displayed for each day throughout the month of March etc. With the current code I at least was getting all of the records for the month to display for each day. So I thought that maybe my loop was wrong. Any suggestions?

[Krik]

So changing the WHERE to read like

WHERE Year(CalDate) = " . $year . " AND MONTH(CalDate) = " . $month . " AND DAYOFMONTH(CalDate) = " . $current

Will not out put that days record? If it doesn't output that days record something else is wrong because as I read your code it looks like $current increments forward till it reaches the value of $total_days. So each time it loops and the query is called it should grab the record WHERE the year = $year, AND the month = $month AND the day = $current

[parabuck]

Oh man, that was easy. I think I have tried every other variable except that one. Thank you for your assistance!!