How to create a dynamic calendar with MySQL, PHP etc.

Question

Hi,

I am looking to create a calendar based on some pre-existing event entries. I currently have a event creation system using MySQL and PHP. However, I can only list these in an agenda format, sorted by soonest event.

Is there some existing method of creating a monthly calendar based on events in a database? I have little coding experience, so I don't think I would be able to create my own calendar system, but with some coding help, I might be able to piece something together.

My preferred end result would be to have a calendar with the event titles in the correct day (trimmed down to fit, possibly), with a link to the event page, and on hover, tooltip-like popup (I have something already implemented in the agenda.) Also, I would be willing to use PHP, MySQL, Javascript, or Jquery technologies, as I already have those on my server.

Thanks

Answer 1

You need to break this project down. First, determine your needs and design a database to meet them. For calendars, I prefer to have a table of events, and then a separate table storing the occurrences of those events. This allows for events that repeat. For instance, if I have an event every Monday for the next 10 days, then I will have 10 occurrences in the occurrences table and one event in the events table. Now, the problem with this is that it isn't possible to represent events that repeat infinitely. In my experience, it is better for the user to actually choose an end date, but depending on your application, your users may not like that.

Once you have that database set up, then you can work on the interface.

Answer 2

Almost no coding experience and you want to create a calendar like that? I think you should have a look at google calendar and use there API to add events dynamically.