Saving at the same time in many rows

kumschick

how can I save in many rows a the same times with php and mysql?

Cols I'm using:

$id //ID Number
$title //Title
$prodlang //Product Language
$quantity //Quantity
$price //Price Per Unit
$client //Remote Address
$date //Date

//PART 1
echo"
$mysql...
while(...
  {
    <tr$bgcolorm>
      <td><input type=\"hidden\" name=\"Xid\" value=\"$row[id]\">$row[title] ($row[prodlang])</td>
      <td><input type=\"hidden\" name=\"Xtitle\" value=\"$row[title]\">$row[title]</td>
      <td><input type=\"hidden\" name=\"Xprodlang\" value=\"$row[prodlang]\">$row[prodlang]</td>
      <td><input type=\"hidden\" name=\"Xprice\" value=\"$row[price]\">€ $row[price]</td>
      <td>€ $total</td>
    </tr>";
  }

//PART 2
$part2=mysql_query("SELECT * FROM $shop WHERE client='$REMOTE_ADDR'",$connection);
while($row=mysql_fetch_array($part2))
  {
    $shop_add2b=mysql_query("UPDATE $shop SET quantity='$xqte1' WHERE client='$REMOTE_ADDR' AND title='$title1' prodlang='$xlang1'");
  }

I don't know how to do it...

Sxooter

Sure, just make your form elements look something like this:

later, in a loop:

etc... this means you'll get your form vars in an array for each field.

Then you process the arrays to build a series of insert or update statements...

kumschick

yes, but how can I say that the name of the inputbox will autoincrease?

---> ...quantity='$xqte[1]' ... <---
---> ...quantity='$xqte[2]' ... <---
---> ...quantity='$xqte[3]' ... <---
...

$part2=mysql_query("SELECT * FROM $shop WHERE client='$REMOTE_ADDR'",$connection);
while($row=mysql_fetch_array($part2))
{
  $shop_add2b=mysql_query("UPDATE $shop SET quantity='$xqte1' WHERE client='$REMOTE_ADDR' AND title='$title1' prodlang='$xlang1'");
}

Sxooter

When you generate your form, just wrap it in a for loop:

for ($i=0;$i<10;$i++){
  print "<input type='text' name='field1[$i]' value='".$someval[$i]."'>";
  # and so on.
}

kumschick

yes, that's for the inputbox itself, but how do i say in the mysql script when using "while($row=mysql_fetch_array($part2))..."

if I say, I get very strange thing as output (if I use echo)

$part2=mysql_query("SELECT * FROM $shop WHERE client='$REMOTE_ADDR'",$connection);
while($row=mysql_fetch_array($part2))
  {
    for ($i=1;$i<10;$i++){
    $shop_add2b=mysql_query("UPDATE $shop SET quantity='$xqte[$i]' WHERE client='$REMOTE_ADDR' AND title='$xtitle[$i]' AND prodlang='$xlang[$i]'");
    echo"[$xid[$i]] [$xqte[$i]] [$xtitle[$i]] [$xlang[$i]<hr>";
    }
  }

[ID] [QTE.] [TITLE] [Language]

[1] [2] [Remote Server Managment 2004] [fra

[2] [3] [Remote Server Management 2004] [eng

[3] [4] [System Uptime Tool 2004] [eng

[4] [5] [System Uptime Tool 2004] [fra

[5] [6] [System Uptime Tool 2004] [deu

[] [] [] [

[1] [2] [Remote Server Managment 2004] [fra

[2] [3] [Remote Server Management 2004] [eng

[3] [4] [System Uptime Tool 2004] [eng

[4] [5] [System Uptime Tool 2004] [fra

[5] [6] [System Uptime Tool 2004] [deu

[] [] [] [

[1] [2] [Remote Server Managment 2004] [fra

[2] [3] [Remote Server Management 2004] [eng

[3] [4] [System Uptime Tool 2004] [eng
...

Sxooter

You can either put the mysql_fetch inside the for loop (i.e. $row = mysql_fetch_row($res,$i)) or you can put a counter inside your while loop:

$count =0;
while($row = mysql_fetch_row()){
  print "<input type=...";
  # more stuff here

  $count++;
}

kumschick

cool, thx it works!