创建动态表单的解决方案

Question

I'm having some trouble deciding which approach I should take. I want to allow users to create their own html forms by choosing different form elements (textfields, textareas, lists, ratios, etc) I guess something similar to http://wufoo.com/ but much more basic. Should I use database tables or create files?

For tables I was thinking to create a table for each form element, e.g

TEXTFIELD TABLE

ID

TEXTFIELD_NAME

USER

...

TEXTAREA TABLE

ID

TEXTAREA_NAME

USER

etc for all form elements

and then just query all of them with..

WHERE user=$user

Or should I generate php files on the server for each form created?

Answer 1

One approach I used for custom forms on a mobile device was to define a table for field types (eg: text, date, money, custom), a table for form templates (with owner, version, and XML for the template data), and a table for form values (as XML) with a foreign key to the template.

Someone may create a form template with the available field types, and the collected data may be stored for that template, and optionally by template version. If the database supports it, you could query into the XML data to aggregate fields across forms.

For presentation, you could use a fixed style, or transform the template or collected fields however desired.