Need Some Direction On Form Data

[refiking]

I need some direction for creating a script that will allow me to store the data from multiple pages of dorm data on one record.  For example.....

 

Page 1

 

What is your name?

What is your telephone number?

What is your address?

 

 

Page 2

 

Where do you currently work?

How long have you worked there?

What is your estimated pre-tax salary?

 

Page 3

 

Have you ever filed for Bankruptcy?

Have you ever defaulted on a student loan?

 

 

And on each page, I'd like the data from the previous page to still be stored on the same record.

[GingerRobot]

Well, which part is it that you are struggling with? Are you able to create a form and store the information in a database - is it just the process of splitting the form across multiple pages that you are unsure of?

 

If so, i guess what i would do is:

 

1.) Once the form on page is submitted, check the data, and create a new record in the database. Store their session id and set a field such as `complete` to 0/false/no

2.) Redirect to second form

3.) Once that is submitted, update the relevant row, which you will be able to do with the session id

4.) Redirect to third

5.) Lastly, after the third is submitted adequately, update the `complete` field to 1/true/yes

 

You would then only "deal" with records where the whole form has been completed, and could routinely delete records that are only partially complete.