Hidden information in the description
I'm setting up a calendar so people can easily see where my traveling users are. I've created a form they can fill in (pre-filled by looking up their IP in MaxMind) when they get to their destination, and created the PHP script to parse my fields into the appropriate database fields and update the database. So far so good.
So I want my users to be able to edit any event in a form similar to or identical to the one in which they create events. Unfortunately, it's a pain to reverse-parse my form field values from the database. So what I'd like to do is store my form field values somewhere, and my first thought was to store them into the event description but make them invisible. So, for example for event ID 99 I added:
<a href='EditLocationEvent.php?ID=99'>Edit</a><span style="display:none;">~Value1~Value2~Value3~</span>
to the event's description, and I could then explode out the individual fields ... but the box that pops up when hovering over the event on the calendar doesn't honor the display:none style and displays the field values. (The bigger box resulting from clicking the "more..." link does honor the display:none).
So I'm a bit stuck. I suppose I could set up another table for my field values and store them there, with the same ID as the event, but that doesn't seem particularly elegant.
Any thoughts on how to accomplish this? Have I missed some grat idea?