PHPBuilder - phpCalendar



RSS Twitter
Snippets Calendars Dates

phpCalendar

by: chris
|
September 17, 2003

Version: 2

Type: Full Script

Category: Calendars/Dates

License: Other

Description: This is a simple calendar that displays a nice, attractive calendar with month forward and backward buttons (you supply icons).



<?

/* Author: Jason Loretz
	   j_loretz@yahoo.com
   Description: A simple calendar. 
   License: NONE, Except to include this header.
   
   Editing/Updating Programmers:
   	Chris Heald - 5/10/01 - cheald45@hotmail.com
   		Questions/comments welcome!
  
	 Updated 09/17/2003
	 Chris Weisiger - 09/17/03
	 		c_weisiger@yahoo.com
	 	
   #### CHANGE LOG ####
   Change log created - CMH 5/10/01
   05/10/01 - CMH
     Added 1 pixel transparent GIF to headers for absolute spacing
     Added stylesheet to HTML header function
     Added "highlight today" functionality
     Changed foward and backward buttons to text links
     Changed script references so that $PHP_SELF is used rather than a hardcoded script name
     Fixed leftover row problem - caused a thick border at the bottom on months that ended on Sat.
     Removed "created on" text
     Changed "Thurs" to "Thu" and "Tues" to "Tue" for standardization
     Changed date() parameters to literals to avoid warnings.
     Compacted calendar for inclusion on a page. Size is now approximately 165 pixels wide.
   01/08/02 - CMH
     Fixed several warnings
     Fixed severe issue with table rows on Saturday
     Pared down day loop code - more efficient now
*/

/*
	  09/17/2003 - CRW
		Edited style to remove underline for hover of previous/next links.
		Added additional style for day if it has data for that day in database to set to bold with no underline.
		Removed <b> tag from days so not to conflict with days that are linked to additional data.
		Added mySQL database functionality with the addition of a function.
		If a day has data and is linked...it goes to info.php page passing the id of the information.
		Being I ran this on win32 environment I had to make changes on how the date was initially.
		retrieved if it wasnt already set by using the next/previous links.
		Have not tested on weither this change is necessary in linux evironment.
		Changes made on lines 115, 116, 122, 123

		mySQL table information

		Tablename: calendarData;
		Columns: cdid integer(12) auto_increment primary key;
						 cddate date;
						 cdinfo text;
*/

function getData($currMonth, $currDay, $currYear, $resID) {
			$query = "select * from calendarData where cddate='" . $currYear . "-" . $currMonth . "-" . $currDay . "'";
			$result = mysql_query($query, $resID);

			if (mysql_num_rows($result) > 0) {
				 $row = mysql_fetch_array($result);
				 $linkedData = "<b><a class='link' href='info.php?id=" . $row["cdid"] . "'>$currDay</a></b>";
      } else {
				 $linkedData = "$currDay";
			}
			return $linkedData;
}

$hostname = "localhost";
$username = "root";
$password = "";
$dbname = "calendarInfo";

$conn = mysql_connect($hostname, $username, $password);
mysql_select_db($dbname);




// HTML Color Schemes
$header_bgcolor = "#000000";
$header_txtcolor = "#FFFFFF";
$title_bgcolor = "#660000";
$title_txtcolor = "#FFFFFF";
$text_bgcolor = "#FFFFFF";
$text_txtcolor = "#000000";
$date_bgcolor = "#FFFFFF";
$extra_bgcolor = "#CCCCCC";
$weekend_txtcolor = "#996666";
$highlight_today = 1;			//1 = yes; 0 = no; - CMH 5/10/01
$today_bgcolor = "#660000";		//background color for today's date - CMH 5/10/01
$today_txtcolor = "#FFFFFF";		//foreground for today's date - CMH 5/10/01
$image_dir = ".";			//path to the 1pix.gif picture used for spacing
$image_name = "1pix.gif";
$table_width = 150;			//mostly irrevelant now, unless you want a table wider than [(7px * column_width) + borders]
$column_width = 22;


#######################
## Program Functions ##
#######################
// Generate the month text for the numbers (returns a string)
function genMonth_Text($month) {
	switch ($month) {
		case 1: $month_text = "January"; break;
		case 2: $month_text = "February"; break;
		case 3: $month_text = "March"; break;
		case 4: $month_text = "April"; break;
		case 5: $month_text = "May"; break;
		case 6: $month_text = "June"; break;
		case 7: $month_text = "July"; break;
		case 8: $month_text = "August"; break;
		case 9: $month_text = "September"; break;
		case 10: $month_text = "October"; break;
		case 11: $month_text = "November"; break;
		case 12: $month_text = "December"; break;
	}
	return ($month_text);
}

// Set Today's Month (returns numerical value)
function genSet_Month() {
	//$month = date("m",mktime(0,0,0,1,12,2));
	$month = date("m");
	return ($month);
}

// Set Today's Year (returns numerical value)
function genSet_Year() {
	//$year = date("Y",mktime(0,0,0,1,12,2));
	$year = date("Y");
	return ($year);
}

// Generate the Stop Value (returns the number of days in the month)
function genSet_Stop($month,$year) {
	if ($month == '12') {
		$month = 1;
		$year++;
	} else {
		$month++;
	}
	$stop = mktime(0,0,0,$month,0,$year);
	$stop = date("d",$stop);
	return ($stop);
}

// Generate the top HTML (returns HTML string)
function genTop_HTML() {
	$string = "<html>\n<head>\n\t<title>phpCalendar.php</title>\n</head>\n" .
		  "<body bgcolor=\"#FFFFFF\">\n" .
		  "<center>\n" .
		  "<STYLE>
		  BODY {font-family:arial;}
		  TD {font-family:arial;
		      font-size:10pt;}
		  A.cal_nav {color:white;
		  		text-decoration:none;}
		  A.cal_nav:hover {color:white;
		  		text-decoration:none;}
      A.link {color=black;
					text-decoration:none;}
		  </STYLE>";

	return ($string);
}

// Generate the end HTML (returns HTML string)
function genEnd_HTML() {
	$string = "</center>\n" .
		  "</body>\n</html>";

	return ($string);
}

// Generate the table header (returns HTML string)
function genTable_Header($table_width,$header_bgcolor) {
	$string = "<table width=\"$table_width\" cellpadding=\"1\" cellspacing=\"0\">" .
		  "<tr><td bgcolor=\"$header_bgcolor\">\n" .
		  "<table width=\"$table_width\" cellpadding=\"0\" cellspacing=\"1\" BORDER=0>\n";

	return ($string);
}

// Generate the table footer (returns HTML string)
function genTable_Footer() {
	$string = "</table></td></tr></table>\n";
	return ($string);
}

// Generates the information to be displayed
function genCalendar_Month($month,$year,$stop,
			   $column_width,$extra_bgcolor,$weekend_txtcolor,$date_bgcolor,
			   $header_bgcolor,$header_txtcolor,
			   $title_bgcolor, $title_txtcolor) {

$conn = mysql_connect("localhost", "root", "");
mysql_select_db("calendarInfo");				 
				 
	global $PHP_SELF, $today_bgcolor, $today_txtcolor, $highlight_today, $image_dir, $image_name;
	if ($month == 12) {
		$prev_month = $month - 1;
		$prev_year = $year;
		$next_month = 1;
		$next_year = $year + 1;
	} elseif ($month == 1) {
		$prev_month = 12;
		$prev_year = $year - 1;
		$next_month = $month + 1;
		$next_year = $year;
	} else {
		$prev_month = $month - 1;
		$prev_year = $year;
		$next_month = $month + 1;
		$next_year = $year;
	}
	$start = mktime(0,0,0,$month,1,$year);
	$start = date("w",$start);
	$month_text = genMonth_Text($month);
	$date_string = $month_text . " " . $year;

	$string = "<tr><td colspan=\"1\" bgcolor=\"$header_bgcolor\" align=\"right\" valign=\"center\">\n" .
		  "<a href=\"$PHP_SELF?month=$prev_month&year=$prev_year&mode=month\" class=\"cal_nav\">&lt;&lt;</a>" .
		  "</td><td colspan=\"5\" bgcolor=\"$header_bgcolor\" align=\"center\">\n" .
		  "<font color=\"$header_txtcolor\" size=\"2\"><b>$date_string</b></font>\n" .
		  "</td><td colspan=\"1\" bgcolor=\"$header_bgcolor\" align=\"left\" valign=\"center\">\n" .
		  "<a href=\"$PHP_SELF?month=$next_month&year=$next_year&mode=month\" class=\"cal_nav\">&gt;&gt;</a>" .
		  "</td></tr>\n" .
		  "<tr><td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Sun<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Mon<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Tue<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Wed<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Thu<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Fri<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td>\n" .
		  "<td width=\"$column_width\" bgcolor=\"$title_bgcolor\" align=\"center\">" .
		  "<font color=\"$title_txtcolor\">Sat<IMG border=0 SRC=\"$image_dir/$image_name\" height=1 width=\"$column_width\"></font></td></tr>\n";

	$string .= "<tr>";
	for ($i = 0; $i < $start; $i++) {
		$string .= "<td bgcolor=\"$extra_bgcolor\" align=\"center\">&nbsp;</td>\n";
	}
	//echo "Start: $start";
	$frame = $start - 1; //date("w",$day);
	for ($i = 1; $i <= $stop; $i++) {
		$day = mktime(0,0,0,date("m",time()),$i,date("Y",time()));
		$frame++;
		if($frame > 6) {
		  $string .= "</TR>\n";
		  if($i < $stop)
		    $string .= "<TR>";
		  $frame = 0;
		}
		if(($month) == date("m",$day) && $year == date("Y",$day) && date("d",$day) == date("d",time()) && $highlight_today == 1) {
		  $string .= "<td width=\"$column_width\" bgcolor=\"$today_bgcolor\" align=\"center\">" .
		  "<FONT COLOR=\"$today_txtcolor\">" . getData($month, $i, $year, $conn) . "</FONT></td>\n";
		  continue;
		}
		if ($frame == 6 || $frame == 0) {
			$string .= "<td width=\"$column_width\" bgcolor=\"$date_bgcolor\" align=\"center\">" .
				   "<font color=\"$weekend_txtcolor\">" .
				   "" . getData($month, $i, $year, $conn) . "</font></td>";
		} else {
			$string .= "<td width=\"$column_width\" bgcolor=\"$date_bgcolor\" align=\"center\">" .
				   "" . getData($month, $i, $year, $conn) . "</td>\n";
		}
	}
	for ($i = 1; $frame < 6; $frame++) {
		$string .= "<td bgcolor=\"$extra_bgcolor\" align=\"center\">&nbsp;</td>\n";
	}
	if ($frame < 6) { $string .= "</tr>\n"; }
	return ($string);
}

######################
## Script Execution ##
######################
print $top_html = genTop_HTML();
print $top_html = genTable_Header($table_width,$header_bgcolor);
if (@!$month) {
	$month = genSet_Month();
	$year = genSet_Year();
}
$day_number = genSet_Stop($month,$year);
print $mid_html = genCalendar_Month($month,$year,$day_number,
				    $column_width,$extra_bgcolor,
				    $weekend_txtcolor,$date_bgcolor,
				    $header_bgcolor,$header_txtcolor,
				    $title_bgcolor,$title_txtcolor);
print $end_html = genTable_Footer();
print $end_html = genEnd_HTML();

mysql_close($conn);

?>

</body>
</html>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
chris

Comment:



Comment:

(Maximum characters: 1200). You have characters left.