jQuery 1.3 With PHP: Calendars

by kae verens on Jun.29, 2009, under ajax, book, javascript, jquery, packt, php, programming, web development, webworks

I was supposed to write about Datatables for chapter 6 of jQuery 1.3 with PHP, but the website of the plugin I was going to use (http://www.datatables.net/) was down for about a week, and so I wrote about Calendars instead.

I used Red3‘s jquery-week-calendar plugin for a recent project in work, and was so impressed I really had to write about it.

In chapter 6 of the book, I’ll walk through how to build a simple calendar, including creation and editing of events, and including once-off and recurring events.

demo

The demo is a session-based calendar, which records only for the duration of your browser session. It’s for demo purposes only, obviously. If you want to use it in a larger project, you would need to adapt the PHP so that it records to a database or files or something.

Download

Here’s an image of it in use:

Only four or so chapters left and then I’m done with the hard part. After that, is rewrites, then you can all throw your money at me.

14 Comments for this entry

Conor
July 3rd, 2009 on 4:45 pm
This calender will prove very usefully for something that I am working on! Thanks for the download!
Rodrigo Ferrari
July 20th, 2009 on 6:32 pm
Thanks a lot for this calendar, I bookmarked it on my delicious! Thanks again!
Max
August 11th, 2009 on 2:34 pm
Nice calendar but how to integrate it with PHP/Mysql?

Thank you.
Kae Verens
August 11th, 2009 on 5:26 pm
@Max – download the files and read them. I’ve used sessions in this case as it’s just a demo. Replace the demo code with database hooks and you are done.
novianto
October 15th, 2009 on 7:41 am
Hi Kae,
I still can’t figure out how to use this with database MySQL, could please show me in brief example?

keep up the good work,
novianto
Novianto
October 15th, 2009 on 7:46 am
Hi Kae,
Nice work you’ve done here
btw, I still can’t figure out how to use this with database MySQL, could please show me in brief example?

keep up the good work,
novianto
Kae Verens
October 15th, 2009 on 10:04 pm
hi Novianto, I don’t have time to write up an example right now, but if you wait until the weekend, I’ll write one up as an article.
Sims
January 28th, 2010 on 5:57 am
Nice week calendar, but how to show week + month calendar?
Rich
February 5th, 2010 on 12:15 am
Hi Kae, i’m really desperate to figure out how to contect to a mysql database with php using this calendar, but like many other people i’ve got no idea how to adapt your session based script to use a database.

please please please can you give an example php script for this?

thanks!

Rich.
sopranoz
February 11th, 2010 on 11:47 am
Grateful if we can have any glue on how to use PHP+MYSQL in this excellent Events Calendar.

Thanks,
rich
February 13th, 2010 on 10:05 am
taps feet, folds arms.
Kae Verens
February 13th, 2010 on 11:15 am
lol! yeah, it would be nice if I had the time!

I /am/ planning on writing up a proper example, but I simply have no time at the moment. Keep tuned.

To be honest, I’m actually surprised I would need to do this – the hard part was the interaction of the calender with the server; the rest is just a matter of saving it in a database. There’s nothing esoteric about it.

I also don’t like going back over old examples. Maybe if I write up an enhancement? For example, this article was about a weekly view, but it would be nice to have it switch to a monthly view on demand.

I do plan on doing this, hopefully this weekend, but I have two paying jobs I need to complete first, and I’m not sure they’ll leave much time afterwards.
Sekhoane Moshabesha
May 9th, 2010 on 12:54 pm
Hi!
@Kae

I have downloaded the plugin and its great. Am using it for a school project but like most of the people i hv looked around for weeks now and still cant figure out how to use it with MYSQL database….

Great work though….

Regards
Ilaiyazhaki
June 21st, 2010 on 6:26 am
This Calendar is very nice.
but how to integrate it with PHP/Mysql? pls inform soon