Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : posting to mysql database via php question

[djacks89]

I'm creating a page with multiple instances of the same form fields. The number of instances shown is dependant upon an entry into a previous form that will be posted to this form via the hidden form method.

ex:

form1 - input amount of properties you have.(inputs 3)

form2 - display x(3) instances of property data collection-- using for loop.

property address
property zipcode
etc.

property address
property zipcode
etc.

property address
property zipcode
etc.

I can write script to do this. The problem is when they submit everything. I want to know if there will be a problem when I send the info to the mysql database for insertion. Aren't the variables for the replicated fields going to be the same(name=prop_zipcode in each set of fields) when I SET where I want the information to be inserted. Will this cause an issue. If so, I would really appreciate a method for dealing with this.

I was thinking that maybe I shouldn't have to worry about this because the database might just insert the info in order row after row. Maybe I should use some type of method with an array.

[Burhan]

Not only that, but if you name all the form fields the same, only the last field's value will be available to PHP.

You can avoid this problem by naming your fields with the array notation:

<input type="text" name="hello[]"
<input type="text" name="hello[]"

etc.

[djacks89]

Yeah, it makes sense. I've decided to do everything by array. I just wasn't sure. Actually, I was hoping that I wouldn't have to do more work.(lol)
Thanks alot

[djacks89]

Originally Posted by fyrestrtr

Not only that, but if you name all the form fields the same, only the last field's value will be available to PHP.

You can avoid this problem by naming your fields with the array notation:

<input type="text" name="hello[]"
<input type="text" name="hello[]"

etc.

Will the arrays fill after submit is pressed?

[localhost127]

When submit is pressed it will go to whatever page you sent it to, and then the arrays will be populated.

If you have register globals off (this is a good thing to have off) then you would need to access it via either $_POST['hello'] or $_GET['hello'] depending on whether your form posts or gets.