如何使db表字段动态化

Question

i am creating plugin in wordpress for contact us form and in that i am creating fields(textbox,textarea etc...) dynamically based on my requirement. so there is no fixed number of fields. i am storing dynamically created fields in my db table.

in some project i may require to create 3 fields and some project i may require to create 5 fields.. my dynamic form is working fine...

now my problem is DB. how do i create table to store contact us data? bcz sometimes there might be 3 fields and sometime there might be more than or less than 3 fields..

so my question is how do i make my table schema for this scenario...

suggestion will be highly appreciated...

Thanks in advnce

Answer 1

i don't think so it's a good idea to do like this... but i am suggesting you this because in your case it might be useful

you can do it by ALTER...

so what you can do is "When you are creating new field dynamically at that time only you can create new column in your table like this...

   ALTER TABLE table_name ADD $name(Column name)  //$name may be your attribute name <input name="">

and same way when you are deleting your field at that time you can drop your table column

   ALTER TABLE table_name DROP $name(Column name) //$name may be your attribute name 

here i assumed that you have already created table table_name (without any fields)

hope it may help you