I found on this forum similar issues but unfortunately no solution to my specific problem.
I am working on a Form-Generator which allows to create html Forms by simply "clicking them together" (I need the fields "Name", "Email", "Language" and "Smoker/Non-smoker" => *click* and voilà). This works quite well, the forms structure and some additional information (Validation) is stored in a xml file.
Now my problem: How and where should I store the data submitted with these forms, means in my example f.e. "Bob", "bob@example.org", "English" and "0".
The data should be sortable and directly accessible, so storing it in the same xml like the forms structure seems to be a bad choice.
The easiest and most convenient solution would be to create a new mysql table for each new form, but: first of all there would be in short time quite a lot of tables (without too much content) and, more important for me, a friend once told me that whenever I am planning to create tables "on the fly" it is for sure due to a poor design and I should find a better solution.
Well, I've really been thinking about it a lot but still don't see a better way to solve the problem (than the to create for every form a new table), as I don't know the structure of the table because itself is generated dynamically.
I hope you could follow and understand my poor english, sorry for it
Thank you for your time and I'm eager to hear your thoughts about the subject
greetings from switzerland