Re: Updating Multiple rows in mysql w php at once (newbie)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



you can do it like this...

<input name="field[]" value="zero" type="text" />
<input name="field[]" value="one"  type="text" />
<input name="field[65]" value="sixty-five"  type="text" />
<input name="field[car]" value="truck"  type="text" />

on the php side this would equate to...

echo $_POST['field'][0]; // prints "zero"
echo $_POST['field'][1]; // prints "one"
echo $_POST['field'][65]; // prints "sixty-five"
echo $_POST['field']['car']; // prints "truck"

provided the form is submitted via a POST method.

Take care to ensure you have the right index on the array.



Chris.

On Fri, Aug 13, 2010 at 8:19 PM, DealTek <dealtek@xxxxxxxxx> wrote:

> Hi all,
>
> another newbie question....
>
> I have a recordset from mysql - a list of 20 or so  products...
>
>
> 1 - I would like create an edit form to loop through the records and edit a
> text field called 'favorite' for each of the records - (this, I have
> done)...
>
> 2 - then I would like to submit the form and update all records favorite
> field at once...
>
> Q: so how do I create the form and response page so that I can update all
> 20?
>
> I'm sure it involves numbering the form names like:
>
> $c = 1 - then increment counter
>
> <input name ="favorite<?php echo $c; ?>"  ...   (1 - text)
> <input name ="favorite<?php echo $c; ?>"  ...     (2 - text)
> <input name ="favorite<?php echo $c; ?>"  ...     (3 - text)
> <input name ="favorite<?php echo $c; ?>"  ...     (4 - text)
>
>
>
> ...not sure how to loop thru these on the response / update page to get
> them updating correctly....
>
>
>
>
> --
> Thanks,
> Dave - DealTek
> dealtek@xxxxxxxxx
> [db-10]
>
>
>
>

[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux