PHP/MYSQL Calendar/Event Booking

kennywright10

I am in the beginning stages of writing a script similar to one found here: http://dreamdinners.com/Schedules/Eschedule_may03.htm (This is ASP not PHP) I'm writing in PHP/MYSQL

Their calendar displays an active link if space is available in a class. It is grayed out and inactive if space is unavailable.

I have figured out the simple code for the calendar format, however I am stuck on the concept of how to pass information from the database to areas within the calendar as either active links or inactive text.

Thanks

Kenny

zingbats

What do you want the script to do?

Then we can help more

leatherback

With the risk of stating the obvious:

I suppose you have a way of detecting wether there is space on your calender.

So you can check:

if (ThereIsSpace)
 {
  $Cell1Content = "<a href=\"appointment.php\">Make a reservation</a>";
  }
  else
  {
  $Cell1Content = "Make a reservation";" 
  }

kennywright10

I would like the script(s) to:

a. propogate calendar dates with either (an active link) or text depending on wheter or not there are availbilities for that specific time. (ie. if there are 12 spots for 8:00 p.m. on Tuesday May 20th, and 10 are reserved it will still allow a user to click the link unless the 12 th spot is reserved. At that time the link will become unclickable text, indicating that all spots are filled)

I think that makes sense, but I'm not sure.

Thanks for your help.

Kenny

kennywright10

yeah, I guess my problem is that I don't have to code to extract that information from my database.

Thanks

zingbats

start off with the basics.

Like ummmm getting the data from the database, then printing it in the right place.

We also need to get the structure sorted.

I would have it like this:

Date | Time_start | Time_finish | Event |

1/1/03 | 8.30 | 9.30 | snooker |

etc

Reply with the table details etc and any quetions you have

leatherback

Hi,

It makes sense what you are telling. But there is not really an option to help you without knowing your database setup..

But if you have a specific number of max reservations, you could do a select statement for that specific time:

$query = "select * from table where time = $TimeOfInterest";

and then check for the number of rows:

$numrows = mysql_num_rows($query)

if ($numrows < $maxAppointments)
{
  $Cell1Content = "<a href=\"appointment.php\">Make a reservation</a>";
  }
  else
  {
  $Cell1Content = "Make a reservation";" 
  }

I know this is not the full answer, but as I said.. It is hard to answer without knowing your setup. Hope this helps you to think about the problem though.