problems with availability calendar 1

[bezierstek]

I have an availability calendar script that I have written that looks at a database to see if a property is booked for a certain date. Whilst it works fine when the page is first loaded it doesn't seem to pick up the booked dates from the database. If I go back a month then forward again the data is picked up fine.

Can some one have a look at the code and see if they can figure out why it isn't working when initially loaded.

function generate_calendar($year, $month, $days = array(), $day_name_length = 3, $month_href = NULL, $first_day = 0, $pn = array()){
	$first_of_month = gmmktime(0,0,0,$month,1,$year);
	#remember that mktime will automatically correct if invalid dates are entered
	# for instance, mktime(0,0,0,12,32,1997) will be the date for Jan 1, 1998
	# this provides a built in "rounding" feature to generate_calendar()

	$day_names = array(); #generate all the day names according to the current locale
	for($n=0,$t=(3+$first_day)*86400; $n<7; $n++,$t+=86400) #January 4, 1970 was a Sunday
		$day_names[$n] = ucfirst(gmstrftime('%A',$t)); #%A means full textual day name

	list($month, $year, $month_name, $weekday) = explode(',',gmstrftime('%m,%Y,%B,%w',$first_of_month));
	$weekday = ($weekday + 7 - $first_day) % 7; #adjust for $first_day
	$title   = htmlentities(ucfirst($month_name)).'&nbsp;'.$year;  #note that some locales don't capitalize month and day names

	#Begin calendar. Uses a real <caption>. See [URL unfurl="true"]http://diveintomark.org/archives/2002/07/03[/URL]
	@list($p, $pl) = each($pn); @list($n, $nl) = each($pn); #previous and next links, if applicable
	if($p) $p = '<span class="calendar-prev">'.($pl ? '<a href="'.htmlspecialchars($pl).'">'.$p.'</a>' : $pn).'</span>';
	if($n) $n = '&nbsp;<span class="calendar-next">'.($nl ? '<a href="'.htmlspecialchars($nl).'">'.$n.'</a>' : $n).'</span>';
	$calendar = '<table class="calendar" >'."\n".
		'<caption class="calendar-month">'.$p.($month_href ? '<a href="'.htmlspecialchars($month_href).'">'.$title.'</a>' : $title).$n."</caption>\n<tr>";

	if($day_name_length){ #if the day names should be shown ($day_name_length > 0)
		#if day_name_length is >3, the full name of the day will be printed
		foreach($day_names as $d)
			$calendar .= '<th abbr="'.htmlentities($d).'">'.htmlentities($day_name_length < 4 ? substr($d,0,$day_name_length) : $d).'</th>';
		$calendar .= "</tr>\n<tr>";
	}

	if($weekday > 0) $calendar .= '<td colspan="'.$weekday.'">&nbsp;</td>'; #initial 'empty' days
	for($day=1,$days_in_month=gmdate('t',$first_of_month); $day<=$days_in_month; $day++,$weekday++){
		if($weekday == 7){
			$weekday   = 0; #start a new week
			$calendar .= "</tr>\n<tr>";
		}
		if(isset($days[$day]) and is_array($days[$day])){
			@list($link, $classes, $content) = $days[$day];
			if(is_null($content))  $content  = $day;
			$calendar .= '<td'.($classes ? ' class="'.htmlspecialchars($classes).'">' : '>').
				($link ? '<a href="'.htmlspecialchars($link).'">'.$content.'</a>' : $content).'</td>';
		}
		else $calendar .= "<td class=\"calendar1\">$day</td>";
	}
	if($weekday != 7) $calendar .= '<td colspan="'.(7-$weekday).'">&nbsp;</td>'; #remaining "empty" days

	return $calendar."</tr>\n</table>\n";
}
?>
<?php


$datecheck=getdate();
if (!isset($dismonth)){
	$dismonth=$datecheck['mon'];
	}


$sql=mysql_query("select * from calendar ");
while ($result = mysql_fetch_row($sql)){

$datepieces= explode("-",$result[2]);
$datemonth=(int)$datepieces[1];
$dateyear=(int)$datepieces[0];
//echo $disyear ;


//newcode
if($dismonth>12){
$checkmon=$dismonth-12;
$checkyr=$disyear+1;
}else{
$checkmon=$dismonth;
$checkyr=$disyear;
}

//echo "dismonth: ".$dismonth." disyear: ".$disyear;

if ($result[3]=="B" and $datemonth == $checkmon and $dateyear == $checkyr){
$dateday=(int)$datepieces[2];
$days[$dateday] = array('','booked-day','B');
}

}
if (!$today){
$today = getdate();
$todayyear = $today['year'];
$todaymonth=$today['mon'];
$todayday=$today['mday'];
}
else {
$todaymonth++;
}

    
 
 if (isset ($dismonth)){
 $todaymonth=$dismonth;
 $nextmon=$todaymonth;
 $nextmon++;
 $prevmon=$todaymonth -1;
 $premonurl="?dismonth=".$prevmon ."&disyear=".$todayyear;
 $nextmonurl="?dismonth=".$nextmon ."&disyear=".$todayyear;
 
 }else{
 $todaymonth = $today['mon'];
 $nextmon=$todaymonth;
 $nextmon++;
 $prevmon=$todaymonth -1;
 $premonurl="?dismonth=".$prevmon;
 $nextmonurl="?dismonth=".$nextmon;
 }
$pn = array('&laquo;'=>$premonurl, '&raquo;'=> $nextmonurl);

//echo "year: ".$todayyear." month: ".$todaymonth. " day: ".$days;
    echo generate_calendar($todayyear, $todaymonth, $days, 3, NULL, 0, $pn);

 

[jpadie]

i would attack the process the other way around. for each day that you are about to output, perform a query limited to that day and output the results.

i suspect your code is going wrong in the date creation function for the initial state.

 

[bezierstek]

Thanks for that. I can't believe I was going about it in such a longwinded way.

Works great now.

Richard