StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<blockquote> <p><strong>Q1</strong>> How to save temporary data?</p> </blockquote> <p>There are a couple ways you could do this. You could save it to a different table. You could also (probably more popular) save it to the same table as the completed profiles, but flag it as incomplete via a column for this purpose. This column could be named <code>complete</code>. If the profile is not complete, it would be set to <code>0</code> or <code>false</code>. If it is complete, it would be set to <code>1</code> or <code>true</code>. You can then query based on it.</p> <p>You could then "validate" the data via whatever procedure is required and set the column to <code>1</code> or <code>true</code> as needed.</p> <blockquote> <p><strong>Q2</strong>> What should I do if the user saves the temporary data without submitting the form and then quit. This feature looks like the Draft feature provided by Gmail.</p> </blockquote> <p>The answer above should serve this purpose as well.</p> <p>If you need to reload the data and allow the user to continue filling out the incomplete form, you will need to get some sort of identifier for them to allow this. You could do this by setting a cookie, or by some sort of unique identifier they would enter at the top of the form - such as SSN, phone #, student ID #, etc (or a combination).</p> <hr> <p>If you are looking for a feature like Gmail's draft feature, you will need to implement some sort of AJAX call that automatically fire's every X seconds/minutes to automatically save the data.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload