I have planned to create tables for dynamic datafields. My concept is to store a dynamic form data inside tables(MySQL). The user can select any number of fields(datatypes) from form.The form is a dynamic form one seen in here . How can we design dB in order to save user's data dynamically?
Can you not just allow for fields within the database to be null. That way when you save the form if any fields have not been filled it doesn't throw an error
Seems, you need to implement EAV data model wiki link Also, there are some ready solutions