PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Retrieving Form Data from the Database

  1. Hi,

    I have a client that has a lengthy form and would like the ability to start the form, submit the data, then come back later and finish it. Or submit all the data and come back later and edit some information that may have changed. Example: Trip Registration form that asks for number of trip participants or number of meals needed. A month from now we may have added participants which would also increase the number of meals needed.

    So, I am trying to create a form that allows me to submit form data and later go back and have that data pre-fill the form. I know how to create the form and enable fields to be populated dynamically. However, I do not know how to retrieve the form data that is already stored in the database and display it.

    So really I have 2 questions:
    1. Is there a way to retrieve form data already stored in the database and display it in the form fields to be edited by a user?
    2. If so, how exactly is the data structured in the database?

    Thanks for all your help,
    Matt

    Posted 14 years ago on Wednesday March 31, 2010 | Permalink
  2. Anyone have any ideas on this topic? I would appreciate any answers or suggestions.

    Thanks-
    Matt

    Posted 14 years ago on Monday April 5, 2010 | Permalink
  3. The problem with this is while you could use PHP and cookies to accomplish this, the user wouldn't really be editing an existing entry. When they submit the form it would then create a new entry.

    To pull this off would be fairly advanced and complex and involve custom PHP to store values and then if the cookie exists retrieve those values and populate the field dynamically.

    How advanced are your PHP capabilities?

    Posted 14 years ago on Monday April 5, 2010 | Permalink