Calendar Generation from the Database Example

Calendar Generation from the Database Example

<php
function get_events($calendar) {
	$events = array();
	$query = "select * from calendar_data order by date";
	$res = mysql_query($query) or die("Can't get data from database!");
	while ($rs = mysql_fetch_array($res)) {
		$events[date('m/d/Y', strtotime($rs["date"]))] = $rs["event"];
	};
	$eventshtml = "";
	foreach($events as $k => $v)
		$eventshtml .= "$calendar.setLink(\"$k\", 'javascript:alert(\"$v\");');\n";
	return $eventshtml; // linked events
};
echo '<html><head>' .
	'<link href="ctc.css" rel="stylesheet" type="text/css">' .
	'<script language="javascript1.2" src="' . site_url . 'codethatsdk.js"></script>' .
	'<script language="javascript1.2" src="' . site_url .
	'../script/codethatcalendarpro.js"></script>' .
	'</head>';
?>
<script language="javascript1.2">
<!--
var caldef1 = {
	firstday : 0,
	dtype : 'MM/dd/yyyy',
	width : 250,
	windoww : 300,
	windowh : 170,
	border_width : 0,
	border_color : '#0000d3',
	dn_css : 'clsDayName',
	cd_css : 'clsCurrentDay',
	tw_css : 'clsCurrentWeek', // CSS for current week
	wd_css : 'clsWorkDay',
	we_css : 'clsWeekEnd',
	wdom_css : 'clsWorkDayOtherMonth',
	weom_css : 'clsWeekEndOtherMonth',
	highlight_css : 'clsHighlight',
	headerstyle : {
		type : "buttons",
		css : 'clsHighlight'
	},
	monthnames : ["January", "February", "March", "April", "May", "June",
		"July", "August", "September", "October", "November", "December"],
	daynames : ["Su", "Mo", "Tu", "We", "Th", "Fr", "Sa"],
	img_path : 'img/',
	template_path : ''
}; 
//-->
</script> 
</head>

<body bgcolor="#ffffff">
  <form>
    <input type=text id=id1>
  </form>

<script language="javascript1.2">
<!--
var c1 = new CodeThatCalendar(caldef1);
<?php print(get_events("c1")); ?>
c1.create(document, "id1"); 
//-->
</script>

</body>
</html>