Calendar - Events to span multiple days

CRichardson

I am in the process of developing a calendar application.

At the moment I am trying to find a method which allows events to span over multiple days.

It has already caused many hours of problems!

Has anybody developed anything like this before? Can anybody offer any advice at all?

devinemke

i assume you are using a RDBMS to store the calendar data. furthermore i will assume that each event is a record in that database. i will assume even further that each event record has a field for the start date/time and another for end date/time. if these assumptions are correct then what is the problem? an event could easily start on one day and end on another. for example:

start: 2009-04-29 11:27:12
end: 2009-05-05 16:34:59

CRichardson

devinemke;10912932 wrote:
i assume you are using a RDBMS to store the calendar data. furthermore i will assume that each event is a record in that database. i will assume even further that each event record has a field for the start date/time and another for end date/time. if these assumptions are correct then what is the problem? an event could easily start on one day and end on another. for example:

start: 2009-04-29 11:27:12
end: 2009-05-05 16:34:59

Thank you for your reply.

You are correct in thinking that I have an events table within a database, which has a number of columns, including start date, start time, end date, end time, etc.

Storing and retrieving the information is not a problem.

For example, let's say an event starts on 01/04/2009 and ends on 05/04/2009. I would like to show that information literately and visually spanning over those days.

Should I display my calendar as a table and some how use a number of cells which span the required number of columns? Is it worth layering each event?

Please see attached example for better understanding.

Hope this helps.

devinemke

CRichardson;10912937 wrote:
Should I display my calendar as a table and some how use a number of cells which span the required number of columns? Is it worth layering each event?.

your questions is really more about aesthetics than PHP coding and as such is beyond the scope of this message board.

one thing i will mention that is well within the scope of this board: why are you using 2 separate fields for date and time? you did not mention which RDBMS you are using but i'm sure that it supports a standard DATETIME data type.

CRichardson

devinemke;10912941 wrote:
your questions is really more about aesthetics than PHP coding and as such is beyond the scope of this message board.

one thing i will mention that is well within the scope of this board: why are you using 2 separate fields for date and time? you did not mention which RDBMS you are using but i'm sure that it supports a standard DATETIME data type.

At first glance it may appear that my question is beyond the scope of this message board. However the way in which one retrieves and sorts the data before outputting is very much a PHP matter.

Could you offer any suggestions on how you would go about doing it?

FYI, I am using a MYSQL database.

Thanks again.