add field in form with add button

itsme85

Hello,

I want to add a field in a form with a add button. And submit all the fields in one time into the database. Is this possible with PHP?

Pikachu2000

Do you mean (as an oversimplified example) display a form with a text field, then have buttons to either submit it, or redisplay it with an additional text field? Am I close?

itsme85

No, that is not what I mean.

For example:
I have a product_name field, a product_property field and a product_property_value field.

I want to create to option to give a product more product_properties. But not all the products will have the same number of properties. So I want to have a button to add a extra record. After that I want to submit all the data in one time.

igorlopez

itsme85;10888588 wrote:
No, that is not what I mean.

For example:
I have a product_name field, a product_property field and a product_property_value field.

I want to create to option to give a product more product_properties. But not all the products will have the same number of properties. So I want to have a button to add a extra record. After that I want to submit all the data in one time.

This means you will need to have one table for each product property, or at least for all added property's, where you insert the product ID having this 'Added' property.
So in terms if this is possible with PHP, yes it is, but you need to have some validation on 'Added' product property's to make a decision if this is a 'new' property or if it already exists and if it does not exist you need to create a new table for it.
One tip is to have a table where you keep all the added property's where each record consist of the name of the added property and then you can either have a rule between property name and the corresponding table or just store the table name there as well.
There is another option which is just to extend the existing table with more columns (fields) but is not a recommended DB practice.

itsme85

I don't what to create new tables. I only want to add more records in one table add the same time. Add yes there has to be a validation, but i think that's not my first problem. I want to use a add button to display the dropdownbox and the value_field again (a extra row), to type new values. Do I have to do this with a subform? HTML or php?

Something like, this page: http://examples.codecharge.com/ExamplePack/OrderEntry/OrderEntry.php?order_id=3

igorlopez

It looks to me that you have two problems.

The first one is how to design a form where you can add additional property's (where your dropdownbox comes in is unclear to me).
Short answer is: A php script that creates the form and handles the actions as far as adding entry rows to the form and processing the form upon a submit action.

The second problem is how do you handle the data from the form which was my previous answer. When it comes to DB design you have a multitude of options and you should select the one that best suits your needs.

itsme85

Yes, that's right. But how can I do that?

igorlopez

Yes, that's right. But how can I do that?

Are you asking how to design the form or how to write a php script producing the form (after it has been designed) or how to handle the irregular data from the form?

For design there are tons of good free design you can use and adapt.
Writing php code producing the form is plain php coding.
DB design, my previous recommendation still stands.

itsme85

I want to know how to design the form. I search all over the web, but I couldn't find how to add form field with a button. Do I have to use a include function?

Pikachu2000

Assuming this is an administrative form of some type, why wouldn't you just let it display the extra field to begin with and simply leave it blank when it isn't needed? It would be a less convoluted way to go about it.