reverse event calendar

mccoding

HAs anyone ever tried to build an event calendar that displays links on days that do not have anything assigned to them? I want a calendar pretty much like the one for this forum, except display some things when there are no events. Those days will have a link so you can assign something to it. How do I build a calendar and run a query against a database to see if there are any events?

jrolands

do you have a calendar script/function? and if so, post it and i'll try to help u

mccoding

I have two script one is from php event calendar the other is much more simple.

The first one is like a free program that you dl and install yourself. It is probably the complicated to modify. The second one just builds the calendar on the current month. its a doc in a zip, you might have to copy and paste into your favorite php editor.

jrolands

okay, in that script there's this bit of code

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>$day</td>";

inside the IF statement is the code for each of the days that have an event, and in the ELSE part of the statement are the days that have no event attached to them.. so if u do something like this

if(isset($days[$day]) and is_array($days[$day])){
	$calendar .= "<td>$day</td>";
}
else $calendar .= "<td><a href='link.html'>$day</td>";

all the dates that have events will have no link, an the ones that have no event will have one..

mccoding

Ok, thanks for your help so far. I figured out a way to manipulate the calendar.Meaning, I can switch months with no problem.

I need to add a little back story for this app. From this page, when a link is selected it will go to a form and that form will send an email to an admin that will confirm teh date being captured. ex: if they select jan-1-01, the admin will see arequest on date 1-1-01. Once confirmed, the database will be updated and i need the calendar to know that this change has occured. I can run a query to see which days have events assigned to them, but I am unsure how to run that check against the calendar.

Your little fix works good as far as I can see, all the days have a link assigned to them. My query is this :
SELECT FROM Event WHERE Month = $curmonth AND Year = $curyear;
Names and variables are simplified*
That will give me a list of events for the current month. How would I run my query against the calendar?

mccoding

I used the day being generated to run a query. Then I played around with what was returned. Instead of using the given code, I substituted the part that generated the days with conditional statements that fit my needs.