Availability Calendar

[aftabn10]

Hi, Does any1 know where I can get a tutorial or a guide as to how to create a Calendar that will allow me to select an availability i.e. Available, AM, PM, Not Available. Any ideas?

 

Thanks in advance.

[A.White.89]

Unfortunately, I do not know of any tutorials.

 

But here is a suggestion:

 

Use a database to hold times for a specific day.

 

Then as you build your calendar, you can dynamically receive those days by database requests.

 

If you understand how to use database requests effectively, you can make this happen

[laffin]

Well hard part is design of the database, as u will need some foresight when building and testing the code.
but you shud know how ya want things.

u should look into MySQL DATETIME formats as will as PHP's time functions.
Building the calander is just a question of wut yer needs are.

So ask yerself wut you need, and that will help design the db for u.
And Remember, you don't need to setup every possible date time combo, you can have flags for the available dates.

[sql]
id as INTEGER PRIMARY KEY NOT NULL,
starttime as DATETIME NOT NULL,
endtime as DATETIME NOT NULL,
comment as text
available as tinyint

 

as a starter sql for an starter

[aftabn10]

Thanks guys for your help. I will let you know how i get on.