Page 1 of 1

Time slot booking calendar

Posted: Mon May 23, 2011 11:51 pm
by Jim_Bo
Hi,

I am wanting to come up with a simple php/mysql time slot booking calendar that I can intergrate with my client database.. and see at a glance which slots are free when selecting calendar dates.. Does anyone know of a tutorial for this kind of calendar or can help me get on the right track?

Cheers

Re: Time slot booking calendar

Posted: Tue May 24, 2011 1:37 pm
by Jade

Re: Time slot booking calendar

Posted: Tue May 24, 2011 3:59 pm
by Jim_Bo
Thanks jade, but im not after an over bloated calendar script that I cant modify as things grow.. Am wanting to create my own simple version that only does exactly what I need.

I have allready programmed my calendar with clickable dates etc.. Im just after some insite on the best way to create and store the data below.

There will be half hour slots from 8am - 5pm.. When a day gets selected, below the calendar have check boxes apear for each time slot.. when a time slot is selected and submited I want to add a client and insert the taken time slot with the date and userid into the database. When the same day is selected again the time slot taken will be selected allready shown the slot is taken.

I allready have the customer database built. So wondering what the best plan of attack to create the above solution?

Cheers

Re: Time slot booking calendar

Posted: Wed Jun 01, 2011 4:56 pm
by Jade
So why reinvent the wheel? Look at some other free calendar software to see how they're doing it. My guess is most of them are use a database to store the time slot information and then querying the database to pull out which time slots are free or taken already into an array. Then you can generate the calendar by checking it against the array.