jQuery 1.3 With PHP: Calendars

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.


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.


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.

Leave a comment ?


  1. Daily Digest for 2009-07-02 | Pedro Trindade - pingback on July 3, 2009 at 8:06 am
  2. This calender will prove very usefully for something that I am working on! Thanks for the download!

  3. Thanks a lot for this calendar, I bookmarked it on my delicious! Thanks again!

  4. Nice calendar but how to integrate it with PHP/Mysql?

    Thank you.

  5. @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.

  6. 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,

  7. 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,

  8. 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.

  9. Nice week calendar, but how to show week + month calendar?

  10. 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?



  11. Grateful if we can have any glue on how to use PHP+MYSQL in this excellent Events Calendar.


  12. taps feet, folds arms.

  13. 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.

  14. Sekhoane Moshabesha


    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….


  15. This Calendar is very nice.
    but how to integrate it with PHP/Mysql? pls inform soon

  16. This Calendar is very great
    but how to integrate it with PHP/Mysql for persistence data ?

  17. Thanks for this calendar.. i have successfully integrated it to my mysql database using simple json and PHP.

  18. Hello,

    please spent a minute , and answer us how to connect your jquery calendar with mysql database.

    Thank you!

Leave a Reply

Trackbacks and Pingbacks:

%d bloggers like this: