CalendarXP.net Support

[lenkp]

I'm new to programming & PHP so please bear with me. I've reviewed the messages in the knowlege base but no luck. This is similar to customizing a calendar for every UserID ("http://www.calendarxp.net/forum/viewtopic.php?t=48"). The only problem is that I do not know how to pass a parameter from my Form to the AGENDA PHP script as soon as the end-user clicks the Calendar icon. This is needed so I can dynamically build the calendar.

PROBLEM:
Using the online documentation, I have successfully configured the PopCalendar to dynamically generate the AGENDA.PHP from AGENDA.JS and data stored in MySQL database. I am trying to use a field in my Form (zip code) to build the SQL "WHERE" clause. The problem is that I do not know how to get the information into the WHERE clause from my Form field. (Also, if you know of a better way to do this, then I am all ears!). My form field is "errandsform.zip"

My select statement is:

$query="SELECT * FROM my_agenda where ag_zip = '$phpzip'";

How do I populate $phpzip with the zip code in my form field called "errandsform.zip" so that when a user first clicks on the calendar icon he/she is presented with a calendar of events/agenda items related to their zip code?

Any (detailed) help would be much appreciated. Thank you for your patience. -paul

[calendarxp]

You kind of need AJAX to fulfill the task. The steps are as following:

1. create a php script, say "zipEvents.php", that take a zip parameter and generate "gfPop.fAddEvent(...)" calls using sql query. Note that it's similar to agenda.php but you need to prepend "gfPop." to each and every function calls.
   
2. set up the onclick event of the icon to collect the zip code field from your form and send it to your php script via AJAX call.
   
3. execute the return string by using "eval()", and only pops up the calendar after that.

The downside of it is the calendar will not be popped up immediately after click, which may confuse the end user.

Another better way is if you know the zip code before entering the page with calendar, then you may simply pass the zip to the agenda.php in iframe tag and user will see the calendar with desired events immediately.