Add dymaic rows and add them to mysql

[krishnaeecs]

Dear All,

I am designing a site, which needs to add rows dynamically, each row contains different type of fields (text boxes, dropdowns, etc). how to add rows dynamically with AJAX and how to store these dynamic multiple values in mysql  & retrieval process?

 

Thanks in advance

 

Regards

Krishna. P

[gizmola]

Krishna. P,

  We really need more description of this application.  Ajax is no big deal -- grab a copy of jquery and you should be able to have an ajax post running in no time with the literally hundreds of tutorials you can find with a quick google or youtube search.

 

Without knowing what the application is, and how the data will be used, it's hard to say.  For example, one solution is to accept the post data, serialize it in some format your application undertands, and store it in the database in a text column.  This would be easy to get the data in and out, but if you plan to query on individual data elements would not be a good solution.

[krishnaeecs]

Thanks for your immediate reply.

I am attaching a document, which contains my requirements.

 

Thanks in advance again

 

[attachment deleted by admin]

[krishnaeecs]

I am awaiting for your valuable replies

 

Thanks in advance

Krishna. P

[gizmola]

I browsed your design doc, but it's pretty involved.  In order for me to help you out, I really need to have you boil your question down to just the part that you need help with -- so in as concise a manner possible, could you extract the part of the requirments that involve the design of storage for these meta columns.

[frizi]

Hi,

 

i was working on a similar problem before some time and stuck in the problem with Opera browser which had difficulties with newly added rows. It wasn't sending to the server after send.

 

However, you can use a simple JS which adds to the page the new <input /><div id="newTag"></div>. You need an activator button or event which is adding this tag each time you press it instead of the newTag div. Good luck with solving your project.