1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. To combat forum spam, new accounts will need to make at least one (valid) post.
    Otherwise, we will periodically purge all users without posts or that haven't confirmed their account.

Integration with MySQL

Discussion in 'General' started by drharmon, Aug 24, 2011.

Thread Status:
Not open for further replies.
  1. We have a mobile application that creates a series of dated (mm/dd/yr:time) user sessions into a MySQL database on a hosted server. These dated user sessions contain data that we then to graph in a browser using XML and a PHP script.

    What we would like to be able to do is is display the list of previously created (dated) user sessions from MySQL in the calender and then allow the user to select an available dated session of interest on the calender and then have the calender linked to our PHP script for graphing

    Asked another way...can the events displayed on the calender be linked to our PHP script for graphing the XML data ?

    Thanks in Advance...
  2. Brian

    Brian EPC Developer Staff Member

  3. Integration with an existing MySQL database (based on time and dates)

    Another try... :classic: Key point, we only need the calender to display "past" events, which have already been stored in an existing MySQL database...which we can query by date/time of creation or by keyword and then supplied to the calender PHP script.

    In summary (I think!), we need the calender to display all previously created events and then provide a means to allow the user to select a past event on the calender and have our PHP graphing script display it in a new browser window (for comparison and analysis)

    Unlike most applications taking advantage of calenders...ours only deals with things that have happened in the past (and are already in the database). We are basically keeping tracking of the past...and not scheduling the future :classic:

    Help us!!!

    Thanks in advance...
  4. Brian

    Brian EPC Developer Staff Member

    You will need to add the events to the calendar database. You should be able to convert the date format and figure out how to store the events and you could also add your own descriptions and links back to your graphs.

    Just add some events to the calendar and see how they are stored. Shouldn't be too hard.
  5. Multiple private user calenders

    Thanks for help with the integration with MySQL questions...have everything working perfectly :clap:

    Next simple question...each one of our users (we have many) needs to see their events (sessions) on their own private calender. All the user events (sessions) are stored by username and password protected in our MySQL db.

    So a users logs into our site (w/ username & password) and lands on a secure user page. Now they want to see only their events on the calender.

    Possible? Thoughts?

    Thanks in advance...
  6. Sounds like V7 may have what we need in terms of multi-user calender support :confused: Following on FB and Twitter...Thanks.
  7. Last question :)

    Last question...in either the current release or V7, can the calender be configured and implemented to display only the events of a particular user ? Again, we have multiple users but each user should only be able to view their own private calender of events. Basically a private calender of events for each registered user.

    Thanks in advance...and thanks for all the past help!
  8. ve9gra

    ve9gra Support Team

    V6 allows for multiple event managers (users), but all events can be seen/edited by all users. Current confirmed info about V7 is available in it's thread.
Thread Status:
Not open for further replies.

Share This Page