I have a rather large form consisting of radio buttons / checkboxes as well as text inputs. Due to the nature of the flags, if they publish the form without validation, it is not sent to the POST data. Which leaves me a little stuck with how to handle this.
I initially started my database with a standard column for each field. For instance:
id | userid | firstname | lastname | middlename | phonenumber | mobilenumber |
This quickly changed when I got 30 columns. This form is huge. I decided to use the "EAV scheme" to give my table only 4 rows. Now it looks like this:
id | userid | name | value
---+--------+-----------+------
1 | 1 | firstname | steve
---+--------+-----------+------
2 | 1 | lastname | blah
This seems like a nicer approach.
, : , , ? 20 ( ), , "null", ?
?
?