Re: [PHP] Foreach and mydql_query problem

2013/7/22 Stuart Dallas <[email protected]>

> On 22 Jul 2013, at 12:56, Karl-Arne Gjersøyen <[email protected]> wrote:
>
> > 2013/7/22 Stuart Dallas <[email protected]>
> >
> >>
> >> On 22 Jul 2013, at 08:04, Tamara Temple <[email protected]>
> wrote:
> >>
> >>> On Jul 22, 2013, at 1:19 AM, Karl-Arne Gjersøyen <[email protected]>
> >> wrote:
> >>>
> >>>> Hello again.
> >>>> I have this this source code that not work as I want...
> >>>>
> >>>> THe PHP/HTHML form fields is generated by a while loop and looks like
> >> this:
> >>>>
> >>>> <input type="number" name="number_of_items[]" size="6" value="<?hp
> >>>> echo "$item"; ?>" required="required">
> >>>>
> >>>>
> >>>> the php source code look like this:
> >>>> <?php
> >>>> if(!empty($_POST['number_of_itemsi'])){
> >>>>  include('../../connect.php');
> >>>>
> >>>>      foreach($number_of_items as $itemi){
> >>>>      echo "$itemi<br>";
> >>>>
> >>>>          $sql = "UPDATE item_table SET number_item = '$item' WHERE
> date
> >>>> = '$todays_date' AND sign = '$username'";
> >>>>          mysql_query($sql,$connect) or die(mysql_error());
> >>>>   }
> >>>> }
> >>>>
> >>>> ?>
> >>>>
> >>>> The problem is:
> >>>> Foreach list every items as expected in PHP doc and I thought that
> $sql
> >> and
> >>>> mysql_query should be run five times when I have five items.
> >>>> But the problem is that only the very last number_of_items is written
> >> when
> >>>> update the form..
> >>>> I believe this is becayse number_of_items = '$item in $sqk override
> >> every
> >>>> earlier result.
> >>>>
> >>>> So my querstion is. How to to update the database in this case?
> >>>>
> >>>> Thanks again for your good advice  and time to help me.
> >>>>
> >>>> Karl'
> >>>
> >>> Either the code you posted isn't the actual code, or if it is, the
> >> errors should be rather obvious. Post *actual* code.
> >>
> >> The error is rather obvious: it loops around an array running an update
> >> statement that will modify a single row in the table, so it's not
> >> surprising that it appears like only the last entry in the array has
> been
> >> stored.
> >>
> >> Yes, i know that only one a singe row is updated and that is the
> problem.
> > What can I do to update several rows at the same time?
> > Thank you very much for all your good advice.
>
> Are you sure you want to update several rows, or do you actually want to
> insert several rows?
>
> This is pretty basic database stuff, and is off-topic for this list.
>


OK. Sorry. I thought it was a PHP question for a way to update several
mysql rows by PHP code.

Karl