111 Responses for "MySQL Calendar"

1. Jamie June 27th, 2007 at 2:01 pm 1

   Bug No: 1
   When changing the month or year then going back to the current date, the colour of the ‘today’ cell does not show up as it is supposed to!

   Jamie.

2. Joe June 27th, 2007 at 3:10 pm 2

   Looking very very nice! The best calendar i have seen. When searching for one with this many easy-to-use features i was sadly disappointed…until now :).

3. Tyr June 28th, 2007 at 2:05 pm 3

   Is there a provision for editing/changing/deleting a calendar event? It wasn’t evident in the demo.

   Thanks! Very nice and compact.

4. Jamie June 28th, 2007 at 2:33 pm 4

   Hi Tyr,
   Yes that will be coming tonight or tomorrow morning, that kinda slipped my mind when i initially put it up, stupid mistake on my part!

   Jamie.

5. Hendra June 29th, 2007 at 1:05 am 5

   Nice script.
   I just had to tweak some think. This is what I tweaked.

   - I remove the login screen on the main page. I just don’t want all my visitor’s will try to connect the admin section.

   -and-

   -I add this on rpc.php
   On line: 176:
   echo ‘There are no events here yet :’ ;
   echo ”;
   echo $day,’-',$month,’-',$year;

   it will display let say if u click 29 june 2007, if there is no event(s) going on, it will display like this:
   There are no events here yet:
   29-6-2007 (Europe date stamp),

   It just handy to know where you click on. A bit usability issue

   I like it I will further tweak you’re script. Hope you don’t mind.

   Hendra

6. Jamie June 29th, 2007 at 7:44 am 6

   Hi Hendra,
   Yea, edit away as long as you post here what you changed so other people can do it..

   I only put the login button on the front part because it was easier for coding and demoing.. but everything in the script is pretty self explanitory so change away!

   Jamie

7. Tony July 3rd, 2007 at 11:17 am 7

   Thx a lot!

   But I have 1 problem. It’s not possible to login. Instead I get a warning:

   Warning: Cannot modify header information - headers already sent by (output started at D:\vhosts\ideintirol.be\httpdocs\tony\simsonscalendar\databaseConnection.php:12) in D:\vhosts\ideintirol.be\httpdocs\tony\simsonscalendar\index.php on line 21

   Thx,

   Tony

8. Rafael July 4th, 2007 at 12:38 am 8

   Es bueno, lo necesito para un sitio web ke estoy desarrollando

9. Jamie July 4th, 2007 at 6:37 am 9

   Hi Tony,
   It sounds like there is something being outputted in the databaseConnection.php file, please ensure that you have not added anything to it.
   Alternativly, it could be that the login details for the database are incorrect, but that should show an error and the script should not load in the first place.

   Let me know if the problem is still happening.

   Jamie.

10. Jamie July 4th, 2007 at 6:38 am 10

    Hi Rafael,

    Let me know what the work for your website is, i am about to start a full-time job so will not have much/any time.

    Jamie.

11. Ditch July 4th, 2007 at 1:41 pm 11

    I also looked at many calendars, and found this one that seemded to fit the bill, however after installing I get all these errors, I had to change add some lines to the index.php whish were if (!isset($_POST['action']))
    {
    // If not isset -> set with dumy value
    $_POST['action'] = “undefine”;
    } any help on the others would be appreciated:

    Notice: Undefined index: nodstrumCalendarV2 in e:\domains\r\revengers.insoma.co.uk\user\htdocs\mysqlCalendar\rpc.php on line 69

    Notice: Undefined index: nodstrumCalendarV2 in e:\domains\r\revengers.insoma.co.uk\user\htdocs\mysqlCalendar\rpc.php on line 123

    Notice: Undefined variable: tTop in e:\domains\r\revengers.insoma.co.uk\user\htdocs\mysqlCalendar\rpc.php on line 152

12. Tony July 4th, 2007 at 4:38 pm 12

    Hey Jamie,

    I still have the same problem. The calendar is loaded but I still can’t login. Line 21 is about creating cookies but that shouldn’t be the problem cause your demo works! But I remarked an error in my database. It says that more options to work with tables are unabled. But I’m not sure what it means.

    Thanks a lot for your reply!!

    Tony

13. Jamie July 5th, 2007 at 6:29 am 13

    Hi Tony,
    I have sent you an email

    I’ll post up the problem and solution for everyone else when it is resolved!

    Jamie.

14. Lou July 5th, 2007 at 8:13 pm 14

    Nice Calendar. A couple issues and requests:

    Password cannot be updated even after changing it from within Control Panel.

    When using a PHP include of your index.php from my pages, it shows up as a blank box. Right now I’m using an iframe and works but would prefer a way to include it on my existing pages, that would be great.

    Last thing is if you can show me how I can force events to show for the current day instead of manually clicking the date? So for example, today there’s 3 events, and the page is loaded with the calendar, it should automatically show the 3 events. That would complete the software.

15. Lou July 5th, 2007 at 8:55 pm 15

    Also forgot to mention on the above comment, how can I switch the display date to MM/DD/YYYY instead of DD/MM/YYYY? Thanks.

16. Antonio July 6th, 2007 at 12:17 am 16

    Heres a message I posted to a web design forum. You’re the only one that I know of that can do something like this. How much money would you charge me for something like this? I’m pretty sure you’ll understand that I am getting at with this…

    “Hey everyone. This task that I’m about to put forth seems kind of meaty. let me see if I can describe what I am looking for.

    I am working on my dads website for his motivational speaking. I need to make a contact form that will have the usual name, email, telephone, etc. I also want to have an option for people to select a date that they would like for my father to speak at their schools. I would like to have a link next to the date field where someone can click the link and a popup calendar will come up, so that they can enter a date that they would like for my father to speak at their school. I’ve also got a link on his website that is schedule.html, where I am going to have a website calendar showing the dates that he is available (the dates that he is busy will be blanked out).

    Heres what I would like to have
    1) I would like for the popup calendar on the contact page match up with the calendar on the schedule page (to avoid miscommunication). In other words, if someone is using the contact page, and they click the “DATE” link, they will see what dates are available and what dates arn’t available…

    2) Also, for the calendar, I want it to be as user friendly on my end as possible (if this is possible).

    Hopefully this makes plenty of sense.

    1) What kind of coding would this entail?
    2) Is there anything available out there that people know of that does what I am looking for?
    3) If there is nothing available, how much will it cost for someone to code something like this for me?

    Thanks

    MD O_o”

    p.s., when people request a certain date through the ‘date’ field, it doesn’t need to edit the calendar, as my dad will have to manually check his schedule to see if it can be done.

    Do you think this kind of thing is possible?

17. Joe July 11th, 2007 at 1:50 am 17

    This is a great calendar and exactly what I need. I’m also having problems logging in and was wondering if someone had discovered the source of this problem. Thanks.

    Warning: Cannot modify header information…

18. Joe July 11th, 2007 at 2:38 am 18

    Ha! Nevermind. It turns out the comments within the databaseConnection.php file were causing the header to be sent before the cookie could be set. Take out the comments and the error should disappear.

19. omarius July 16th, 2007 at 4:13 am 19

    hello,
    nice calendar.
    but there’s one slash in the end-form-tag misssing..

20. Julian July 20th, 2007 at 4:39 pm 20

    Such a shame it’s client-side scripting dependent. Why not do it all server-side?

21. Jamie July 21st, 2007 at 2:14 pm 21

    Julian,
    The reason i have it client side scripted is so that the page does not have to be reloaded, please bare in mind that this calendar is supposed to be used within a page, and therfore i dont want users to have to keep reloading it.

    Jamie.

22. Jamie July 21st, 2007 at 2:15 pm 22

    Version 1.1 is finally here!
    Event Deletion is now implemented!

    Hope y’all enjoy!
    Jamie.

23. Mike August 6th, 2007 at 9:45 pm 23

    First of all nice script, just what i was looking for. Anyway, I try to install and cannot. How do I import the .sql file to create the tables. I am using navicat to modify mysql.

24. Mike August 6th, 2007 at 10:27 pm 24

    I got the tables set up but i now get this error?

    Warning: extract(): First argument should be an array in /nfs/cust/5/7/3/MYDATABASENAME/mysqlcalendar/settings.php on line 7

25. Mike August 7th, 2007 at 3:09 am 25

    Ok, I got my previous 2 problems fixed. Now I cannot seem to add new events. Any suggestions on why? I was able to add one event, now when i try additional events, it drops them after saving?

26. Wolf August 9th, 2007 at 11:53 pm 26

    Very nice calendar!
    Only one question’s left: How I can change the English month-names (January etc.) into German?
    Sorry, I’m a PHP-Newbie

27. Jamie August 10th, 2007 at 9:27 am 27

    Hi Wolf,
    I am planning a minor update this weekend, i will have the months as an Array so you can change them easily into other languages.

    Jamie.

28. Wolf August 10th, 2007 at 12:05 pm 28

    Hi Jamie,
    great! I’m looking forward to it. Your’e doing a real good job.
    Thanks!

29. Jamie McDonnell August 11th, 2007 at 8:15 am 29

    Nice calender, almost exactly what I had in mind for an upcoming project - one question though - are you planning to implement events accross multiple days? for example so I can drag from the 1st to the 5th of January and add an event for the entire duration (for holiday bookings)?.

    Thanks for a great tool otherwise

    Jamie M

30. Vincent August 12th, 2007 at 3:37 am 30

    Perfect! I spend a great deal of time finding an easy booking calendar. I’am finally happy, so Chears on this one!

31. Wolf August 14th, 2007 at 11:11 pm 31

    Hi Jamie,
    just a little question: I’m still trying to use your excellent calendar for my German website. Any idea how to translate the English month names into German?

    Greez
    W.

32. MySQL Calendar - Calendário e Agenda de Eventos : Links Web August 17th, 2007 at 7:37 pm 32

    [...] http://nodstrum.com/2007/06/27/mysql-calendar/ [...]

33. Filipe S August 24th, 2007 at 11:36 am 33

    hi,

    how can i change the language of the days, months from englisg to portuguese?

    i`m a newbie.

    thank`s

34. Jamie August 24th, 2007 at 5:34 pm 34

    Multilingual months support now in V1.2

    http://nodstrum.com/2007/08/24/mysql-calendar-v12-multilingual/

    Jamie.

35. John August 28th, 2007 at 7:17 am 35

    Is there a way to make Sunday the 1st day of the week and have saturday end the week?

36. N8 August 30th, 2007 at 5:53 am 36

    Can’t get it to log in with the default password. The demo works but mine doesn’t.

    Any ideas?

37. Webmorzsák » Blog Archive » 10 naptár CSS, PHP és Javascript alapon August 30th, 2007 at 10:17 pm 37

    [...] MySQL Naptár por Jamie McConnell - ez a legkomolyabb, felhasználók, események, ja és Mysql adatbázis [...]

38. noori August 31st, 2007 at 9:13 pm 38

    hey jamie,

    excellent calendar! but please can u tell me how can i keep the login part just to myself and make the rest of the people see just the events on my site i.e. only I should be able to edit/update/delete events .. rest should just see whts there???

39. Nathan September 1st, 2007 at 7:17 am 39

    Hey Jamie, I think I am having the same login problem that Tony did above. You sent him an email and I don’t think he posted again…I assume it fixed his problem with logging in. If so please let me know what needs to be edited.

40. Gina September 1st, 2007 at 12:56 pm 40

    Is there a version of this calendar that shows the events in the date box i.e. a larger view? If not how whould you go about tweaking this to allow that?

41. Marc September 7th, 2007 at 11:35 pm 41

    I don’t understand this part of the install. What and where does this go?

    “Create your database and import the ‘databaseSQL.sql’ file into it, this will create the default data for running it”

    Thanks, looks great I’d like to get it going.

42. James Cook September 9th, 2007 at 2:23 pm 42

    Hi, is it possible to add more years to the calendar?? it only goes up to 2009. It would just be easier to maintaine if i knew it would last longer.

    Thanks in advance!!

    James.

43. bikeman September 11th, 2007 at 6:10 pm 43

    Nice but it needs the ability to add a table prefix.

    There is currently too much possibility of a table clash and a small script like this doesn’t warrant a dedicated database.

    Hopefully 1.2

44. bikeman September 11th, 2007 at 6:14 pm 44

    James cook,
    just change the following in rpc.php to maintain

    $yStart = 2006;
    $yEnd = ($yStart + 4);

45. Jamie September 12th, 2007 at 12:58 pm 45

    Hi Bikeman,

    Thanks for sorting out James Cooks query!

    Jamie.

46. James Cook September 13th, 2007 at 10:19 pm 46

    ah yes! Thanks very much! i was looking around that area for it but couldnt find it =D

    Just me being blind :p

    Thanks!

    James.

47. Jamie September 14th, 2007 at 11:42 am 47

    Hi James,
    You could do the following… not sure why i have not done it!

    $endDate = (date(”Y”) +4);
    This would mean that the end date would always be 4 years more than the current date.

    As i said im not sure why i did it… i will add it to v1.3

    Thanks to all for your support!
    Jamie.

48. The House Network » Blog Archive » Coding a simple Ajax Calendar with a MySQL backend October 2nd, 2007 at 8:01 pm 48

    [...] Calendar System - Easily using PHP & Script.aculo.usMySQL Calendar [...]

49. Li October 4th, 2007 at 6:25 pm 49

    Excellent calendar!!!!

    It is possible add 1 more color for a different event?

    Exemple: red color for a ‘Reserved’ and Yellow color for a ‘Pre-reserved’?
    (like a hotel reservations)

    Thanks,
    Li

50. matt October 12th, 2007 at 12:59 am 50

    Is the calendar height/width adjustable? Also, can you set a default to make the events for October show (e.g. if it’s Oct 10th, only show Oct 10th and future October events)?

    Thanks,

    Matt

51. Dustin October 12th, 2007 at 4:21 pm 51

    Wow, this is nice!!! I’d like to know if you can tweak it and have the events appear on the Right side instead of right below of the calendar.
    I don’t know if I can have the onmouseover instead of onclick to show the events?

    Also, I don’t see where to log out.

    Thanks for your work!!!

52. Gerard October 16th, 2007 at 9:58 am 52

    This calendar looks great and I’d like to use it only I can’t get it to work.
    -I’ve downloaded the zip file, created the tables and changed the connection string.
    -I can see the calendar and log in and it seems to be working until I try to add and event.
    -The AddEvent button does not work, the IE page states done (but with errors on page:invalid arguement line 86 char 3 index.php) The day does change colour but the event is not stored.
    It’s difficult to debug because the code is all on 1 line after extracting from zip.

53. adiel michaeli October 17th, 2007 at 11:15 am 53

    Very nice script, easy to use,
    it would be good add small editor for adding links.

    ???? ?????,???? ?????,

54. Chris October 18th, 2007 at 5:49 pm 54

    The past webmasters for my school’s site have been searching all over for a good php calendar, and I believe I just found it

    I only have two small issues. When the control panel is activated, it seems to overlap a cell at the bottom of the page. I could just get rid of the cell, but we try to keep everything very uniform.

    Anyway, the second small thing I would like to know is if there is a simple way to switch between a week that starts on monday or one that starts on sunday. Most of our calendars published by the school start on sunday and I’d just like to make it look similar.

    Other than that, it’s really awesome!

55. Nodstrum » Blog Archive » Calendar System - Easily using PHP & Script.aculo.us October 23rd, 2007 at 1:18 pm 55

    [...] THIS HAS BEEN UPDATED, PLEASE SEE THIS POST: http://nodstrum.com/2007/06/27/mysql-calendar/ [...]

56. Ricardo Cappuccio November 16th, 2007 at 12:51 am 56

    Hi Jamie how are you? how can i do to know in wich day i’m standing when for example i press one specific date? i mean, there is a way to know when i press that date that is monday, or tuesday??? i mean in the programming side.

    Thanks, i’ll apprecciate your answer.

    Ricardo.

57. Ricardo Cappuccio November 19th, 2007 at 10:15 am 57

    Hi Jamie, it’s Ricardo again, i’m using your great calendar, it’s so useful, but i need your help for a minute. I just need to know how can i do to know in the programming side in which day i’m standing. I mean if it’s monday how can i now that that day corresponds to monday for example. thanks. I’ll be waiting for your answer.

58. Ricardo Cappuccio November 20th, 2007 at 1:05 pm 58

    After doing some research if you have the same problem that i had, here is the solution:

    Using php functions:
    echo “the actual day is:”.strftime(”Today is: %A”, $timeStamp);

    Whe %A gives you the day, for example: Monday..Tuesday…

    There are other parameters that you can use. Refer to
    http://es.php.net/manual/es/function.strftime.php

59. val November 22nd, 2007 at 10:42 am 59

    if i add event it sim like it is added,but the true the event is not added how can i cant add ah event ,and even i click update color the calendar bcame all white thank you,

60. kris December 4th, 2007 at 6:42 pm 60

    I managed to fix my calendar so that it starts on Sunday instead of Monday however it displays the first day as “0″ which is really the last day of the previous month. How do I get rid of the zero?

    Also, how do you move the Login option to a separate page? I would like my calendar to display with the events but only I have access to change events. Don’t want people trying to hack into with the link to login.

    Thanks; great script!

61. kris December 4th, 2007 at 8:10 pm 61

    I played around with the php and figured out where I went wrong with the ‘0′. Now just need to know how to create a separate page for login so that when the calendar is displayed on the website, visitors do not see a link to login.

    Thanks!

62. Alex December 9th, 2007 at 10:35 pm 62

    Many thanks for this very useful script. Got it going in just a few minutes. Just one question: I can access the calendar when I enter the direct URL (where I uploaded it to) but how can I call or put the calendar into my html document at the spot where I want it to be?

63. Paul Carvill December 15th, 2007 at 9:18 am 63

    Hi there

    Thanks for a great bit of script, I have incorporated into our club site and changed the appearance a little.

    http://www.lincsquad.co.uk/calendar/

64. Ger December 15th, 2007 at 10:42 am 64

    Helo Jamie,
    It likes just great but I mis something very important: the possibility to book from a date to another. When I book a room it is mostley for a week or two.

65. JF January 27th, 2008 at 8:21 pm 65

    Hi,

    i have a problem here:

    Notice: Undefined index: action “..\index.php” on line 4

    it’s about this line but i can understand why…

    $action = $_POST['action'];

    But i see the demo it’s great calendar

66. Robert January 29th, 2008 at 11:18 pm 66

    How can i include this file into another site? i want the calender as my right column of my tree columned site. like:

    Lefcolumn (links), centercolumn (maincontent on site), rightcolumn (integratet calender). you understand?

    regards Robert

67. agung February 4th, 2008 at 8:53 am 67

    Nice calendar. everything work fine!

    However, cannot login. Whenever keyin username & password, then click login, back to login page again.

    Could you advice me please.
    FYI:I manually created & inserted the database on mysql, so I didn’t import the databasesql.sql. I wonder whether it’s an issue.

    Thanks!!

68. Cleibe Souza February 6th, 2008 at 6:41 pm 68

    Has anyone tried to have this calendar working with a link instead of a drop down for month/year?

    If yes, can you please outline your modifications to the script?

    I have it kind’a working but I’m not able to pass the variables as GET instead of POST.

    Thanks

69. Brent February 12th, 2008 at 1:01 am 69

    I love the calender. What a wonderful job. Is there anyway to put the calender inside a webpage? Like a webpage that is alread complete? I want to put the calender in the place of an old calender without displacing anything on the webpage. Thank you for your help.

70. Cleibe Souza February 12th, 2008 at 3:00 pm 70

    @Brent.
    Place this piece of code where you want the calendar to appear. You’ll have to deal with the divs or tables in your page to display it right.

     

    startCalendar(0,0);

71. Cleibe Souza February 12th, 2008 at 3:05 pm 71

    @Brent (again)
    Sorry but the page is interpreting my code and not displaying it. If you download the zipped files, look at index.php.
    The implementation should pretty straight forward.

72. Desen Web » Blog Archive » 10 calendarios con PHP, CSS y Javascript February 14th, 2008 at 4:11 pm 72

    [...] MySQL Calendar por Jamie McConnell [...]

73. Emanuele Destrini February 15th, 2008 at 1:13 pm 73

    Hi Jaime…

    you have made a great job with this script!!
    Finally a truly useful calendar.. anyway I have the same problem with loggin’in that some other people had and I didn’t find out a post to solve tis problem.
    Can you help me with this?

    thanx, Emanuele.

74. Jeroen van Beek February 18th, 2008 at 4:29 pm 74

    This is a great calendar, I’ve been searching quite some time for a good & small calendar and finally found the one! Thanks a lot.

75. Dan February 19th, 2008 at 1:08 am 75

    Hi Jamie,
    Wanted to say awesome script! You did a wonderful job.
    I am having a bit of a problem changing the colors though.
    When I try to change the colors I am presented with php code inside the text field such as

    “<?= $d
    <?= $w
    <?= $t
    <?= $e
    <?= $i
    <?= $i”

    and this prevents me from actually changing anything. I do not see actual color hex values and I’m not sure what’s goin g on.

    Thanks a bunch for your time and help!

76. Jamie February 19th, 2008 at 7:41 am 76

    Hello Dan,
    I have seen this problem before, I hope its the same and fixes it.
    In the index.php page, at the bottom, is the settings form.
    There there are input boxes for the colours.

    In the value=”" tag ensure that it looks like this: < ?= $d; ?> etc for all of the colours.

    In the automatic email I got from your comment it said that there were &lt ;= letters, if that’s the case the resolution I’ve just said will fix it.

    Let me know if it works.

77. AdSense Money Maker March 1st, 2008 at 7:49 pm 77

    AdSense Money Maker…

    Do you know how to make money from AdSense automatically? You don’t!? I’ll teach you how!…

78. Brent March 3rd, 2008 at 1:29 am 78

    Cleibe Souza,

    Thank you for your reply. Sorry it has taken me so long to say thank you, but I have been sick.

    I was wondering if anyone knew how to change the way the month and dates appear. The calendar is set to display this way day/month/year. I was wondering how I would go about changing it to month/day/year. Thank you in advance for anyone who can help me with this problem

79. Raul March 5th, 2008 at 1:36 am 79

    This calendar looks great and I’d like to use it only I can’t get it to work.
    -I’ve downloaded the zip file, created the tables and changed the connection string.
    -I can see the calendar and log in and it seems to be working until I try to add and event.
    -The AddEvent button does not work, the IE page states done (but with errors on page:invalid arguement line 86 char 3 index.php) The day does change colour but the event is not stored.

80. NANA March 6th, 2008 at 3:56 pm 80

    HI!!
    I´VE TRIED YOU CALENDAR AND IT´S VERY GOOD. I JUST WOULD LIKE TO KNOW IF ITS POSIBLE TO CREATE ANOTHE TYPE OF EVENT MORE AND HOW I SHOULD DO IT.

    THANKS A LOT FROM SPAIN!!

81. Starr March 7th, 2008 at 3:01 am 81

    How can I include this into an shtml file that is in a different directory? I tried the code of what would normally work for a php file, but it doesn’t appear to work for this. Here is what I am using:

    Thanks!

82. _matrix_ March 19th, 2008 at 6:31 am 82

    Hi,

    Great script!

    I have been trying to add an edit function into the script with no luck. Am also trying to use different colours depending if the day booked or just the morning or afternoon.

    Does anyone have a edit record solution?;

    Thanks!

83. Ryan March 23rd, 2008 at 3:06 am 83

    Hi Jamie,
    First of all, this is a tremendous script. Love how you’ve integrated AJAX into the whole thing. It runs like a charm.

    I’ve been trying to include calendar onto a page in a different directory on my site, but it seems to mess up the calendar a bit. Do all the connection/setting files need to be in the same directory? Have you come up with an easy way of integrating the calendar into another PHP page?

    Thanks a lot.

84. Ted March 24th, 2008 at 11:04 pm 84

    Hey folks-
    Jamie, thankyou for the brilliant script! its given me many headaches trying to tweak it to my needs, but everything is well documented and eventually I got it to do just what I wanted.

    One aspect I wanted to change that many others here have requested, is to undo your great login code to make it a passwordfree resource. Well I figured out a very easy way to do this by having the program set the cookie it needs from the beginning of the index.php file, then it just took some hiding of the login/cp boxes. Here are the files for anyone interested in the same mod:

    http://www.teddavis.org/calendar/

    Thanks again for this script + hard work!

85. Ted March 25th, 2008 at 12:51 am 85

    One small hiccup..
    On my version of calender, any entry that has a ‘ in it, fails to be posted. I just checked the demo on here and it worked fine.. any idea what might be causing this problem?

86. adam March 25th, 2008 at 4:05 pm 86

    hi
    love your calendar design it will work perfect for a site im working on however when i load the sql script to my data base it sends back an error for ENGINE=MyISAM AUTO_INCREMENT=14 not having proper syntax

    thanks
    Adam K

87. Totos March 27th, 2008 at 3:21 pm 87

    Hello,
    first of all sorry for my english and thanks for this script, it’s very useful and exactly what i need.

    I noticed that it wont work on Internet Explorer (at least on my computer) when you try to add a new event (but it works fine on Firefox). And new events do not appear immediately after adding them.

    I resolved this problem by doing the following :

    -> open the index.php file
    -> find this piece of code :

    function addEvent(day, month, year, body) {
    if(day && month && year && body) {
    // alert(’Add Event\nDay: ‘+day+’\nMonth: ‘+month+’\nYear: ‘+year+’\nBody: ‘+body);
    new Ajax.Request(’rpc.php’, {method: ‘post’, postBody: ‘action=addEvent&d=’+day+’&m=’+month+’&y=’+year+’&body=’+body+”, onSuccess: highlightEvent(day)});
    $(’evtBody’).value = ”;
    } else {
    alert(’There was an unexpected script error.\nPlease ensure that you have not altered parts of it.’);
    }

    // highlightEvent(day);
    } // addEvent.

    and replace it by that :

    function addEvent(day, month, year, body) {
    if(day && month && year && body) {
    new Ajax.Request(’rpc.php’, {method: ‘post’, postBody: ‘action=addEvent&d=’+day+’&m=’+month+’&y=’+year+’&body=’+body+”, onSuccess: displayEvents(day, month, year)});
    $(’evtBody’).value = ”;
    } else {
    alert(’There was an unexpected script error.\nPlease ensure that you have not altered parts of it.’);
    }
    displayEvents(day, month, year);
    }

    You lose the highlighting of the day your are working on (personnaly I dont care, in most cases you dont even notice that), but you win IE compatibility and immediate appearing of events.

    I think this problem is related to the callback of the request. I spent almost 2 hours to find what was wrong :/

    I hope that it will be useful for some of you.

    Something else : like others, I had bugs with “action” and “ttop” variable. I solved that by erasing some lines on the code (it’s very simple, PHP tells you what’s wrong and you delete that, OK it’s not the best way to do that but it works).

    Greetings from France.

88. Rhonda April 2nd, 2008 at 6:51 pm 88

    Hi,

    This is a great calendar my only issue was that I needed to display the events on the current date when the calendar is first displayed. After a little playing around with the javascript I found that by adding this:

    var now = new Date();
    var day = now.getDate();
    var month = now.getMonth();
    var year = now.getYear();
    displayEvents(day, month+1, year);

    in the index.php page after the startCalendar(0,0) call the events for the current day will be displayed on the page load.

89. JAyzee April 12th, 2008 at 9:50 pm 89

    i m getting this error after placing my mysql db user name n password
    “Could not get settings.”

    here is it:
    http://www.jayzee.ej.am/mysqlCalendar_1_2/index.php

90. DeWayne April 13th, 2008 at 2:10 am 90

    Jamie, let’s pretend I’m a very stupid guy and don’t normally do php or mysql things. How do I simply create the initial database file for default display?

91. Jeff April 17th, 2008 at 12:54 am 91

    Hey Jamie,

    It’s been asked, but I never saw the answer on here…

    Any way tpo make Sunday the first day instead of monday?

    Thanks,
    Jeff

92. Brad Watson April 18th, 2008 at 6:06 pm 92

    I get the error “Ajax is not defined” when I try running the callendar… How can this be fixed?

93. Sander April 23rd, 2008 at 1:28 pm 93

    Great calendar, works fine except I have this little problem.
    My date is not showing correctly. It says it’s Sunday 23th of April 2008 but it’s actually (real-time) Wednesday the 23th of April 2008

    How can this be fixed?

94. totos April 23rd, 2008 at 10:31 pm 94

    Hello,
    I would like to answer to some questions.

    First of all, to install the database you need a mysql database interface, like “phpmyadmin”. In most cases your host provides that tool. If you’re testing it locally, easyphp and wamp provide also phpmyadmin.

    To find it, on easyphp you can right-click on the easyphp icon, administration, and in the new window you click on mysql administration. By default, login is “root” and password… you let it empty.

    On Wamp I dont remember but its pretty the same.

    So, you head on phpmyadmin, you create a new database in the main page (just write a name and clic on create). After that, you click at your left on the database name. And on the top of the page, you will see somewhere “import”. You clic on import, and in the new page you can browse your hard drive in order ton find the needed file :

    “databaseSQL.sql”.

    You import this file and that’s it, your database is created !

    After that, you have only to open the databaseConnection.php file and put the settings :

    If you’re using phpmyadmin or wamp, by default you can put these settings :

    $conn = mysql_connect(’localhost’, ‘root’, ”);
    mysql_select_db(’YourDatabase’);

    Juste replace ‘YourDatabase’ by the name of the database that you’ve created.

    For the Sunday being the first day of the week, that’s how it is on Europe As far I’ve seen, if you want to modify that you have to modify the whole code.
    I’ll check that this weekend, and if I can modify that for you I ll send the code here (except if Jamie, the original author, would like to modify that him-self).

    For the other errors, just check what I’ve wrote here, in most cases that’s a misspelling on an error on the settings.

    e.g : excuse me for my english, I think there are a lot of mistakes…

95. Jeff April 24th, 2008 at 7:47 pm 95

    Ok, I have figured out how to change the days from the first day being Monday to the first day being Sunday.

    In the rcp.php file change the order of the day names as follows:

    BEFORE:
    // Display the week days.
    echo ‘Mon
    Tue
    Wed
    Thur
    Fri
    Sat
    Sun’;

    AFTER:
    // Display the week days.
    echo ‘Sun
    Mon
    Tue
    Wed
    Thur
    Fri
    Sat’;

    Then change how it calculates the blanks before the first day:

    BEFORE:
    // Skip some cells to take into account for the weekdays.
    if($i == 0) {
    $firstDay = date(”w”, $fdf);
    $skip = ($firstDay - 1);
    if($skip < 0) {
    $skip = 6;
    }

    for($s=0; $s<$skip; $s++) {
    echo ‘ ’;
    }
    }

    After:
    // Skip some cells to take into account for the weekdays.
    if($i == 0) {
    $firstDay = date(”w”, $fdf);
    $skip = ($firstDay);
    if($skip < 0) {
    $skip = 6;
    }

    for($s=0; $s<$skip; $s++) {
    echo ‘ ’;
    }
    }

96. Jeff April 24th, 2008 at 7:49 pm 96

    sorry, all the html tags were removed above in this post, keep the html tags intact when editing ofcourse.

97. Gerben de G. May 1st, 2008 at 10:41 am 97

    Looks very nice, but i still have a problem, i can not login myself.
    I have already installed everything but when i try to login with admin,admin he returns to the normal index.php and i can log in again and again and again.

    What’s wrong?

98. Crypter June 1st, 2008 at 11:14 pm 98

    Hi..
    Im wondering if anyone can help me..
    i use ur calendar in my website!the only think i have done e take the login in the main pages..
    because i want to put all the admin options in a backoffice.. already protected by a password!but im having a little dificulty to put the options(to change calendar, add events..) open in the admin page!!
    can anyone help me?

99. NoName June 21st, 2008 at 3:52 pm 99

    Somebody hacks my calendar and deletes all the colors settings. Any advise how to block that?!

100. jviney June 27th, 2008 at 2:25 am 100

     How can I re-configure the calendar so that you can add or delete events on the dates ONLY if you are a logged in admin user?

101. jviney June 27th, 2008 at 10:58 pm 101

     I figured out how to change the date format in the rpc.php file. Around line 188, just change the “d” and the “m” into this order:

     Events on: ‘. date(”m”, $timeStamp) .’/’. date(”d”, $timeStamp) .’/’. date(”Y”, $timeStamp) .’‘;

102. Crypter June 28th, 2008 at 12:11 am 102

     nowbody know how to help me?

103. NoName June 28th, 2008 at 5:44 am 103

     Editing events possible? Any diea how to edit events, without using phpMyAdmin? Jamie, are you planing to add such functionality?

104. Hans Werner Castiglioni July 9th, 2008 at 5:46 pm 104

     Hi,
     I have installed the script on my website like the instructions say.
     To login I type the address in my browser and I get a login
     screen when I try to login with admin /admin it comes up the same screen. The address I type is from my website and the directory i installed it, /yascal/mysqlCalendar_1_2/index.php
     Can you help me with that.
     ps. it is not a control panel login screen.

     Kind Regards,

     Hans Werner castiglioni

105. Joe C July 29th, 2008 at 7:25 pm 105

     Can I add more than one user and password?

106. JM August 6th, 2008 at 10:17 am 106

     Excellent.
     Where the 1.2 version ?

107. maga.sys August 6th, 2008 at 10:42 pm 107

     Excelente !!!

108. Zachary August 10th, 2008 at 4:52 am 108

     Can I make more than one user login? Ex. Alot of people want to add somthing to my calender. I don’t have time so thay can do it themselfs. How do I make a login thats not my admin login?

109. Korsakov August 14th, 2008 at 1:26 am 109

     Has anybody tried a more sizable calendar size where you actually see the events listed in the various day windows? Like Google or Outlook?

110. Abudabi August 14th, 2008 at 8:12 am 110

     If backgruond color changed, can be seen white rectangles. How to change rectangles color?
     P.S. this is the best calendar on the net

111. Brentr August 19th, 2008 at 2:05 am 111

     Is there anyway to make the events box word wrap?? If you add an event longer than the width it stretches off the screen? Any way to remedy this please help