[RESOLVED] complex form

[benracer]

Hi,
i have a page that uses a loop to display all items, the page contains textboxes with the initial value set to the information from the db. How could i change different items and submit one large form to update all the rows to the text in the text box.? I am unsure how to identify one row from another. I think a foreach loop would work but i am unsure how to select each individual item and get the text from the form Thanks 🙂

[Jack_McSlay]

name the textbox fields in order to set up an array.

for example:

<form method="post">
<input type="text" name="name[164]"/>
<input type="text" name="name[166]"/>
<button type="submit">Ok</button>
</form>

makes a form where the resulting data will have an array containing the submitted name for each item

[benracer]

Thanks, So if i have 5 different values then i would need 5 foreach loops?

[Jack_McSlay]

in fact it would be easier to use the IDs on the foreach.

foreach (array_keys ($_POST['name']) as $key){
   $name = $_POST['name'][$key];
   $code = $_POST['code'][$key];
   // rest of your update code here
}

[benracer]

Thanks sorted, is this method a good idea as if there were 10,000 products it will have to add all there data to the database everytime one change is made?

foreach($_POST['price'] as $id => $text){
$price = "UPDATE items SET price='$text' WHERE id='$id'";
mysql_query($price) or die("ERROR");
}

[Weedpacket]

benracer wrote:

Thanks sorted, is this method a good idea as if there were 10,000 products it will have to add all there data to the database everytime one change is made?

First ask yourself if it would be a good idea to have a form that lists 10,000 products.

[benracer]

LOL, point taken.