All pastes #833445 Raw Edit

Anonymous

public text v1 · immutable
#833445 ·published 2007-12-27 06:58 UTC
rendered paste body
function sCalendar($year, $month, $day_offset = 0){
	$days = array("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday");
	$months = array("january","february","march","april","may","june","july","august","september","october","november","december");
	$day_offset = $day_offset % 7;
	$start_day = gmmktime(0,0,0,$month,1,$year);
	$start_day_number = date("w",$start_day);
	$days_in_month = date("t",$start_day);
	$final_html .= "<table align=\"center\" width=\"700px\" border=\"1\">\n<tr align=\"center\"><td colspan = \"7\"><strong>".strtoupper($months[$month-1])." $year</strong></td></tr>\n";
	for($x=0;$x<=6;$x++){
		$final_html .= "<td align=\"center\" width=\"100px\" bgcolor=\"#F0F0F0\"><strong>".$days[($x+$day_offset)%7]."</strong></td>";
	}
	$final_html .= "</tr>\n";
	$blank_days = $start_day_number - $day_offset;
	if($blank_days<0){$blank_days = 7-abs($blank_days);}
	for($x=0;$x<$blank_days;$x++){
		$final_html .= "<td align=\"center\">&nbsp;</td>";
	}
	for($x=1;$x<=$days_in_month;$x++){
		if(($x+$blank_days-1)%7==0){
			$final_html .= "</tr>\n<tr>";
		}
		$row_count = sappointmentCheck($month,$x,$year);
		if($row_count == 0){
		$final_html .= "<td align=\"center\">$x</td>";
		} else {
		$final_html .= "<td bgcolor=\"#FFFF00\" align=\"center\"><strong><a href=\"view_details.php?month=$month&day=$x&year=$year\">$x</a></strong></td>";
		}
	}
	while((($days_in_month+$blank_days)%7)!=0){
		$final_html .= "<td>&nbsp;</td>";
		$days_in_month++;
	}
	$final_html .= "</tr>\n</table>";
	return($final_html);
}

function sappointmentCheck($cmonth,$cday,$cyear){
$query = "SELECT * FROM appointments WHERE (month='$cmonth' && day='$cday' && year='$cyear')";
$run_it = mysql_query($query) or die(mysql_error());
$result_int = mysql_num_rows($run_it);
return $result_int;
}