View Full Version : appointment help

10-30-2007, 10:16 PM

i've been asked by someone to help them with their website by creating an apointment bookings system for it, but am not sure where to start.

what they need is a way for someone to come onto the site and book an apointment at an available timeslot. i was thinking this could be done using php and mysql, but am not sure where to begin.

they need it so that when someone clicks on a date, all available timeslots are shown, and they can fill in their details and book the apointment, but i'm not sure how to do this. i'm not looking for someone to give me some code, but to help me to:
a) decide if php/mysql is the best option (it's all i have knowledge of apart from html)
b) figure out the processes i would need to go through in a step by step way in order to get the code to work.

can anyone offer me any help?

10-30-2007, 10:56 PM
I know this is sort of a lame answer ...

What you're doing is going to be a huge project for an experienced
PHP/MySQL programmer. I can only speak for myself that I would
never do something that large for free.

With that said, a Google search finds many pre-made scripts...
some free, some for a fee. Any of them could be customized for
your particular use, depending on the features you need.

Here's a list of many options:

10-30-2007, 11:23 PM
thanks for the speedy response, much apreciated.

just a couple of quick points here,
the website isn't for a commercial business, so it isn't overly important to him if i can come up with some sort of work around for him, also he only wants to take appointments for 1 month at a time, and on certain days, so was wondering whether the following would work.

if i created a php script which he could update once per month with the following months appointment times, and store those in a database, and then have a page which the user would see which has a listbox or some other way of chosing a date along with a "check availability" button, which would then reload the page with records which are not yet allocated (e.g. are blank in the name field), and then allow the user to fill in their details and click book, would this work, or is there a huge flaw that i'm missing.

obviously security is an issue here, but as long as there is some sort of password/username system in use, would this work?

thanks for the help

10-30-2007, 11:30 PM
There are all sorts of Calendar scripts out there already that do exactly what you want. No need to re-invent the wheel.
Yahoo! Calendar for example might work out of the box by setting the calendar to public. Not sure, haven't used it for awhile.
The better ones apply the vCalendar format (I think it is) so you can migrate the data between different calendars. Mozilla Sunbird is good, too, and uses that format.