How to create “dynamic” forms - and save data and form design in two areas

Question

I am creating a system for a company that has many field workers who need to fill out many certificates for each job they assign. We do this using a tablet PC running mysql / php / apache, which synchronizes with the main server.

These certificates are changing a lot - so I get new versions all the time. And if I do this in the traditional database / php / html setup - I would permanently change the projects and databases, not to mention the processing of changes in the design of certificates and data. (add, delete fields)

I am looking for a way that I can easily create a form and save its design and data in one line (in two fields) - in my mysql database. So, while reading a specific line, I always have the correct design that matches its data, I can combine. This can be done using xforms - but the browser needs a plugin for this. Xforms is tiring.

This is fairly easy to do with text fields only, but I need checkboxes, lists, etc ...

Any brainstorming is appreciated.

Answer 1

How about using NoSQL as MongoDB to store certificates? Will this work for you?

Answer 2

, , , NoSQL dbe CSV, JSON php serialize().

, . , (, , , ).

PHP , , .

Answer 3

, ZendFramework , , . buildt .

Answer 4

ValidForm, , . , :

• !

, , , , !

http://validformbuilder.org/

,

Answer 5

.

, , csv .

nameTxt, ageTxt, genderRdo, agreeChk , 25, ,

,

$csvExplode = explode ( ",", $fetchedData);

, , .

,

Answer 6

, php serialize(), ?

Answer 7

:

• ID - PK/Auto Increment
• FieldName
• FieldType
• (True/False)

:

• ID
• FK_Field_ID -

, .

Next, I suggest you create a class of fields, i.e. CreateTextInput, CreateNumberInput, etc. I did just that by overloading the methods. Sorry, I can’t share this code, it was for the client.

Hope this helps, IgnitedCoder.com