[eluser]sunnyd[/eluser]
Hi all, hope you can help me...
I am currently working a small survey script and one of the requirements is that the user is able to save an incomplete form for completion at a later date.
Right not I am not so sure as to how to achieve this effectively. One idea i have considered is to serialise the post data, save it in a database table and simply retrieve the saved form based on the user id.
This is that database table structure that I have:
user_reponses
id |
userid | stores user id
user_responses | stores user responses including the questionnaire id
date_saved | date user saved incomplete form
date_completed | date user submitted complete form
status | flags whether the form is complete or incomplete
Essentially instead of creating a saved questionnaires table, I am choosing to use the user responses table and add a flag as to whether the form is complete or not.
Is this a good way of going about it or does anyone have a better idea?
