VERSION 1.1 RELEASED!
Changes: Added (by popular demand) Event deletion!
Ok… I have finally got this script working!
I have not done it like a tutorial because it is just too big, so here are a load of screen shots, There is a link to a fully functional demo and zip at the bottom!
A little setup information:
1. Copy the entire calendar into whatever directory you want.
2. Create your database and import the ‘databaseSQL.sql’ file into it, this will create the default data for running it.
3. Alter the ‘databaseConnection.php’ file to show your connection details.That should be it..
NOTE:By default the username and password are both ‘admin‘ (without the quotes), i suggest you change your password in the control panel.
If you have any problems i will be happy to help, just post your query as a comment to this page.
Screen Shots
Default View

View Events

View Events 2

Login

Control Panel

Add Event

Add Event 2

Downloads









240 Responses for "MySQL Calendar"
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.
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
.
Is there a provision for editing/changing/deleting a calendar event? It wasn’t evident in the demo.
Thanks! Very nice and compact.
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.
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
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
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
Es bueno, lo necesito para un sitio web ke estoy desarrollando
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.
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.
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
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
Hi Tony,
I have sent you an email
I’ll post up the problem and solution for everyone else when it is resolved!
Jamie.
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.
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.
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?
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…
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.
hello,
nice calendar.
but there’s one slash in the end-form-tag misssing..
Such a shame it’s client-side scripting dependent. Why not do it all server-side?
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.
Version 1.1 is finally here!
Event Deletion is now implemented!
Hope y’all enjoy!
Jamie.
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.
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
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?
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
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.
Hi Jamie,
great! I’m looking forward to it. Your’e doing a real good job.
Thanks!
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
Perfect! I spend a great deal of time finding an easy booking calendar. I’am finally happy, so Chears on this one!
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.
[...] http://nodstrum.com/2007/06/27/mysql-calendar/ [...]
hi,
how can i change the language of the days, months from englisg to portuguese?
i`m a newbie.
thank`s
Multilingual months support now in V1.2
http://nodstrum.com/2007/08/24/mysql-calendar-v12-multilingual/
Jamie.
Is there a way to make Sunday the 1st day of the week and have saturday end the week?
Can’t get it to log in with the default password. The demo works but mine doesn’t.
Any ideas?
[...] MySQL Naptár por Jamie McConnell – ez a legkomolyabb, felhasználók, események, ja és Mysql adatbázis [...]
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???
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.
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?
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.
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.
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
James cook,
just change the following in rpc.php to maintain
$yStart = 2006;
$yEnd = ($yStart + 4);
Hi Bikeman,
Thanks for sorting out James Cooks query!
Jamie.
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.
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.
[...] Calendar System – Easily using PHP & Script.aculo.usMySQL Calendar [...]
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
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
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!!!
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.
Very nice script, easy to use,
it would be good add small editor for adding links.
???? ?????,???? ?????,
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!
[...] THIS HAS BEEN UPDATED, PLEASE SEE THIS POST: http://nodstrum.com/2007/06/27/mysql-calendar/ [...]
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.
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.
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
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,
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!
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!
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?
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/
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.
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
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
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!!
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
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.
@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);
@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.
[...] MySQL Calendar por Jamie McConnell [...]
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.
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.
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!
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 < ;= letters, if that’s the case the resolution I’ve just said will fix it.
Let me know if it works.
AdSense Money Maker…
Do you know how to make money from AdSense automatically? You don’t!? I’ll teach you how!…
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
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.
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!!
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!
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!
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.
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!
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?
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
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.
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.
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
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?
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
I get the error “Ajax is not defined” when I try running the callendar… How can this be fixed?
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?
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…
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 ‘ ’;
}
}
sorry, all the html tags were removed above in this post, keep the html tags intact when editing ofcourse.
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?
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?
Somebody hacks my calendar and deletes all the colors settings. Any advise how to block that?!
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?
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) .’‘;
nowbody know how to help me?
Editing events possible? Any diea how to edit events, without using phpMyAdmin? Jamie, are you planing to add such functionality?
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
Can I add more than one user and password?
Excellent.
Where the 1.2 version ?
Excelente !!!
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?
Has anybody tried a more sizable calendar size where you actually see the events listed in the various day windows? Like Google or Outlook?
If backgruond color changed, can be seen white rectangles. How to change rectangles color?
P.S. this is the best calendar on the net
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
Cool! This is an awesome script
Great calendar, just what I want.
It is working fine on the default index.php page.
I am really struggling to integrate it into my existing site.
Can anyone tell me what I need to put in an existing div to display the calendar just like in index.php (I like the size colours and everything)?
I have cut and pasted all the code from index.php into my page (in the appropriate places) and I get a weird calendar with all the days of the week underneath each other and then all the dates underneath that. My containing div is 300px wide so it should be big enough.
TIA.
Finally got it sorted. Needless to say it was a Div and CSS issue.
There have been several comments above about removing login from the calendar so that the db can be managed alternatively. I have looked through the code but cannot see where the login link actually come from. Can someone kindly point me in the right direction?
TIA
Finally found it. It is on line 92 of rpc.php. Just delete the word login and that’s it you don’t actually need to delete any other code. You will need another rpc.php elsewhere on your site to use with any page where you want to enable the login function.
To add a little bit back to this great bit of code I have created an add user page, that allows you to add multiple users to the database. It is available to download from http://turnspain.com/add.zip. Please note that there is no protection on this form so it should be protected by .htacccess or in some other way. I hope that it helps someone else to make use of this calendar.
[...] Jamie, che da oggi terremo d’occhio, per un calendario personalizzabile creato in php su database MySql. Usa anche prototype e scryptaculous per l’interazione con il [...]
The calendar works on its own page, but I can’t get it to display inside of another page. I have tried adding the script of startCalendar(0,0); but nothing shows up inside the table cell. I also tried a php include, but got a ‘could not get settings error’ Any suggestions?
Mike, It works fine for me on my own page. You need the php code from the demo page right at the beginning of the page before any HTML. You then need the two script source lines along with the two embedded css styles and the ajax functions in your head section. You then need all the form code in the div on your page where you want the calendar displayed and finally you need to call the calendar after the rest of the code on your page.
That is what I did and it works fine, you can see it at http://www.u3avalldelpop.com.
Jamie,
Great calendar. I’ve been looking for something like this for a long time. This is perfect for my needs. Well done and very honorable of you to share it with us.
One request: Is there a way to indicate the current day? Perhaps a heavier border around the cell or different text color?
Thanks.
Sorry, I missed the “today color” setting in the control panel.
Is it possible to have a heavier border to indicate the current day?
Hello! Thank you very much for this cool script.
This was exactly what i was looking for.
I would like to donate some $ to you, how can i do that? You got paypal?
greets.
Hi,
i have a simple website where i tried to add the calendar.
in a i used the code like :
=======================
=======================
Now this doesnt work.. can you please tell me how should include the file to run in a table?
en server linux ….error!!!!! user and password incorrect ?….please help…
Hi…is it possible to remove the login functions from the my_sql calendar? instead of making the login word appear at the top right hand corner, i tried to make the control panel appear directly by deleting the codings for log in, however, both the log in and control panel did not appear.
Could you please give me a solution to the problem? maybe by telling me which other page should i edit to get rid of the log in function?
HAHA i finally manage to cross the entire log in and combine it with my website…hehe Thanks Jamie!!
Alguem poderia me ajudar. Meu calendario esta dando esse erro. Nao sei oq aconteceu, só sei que o servidor atualizou o php
olha ai o link do erro http://www.iptassu.com.br/calendario_new/index.php
Good calendar. I’ve used it several times and have done some modification such as to display month/day/year (American Style) and some other things. I’ve also added to the database to store national holidays and then display them in a different color than event days.
This is a completely customizable calendar and I highly recommend its use.
Merry Christmas!
Hi,
Great calendar, i am goign to be using it for a rent a villa website that i am creating.
What is the easiest way to have a 2nd event in the calendar to differ from the 1st event
Best place for free blank calendars http://www.blankcalendar.info
http://www.blankcalendar.info/
hi
z4wt2smc4ymejhxl
good luck
Does anyone know how to allow separate users of this calendar on the same web page such that each user’s events are specific to that user based on their login?
I tried a couple times and couldn’t figure it out. It goes beyond just login/database changes. There are necessary coding changes and probably in the javascript which I don’t fully understand.
Thanks for any help on this.
SECURITY ALERT : Admin password is replace by another password without verification of user identity if anyone use simple homemade formular.
DEMO exemple is protected only by your auto replace password at each page demand.
Sorry for my bad english but I am a french webmaster
Thought some may be interested in my iteration of this app. I have customized it in may ways too numerous to mention. However, here are some of the major bullet points:
2.) Added a table for holidays. These are for official US secular holidays. This talbe also includes the ecclesiastical holidays of Easter and Ash Wednesday. Also added Mardi Gras.
Opted for the use of images for a background to the cell containing either a holiday, an event or today.
3.) Opted for Tool Tip type of descriptions each of the 3 types of special days described in 2.) above.
These are the major enhancements. There are many others, but are of less importance.
Feedback is encouraged.
I have been looking for something like this for a long time. Great stuff you have come up with.
My problems is i am learning php/mysql, i notices after i worked through the code you provided i am supposed to login so this means there has to be a registration/sign in form, this is not provided, though i can work away through that.
then i do not want just anyone to post an event on the calender, how can i prevent or avoid that?
Thanks once more and Good luck
[...] here, you might want to subscribe to the RSS feed for updates on this topic.Powered by WP Greet BoxFree Calendar with MySQL and Script.aculo.us has 3 main parts, the Javascript, the HTML and the PHP script. You can change the date with the [...]
Download link don’t work for me …too bad …
[...] ? Calendar System? Calendar system e ??? ???????? ??????? ?? MySQL Script.aculo.us ??????? ? ??? [...]
Hi. I am fairly illerate to this type of file. I want it located in a school webpage. I pulled the file into the folder needed, but beyone that…I am totally lost. I don’t know what to do with the database or where it is. HELP ME!
Hi, I found it cool but errors kept cropping up. It worked for the first time but later posted an error that “Could not get settings.” I did not change settings. is there any thing wrong about my web server? Am using XAMP
Regards
Someone can tell me how store and retrive date event from the database in date format instead of timestamp?
Matteo:
You need to read up on the php function date(). I has many was to format the output desired. I show one example below:
Today’s unix timestamp is 1235023200. If I used the following php code:
echo date(‘j F, Y’, 1235023200);
then the output would be “February 19, 2009″. Really cool, huh?
I would like to add this calendar to my site http://vspotlight.com. i would like to have it show on the members account page and have it so that all members have there own calendar and have it automaticaly log them in when they log into their account.
I would also like to give members the ability to post it to their page for other members to see
thank you for your help
Kevin
this is a very great calendar Jamie. Congratulations. But now I have a problem, when I type colors in the control panel in the change color menu, no change has been made. please tell me how to fix that. once more, congratulations!
I am getting this error.
Notice: Undefined index: action in C:\school\ tests\Calander.php on line 152
Whoops.
I am guessing that $action = $_POST['action']; the ‘action’ is confusing it, so it drops to the default case. I would be greatful for any help.
YOU ARE A GENIUS. That’s a brilliant piece of work man. Keep the fire burning
Hello,
I love this calendar but i’ve some problems
look at this : http://darkscythe.free.fr/perso/calendar.png
Can someone help me please???!!!!
thanxxx
Sabrina,
it looks like you need to chmod some files
I don’t believe because all my files are editable by everyone.
Can you tell me an approach to make this.
Thanks a lot for answering me.
I would include this in a new page but It doesn’t work. There is some explanation higher in the comments but in english. So, if someone could explane in french, or in english but with other words, it would be great! I could maybe understand better! Thx!
Very good script!
I’ve understood after one or two hours of hard working! No problem anymore!
Can someone help me to resolv my problem ? =(
http://darkscythe.free.fr/perso/calendar.png
thanx
Salut Sabrina!
Tu es sur easyphp? En local, parfois ce genre de problème surgit. Mais une fois sur la toile, rien de tout ceci.
Sinon, je ne peux guère t’aider plus, je suis plutôt du genre à demander de l’aide qu’à en donner dans ce domaine^^
Bonne continuation!
Merciiiiiiiiiii !!!
Je m’obstinais à essayer en local avant de le mettre sur le site! J’avoue que c’est tout bête mais il fallait y penser ! Merci beaucoup
et oui j’utilise EasyPHP et je ne savais pas que cela pouvait poser ce genre de problème! Je me coucherai moins bête ce soir.
Encore merci ;o)
I’ve got a new problem!
When I add for example :
“asdfasdfasdf”
It works.
When I add :
“Menu de St-Martin au son de l’accordéon. Merci de réserver d’ores et déjà votre table. Au plaisir de vous accueillir. ”
It doesn’t work!
It seems that the ‘ – é à in french are a problem. How can I change that?
Thx you.
The problem was the ‘
So the addslashes fonction had a F in the variable (?!!). So I deleted it and it Works. Amazing. Sorry for my multiposts!
$bodyF = addslashes(trim($body));
je pense que c’est parce qu’il faut mettre des ” ” entourant à la place des ‘ ‘ car dans le d’ores et déjà il y a un ‘ et donc le code ne sait pas ou est la fin
j’ai eu ce problème la en tout cas.
Merci Sabrina!
J’avais trouvé le souci, c’était la fonction addshlash qui ne jouait pas, comme je l’ai écrit juste en-dessous.
@+
I have the exact problem as Dan did, the form is filled with
etc instead of the hex. The fix didn’t fix it.
Jake:
Not all php on servers recognize this syntax:
I found this out the hard way because I had a project that worked just fine locally and on test server using this short cut syntax. I had to use the proper syntax on the production server and from then on I never used the shourcut.
Proper syntax:
Hope that helps
Well where did the code go?
I’ll have to use the html character codes.
Do not use: <?=$something; ?>
Use: <?php echo $something; ?>
When I open webpage that I made including MYSQL calendar. I see the following error message on the top of webpage.
Warning: Cannot modify header information – headers already sent by (output started at C:\xampp\htdocs\IT\Calendar\index.php:4) in C:\xampp\htdocs\IT\Calendar\index.php on line 24
The line 24 in my code is
setcookie(‘nodstrumCalendarV2′, ‘1′, time()+3600); // Cookie will expire in 1 hour.
Can anyone help me to solve this problem?
Many thanks,
Nice script if i can get it to work they way i need it.
bascially the calendar is a included php file rather than embedded directly into the top page
toppage.php
|__________>
as sort of expected there are proably filepathing errors however the one i am getting is ajax is undefined
Any help or suggestions would be appreciated.
Cheers
in the index.php page
function startCalendar(month, year) {
new Ajax.Updater(‘calendarInternal’, ‘/calendar/rpc.php’, {method: ‘post’, postBody: ‘action=startCalendar&month=’+month+’&year=’+year+”});
}
and
thanks
the admin login returns a 404 error – so what page or filepath is it trying to display?
who change backgrpund colours?
This really looks great! But I can’t login.. When i enter the standard login & passw. and press Login, i just return to the index page, with the ‘login-button’ in the right-upper corner.. Can someone pls help!?
Figured it out! The cookie wasn’t set.. I’ve tried everything, and found out that 3600 is to short.. changed it to $COOKIE = setcookie($CookieName, $CookieNumber, time() + 36000);
and it worked!
It would be nice I have an option to EDIT. Today has just include or delete. If you need a fix, I have to erase everything and do it again. Someone help me to include this option? Thank you.
Notice: Undefined index: action in C:\Programmi\EasyPHP 3.0\www\Web\index.php on line 4
Notice: A session had already been started – ignoring session_start() in C:\Programmi\EasyPHP 3.0\www\Web\config.php on line 3
Notice: Undefined variable: conn in C:\Programmi\EasyPHP 3.0\www\Web\settings.php on line 5
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in C:\Programmi\EasyPHP 3.0\www\Web\settings.php on line 5
Could not get settings.
i’ve resolved many problems but remains:
Notice: Undefined index: action in C:\Programmi\EasyPHP 3.0\www\Web\index_calendario.php on line 4
Notice: A session had already been started – ignoring session_start() in C:\Programmi\EasyPHP 3.0\www\Web\config.php on line 3
I have successfully got your calendar up and running, many thanks for a great calendar.
The only problem I have is that I cannot get it to login, I have the correct user name and password but all I get back is ‘There was an error logging you in’
Please can someone help me resolve this
Have you encoded the password as md5?
hey Jamie,
I’m working on the edit event part but I only have one small problem as: echo ‘
‘.($e_body).’
‘;
>>>>>>>>>>>> is returning an empty string even if there is text on the textarea.
if you or someone can tell me how to fix this, i’d be very grateful.
echo ‘
‘.($e_body).’
‘;
sorry for previous posts, for some reason this textbox is cutting my text…
‘.($e_body).’
how do I post code on this thing without it being cut?
Hi Colin,
What do you mean when you say have I encoded the password as MD5? I presuming I havent since I have no idea what it means
Paul, Sorry I should have said encrypted as sha1 (not md5 which is another method of encryption). Go to phpmyadmin open your database select the users table and type in your password with sha1 encryption from the drop down selector then save the record and try accessing the calendar again.
Colin,
When I log on to my web hosting site it only lets me create users using their interface and when I get to phpmyadmin I cannot see an option for creating users. But I will double check tonight. Cant check at the moment since I have filtered internet at work, this is one of the down sides of working at a school!
Paul, you need to create a user in the database not in your user control panel for your website. In phpmyadmin select the database, then select the user table then add a new user say paul with a password of your choice with a type of sha1 and you will be there.
The control panel for the website has an SQL tab where you can create databases and users so I created a database here and also a user with all priveleges on for the database. The control panel also lets you go into phpmyadmin to go further into the SQL database, I will check in this tonight
Okay, since I couldn’t paste the code on this page let me try and explain the problem in words. I am working on the ‘edit event’ part of the code, which is working fine except that it updates the database with an empty string (which is a problem.) Now here’s how I do it:
1)on rpc.php I am echoing the form with the textarea which also shows the event that we’re changing, which is fine,
2) I call the update function, ’save’ onclick with e_id parameter(which works fine) and “$F(\’evtBody\’)” from the textarea, which returns an empty string (which is the problem). I know that the function is reading the textarea but not the text in it when I do this”$(\’evtBody\’)” !
So if anyone knows how to fix this, please do tell… and once I’m done with it I’ll post the solution in here… if it allows me to post the code under “ECHO”.
Uran
[...] many of the tutorial sites there are hardly any Calendar systems. Therefore, he has developed a Calendar System using MySQL and Script.aculo.us. There are 3 main parts, the Javascript, the HTML and the PHP script. You can change the date with [...]
Can anyone help me
Tried to run the calendar but got this error message
Parse error: parse error, unexpected T_STRING in /home/kimgan/public_html/calendar/databaseConnection.php on line 10
Hi!
I´m studying a little php and javascript, and this calendar I think is amazing…
Ufff! I don’t know, maybe a day I can understand all!
And I have a suppose case for the comunity, if you change Event Colour to a “select” with 4 or more colours “options”, I think it would be great to assing each event a colour.
I have tried to, but without success…
Greetings fron Spain
Hi pls,
am having the following issues,please help
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\mysqlcal\mysqlCalendar\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\mysqlcal\mysqlCalendar\rpc.php on line 172
What should the permissions be for each file? should it be writable? 646, 777? PLease let me know
[...] MySQL Calendar [...]
Great calendar – Can anyone point me to the chunk of code to decrease the padding between the individual days? I find 4 places with padding called out, adjusting any one of them doesn’t tighten the calendar.
Great i used it on my site
When enter the user name and password it just acts like it reloads but if i put in wrong password or username it tells me i did im not sure but it acts like it not seting the cookie help please view by clicking my name and enter admin admin for user and pass
Very nice
but I’m unable to use it.
Is the database necessary ?
I just need to display the calendar and link events to the days.
It would be better if you answer me by email.
Thank you in advance for the help.
regards
Gabriele
I am migrating my website from my current host to godaddy.com. I changed created a new MYSQL DB as requested and changed the DB pointer information to the new DB. Unfortunately, all i get is a blank box and the following error in the browse:
Message: ‘Ajax.Request.Events’ is null or not an object
Line: 824
Char: 5
Code: 0
URI: http://themachan.com.previewdns.com/calen/js/lib/prototype.js
any help you can offer would be greatly appreciated.
Hello There,
I am very Pleased to introduce our new website ScriptsBase.com. Scripts Base is intended to be the largest source uncomparable with others for absolute free or commercial website development scripts in ASP, .NET, PHP, JAVA, CGI, PERL and much more. Webmasters can easily find accurate, amazing, interesting, capturing, exiting, tarnishing, resolutions for their website.
Please feel free to submit your scripts to our website here (http://www.scriptsbase.com/submit-script/) for inclusion in our directory.
Pleasure will be continued in rendering our service with our assurance that website will stand as outstanding performance comparatively and help you better and best among all marketed and makes you to feel envy by others and will have definitely pride achievement to the maximum and success for your assignment.
Thanking You,
Karthick,
Site Admin,
ScriptsBase.com
@Varun:
Hi Varun,
You will also need to migrate the data within the old database as well. Basically, the new database you have created is empty. Most hosting companies have a way for you to back-up or save your existing database. You will want to back up or save your old DB and then in your GoDaddy DB you will restore or import to your new DB.
Hope this helps,
Jeff
This is a really good piece of code!
hi jamie,
I have found your code(MySQL Calendar v1.1 ZIP) in your site, it is interesting and I want to use it in my website. But i have met the same problem like what Ditch and Mike had.
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\rpc.php on line 92
could you give me some help? thanks in advance!
Hey Guys,
First off, after reading every comment here, it’s really nice to see everyone helping one another out. Not just Jamie. Kudos all! I’m loving this calendar and am very eager to implement it properly. However I’m having (seemingly simple) login issue.
My site is hosted on GoDaddy and have created a database there. In the databaseConnection.php I have my database name, user and password to connect to that database. Using phpAdmin I’ve created another user with the default “admin” and the same password.
Since doing that, there isn’t any errors, except I can’t login. I just keep getting “Your username or password was incorrect”.
Any help or guidance would be greatly appreciated. Thanks in advance.
bluehaus,
When setting up a new user in the database using phpMyAdmin you need to set the password using sha1 encryption (one of the choices in the “Function” pull-down), this will encrypt the text you enter in phpMyAdmin to the correct format for the calendar to compare against.
Hey there, nice calender really nice but i have a problem. hope someone can help me. i want to have it like this. a user comes to the calender and can enter an event WITHOUT logging in. that he only can do if theres not already an event placed. the login is still needed but just to delete or change events. but what i need is the funcionality to add events without logging in. is that somehow possible ?? can someone help me plz ?? i would be very thankful
greetings
Calender works fine execpt for when I try and add an event. When I add an event nothing happens.
Another issue is migrating the calendar to a server with a different timezone. It completely messes up the calendar.
Hi Jamie,
First thanks for the great calendar, its working nicely. I do have a question, how can I make it so that dates are “not selectable”? I have tried identifying the dates that I want to be “not selectable” by first running this code, it changes the color on all the dates older then $today:
if($finalDate $pastColor???
Thanks for everything, and GREAT CALENDAR!!!
Mark
Hi Jamie, part2 since first was cut off
if($finalDate $pastColor???
Thanks again, part2
Mark
Hi Jamie,
Thnx for the calendar, it’s great!
Maybe stupid question, but does the year 2010 come in automatically with Ajax internal Calendar?
Cheers,
Cor
Hi Jamie,
The calendar was really great, and it suits everything that i am looking for. But when I tried to run it, i got an error about the $action
NOTICE: Undefined index: action in C:\wamp\www\mysqlCalendar_1_2\index.php on line 4
Jamie, great calendar, its real hard to find a calendar out there like this one. I need something on the fly to implement into a site and i was lucky enough to find yours.
To everyone That has not figured it out yet, in order to change the number of years, so it doesn’t end in 2009, just go into rcp.php and look at line 67. Were it says $yEnd=($yStart + 4)
just add 10 or however years you want it to show
Guys i am getting this error :
http://www.health.uottawa.ca/kbond/Calendar/index.php#
i am trying to implement it on my account under Ottawa university.
why is that ?
I use your calendar to post menus for our local Senior Center. All works well but I do have a question: I would like to upload, say, a month or 2 of menus into the database using a text file or Excel file instead of manually entering data into each day. I cannot, for the life of me, figure out the time stamp numbers. Is there a way for me to create and upload such a file?
i am getting undefined variable tTop in rpc.php on line 172.
After removing this variable, calendar shows well but when the drop down is used i get another undefined variable error ‘today’ missing in rpc.php
Can you please lighten me up?
Does ANYONE know how I could upload an entire month’s events into MySQL? Can’t seem to get the date code(s) right.
For thoses who have a cookie issue…
try this
if(isset($_COOKIE['nodstrumCalendarV2']))
instead of
if($_COOKIE['nodstrumCalendarV2'])
in rpc.php
AND
to delete the cookie in the index.php, try
case ‘logout’:
setcookie(‘nodstrumCalendarV2′,”, time()-3600000);
Pour ceux qui ont des problème de cookie
Essayer ceci
if(isset($_COOKIE['nodstrumCalendarV2']))
a la place de
if($_COOKIE['nodstrumCalendarV2'])
dans rpc.php
ET
Pour effacer le cookie dans index.php
case ‘logout’:
setcookie(‘nodstrumCalendarV2′,”, time()-3600000);
Hello,
I will continue to use this wonderful calendar in my site, but the year 2010 not appears and i can’t use it.
Can help me?
Thank you very much
Hi Jamie! Its working… thanks… I translated for portuguese – BRAZIL, because I’m from Brazil… if u want the rpc translated, send me an e-mail beuleal@hotmail.com.
I did a diferente painel control, because i put in my web system.
I’m here for help, anything send me a e-mail…
———————————————————-
Raffaele Talamona: open the document rpc.php and search 2006, and replace to 2010. I changed too.
It’s working! Thanks a lot!
Thank you so, so much for building this! This is exactly what I’m looking for! I’ve looked far and wide for months on end and then boom I found your Gem! I do have a question though Can HTML and images be put in the Add Event section? That will really top things of if this can be done. Thanks again!
“Create your database and import the ‘databaseSQL.sql’ file into it, this will create the default data for running it.”
I set up a database on GoDaddy but am confused about importing this. Has anyone used GoDaddy for the database. Any help is appreciated Thanks!
I imported the database and changed the connection settings, but I can’t get the calendar to even come up. I keep getting this Message…
Could not get settings.
YOUR CALENDAR ROX!!!
I could change everything to spanish, played with the events, with the colors..everything!!!
and it took like 20minutes =)
take care and thxxxx
[...] MySQL Calendar [...]
[...] many of the tutorial sites there are hardly any Calendar systems. Therefore, he has developed a Calendar System using MySQL and Script.aculo.us. There are 3 main parts, the Javascript, the HTML and the PHP script. You can change the date with [...]
Hi Jamie,
I’ve read through all the previous posts and it seem like I’m stymied by the common problems of the index.php code wanting the ‘action’ variable to be set and the multiple undefined variable erros in rpc.php. I pretty sure the rpc errors are because the code flow never gets called due to the logic.
So my main question is:
Is index.php the start page or did you expect it to be called from another HTML Form with the ‘posted’ variable ‘action’ populated in the Post?
I’m running a local WampServer v2 server on Windows 7 with PHP 5.3.0 and Apache 2.2.11. Any settings beyond defaults that need to be set in the PHP .ini ?
Regards,
-Mike
awesome stuff
thanks for the great info
Hello Jamie, this script is helpful for managing a bed and breakfast rooms. I have to change it again for my needs. Thanks
Gianni
Hi,
first thanks for the calendar. I have installed it, but have some trouble. Hope you can help me to solve this.
1. I have in the dropdown year field 2006-2009 field and no 2010.
2. I set up an event as admin and log out… than reload the page as visitor and there are no event listed in the calendar. If I relog as admin, I can see the events but the date fields of the events have the same color as the no event fields.
3. I have checked the MYSQL database, the added event are there and the changes too but it seems that the calendar won’t communicate with the database in visitor modus. I checked the database connections, username, password and so on, everything looks fine.
Please help me to figure out what went wrong. Thank you very much.
Best regards,
matto
Hello Matto
for point 1
open rpc.php
Find this line
$monthMaker = mktime(0, 0, 0, $monthNumber, 1, 2006);
Replace 2006 with 2010.
Looking after
$yStart = 2006;
$yEnd = ($yStart + 4);
and Replace
$yStart = 2010;
$yEnd = ($yStart + 4);
if you just want to write the 2010 calendar:
$yStart = 2010;
$yEnd = ($yStart + 1);
Excuse the translation
greetings
Gianni
Molto Gracias Gianni!
The rest of the problem has been solved, just needed to drop down the year field and select the current year again. Then was the registered event there.
hi jamie,
it’s works..thanks dude!!!
Excellent application thank you very much!
From Temuco, Chile (the Earthquake country).
Good job
Thanks for this amazing script, everything is runing smooth except that I can’t get rid of this message!!
Notice: Undefined index: action in D:\wamp\www\ChurchWeb\cp\calendar\index.php on line 4
any sugerences?
thanks again
Hi! I can´t add an event? and change de colours?
The page show me this:
Day Colour:
Weekend Colour:
Today Colour:
Event Colour:
Iterator 1 Colour:
Iterator 2 Colour:
…
the page show me the code, not de colours
Thanks a lot for your application. It´s simple and efficient…that´s what I love.
Hi,
does anyone have a working copy of this calender?? The version I have just downloaded has many errors when I tested the script.
I get the following errors, soory the list is long!
Notice: Undefined index: action in C:\wamp\www\testwok\mysqlCalendar_1_2\index.php on line 4
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember 2006200720082009
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 89
Login
MonTueWedThurFriSatSun
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
1
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
2
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
3
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
4
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
5
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
6
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
7
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
8
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
9
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
10
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
11
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
12
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
13
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
14
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
15
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
16
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
17
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
18
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
19
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
20
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
21
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
22
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
23
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
24
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
25
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
26
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
27
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
28
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
29
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
30
Notice: Undefined index: nodstrumCalendarV2 in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 143
Notice: Undefined variable: tTop in C:\wamp\www\testwok\mysqlCalendar_1_2\rpc.php on line 172
Leave a reply