insert into mysql db with php while loop

Question

I got the following issue while trying to insert multiple entries into a MySQL innodb.

only the first insert is stored in the db. (although its stored correct)

db data are correct, post data are correct, everything is tested the while loop is counting correct in my test (without the inserts)

i.e. $r = 7 $s = 3 gives me 21 slots which is correct.

$l = $_POST['Lager'];
$r = $_POST['Reihe'];
$p = $_POST['platz'];
$s = $_POST['slots'];
$a = $_POST['art'];

echo( "test: " . $_POST['Lager'] . $_POST['Reihe'] . $_POST['platz'] . $_POST['slots'] . $_POST['art'] );

$i=0;
$n=0;
$counter =0;

while($i < $p)
{
$platz =("
 INSERT INTO 
    Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
 VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
 mysql_query($platz);
 echo ($platz);

    // anzahl slots = $s
    while($n < $s)
    {

    $slot("
     INSERT INTO 
        Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
     VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
     mysql_query($slot) OR print(mysql_error());

    $n++;
    $counter++;
    echo($slot);
    }
    $n = 0;
$i++;   
}
  echo ("\n" . $counter . " Slots erstellt");

mysql_close();

If you need to insert multiple rows into the database, you should use the `implode()` function available in PHP. [See](http://stackoverflow.com/questions/779986/insert-multiple-rows-via-a-php-array-into-mysql). — Lion, Apr 11 '12 at 11:22

score 2 · Answer 1 · answered Apr 11 '12 at 11:09

2

I don't exactly understand what you are trying to do and what's not working, however this:

$slot("
 INSERT INTO 
    Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
 VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");

seems to be missing a '='.

answered Apr 11 '12 at 11:09

Armatus

2,206
17
28

oh my just a typo costed me some time thanks a lot! sorry to bother for a typo! – Roman Bartel Apr 11 '12 at 11:16

score 1 · Accepted Answer · answered Apr 11 '12 at 11:13

 $slot("
 INSERT INTO 
    Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
 VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
 mysql_query($slot) OR print(mysql_error());

should be:

 $slot = 
 ("INSERT INTO 
    Lager (LagerNr,ReiheNr,PlatzNr,SlotNr,LagerArt,Stock)
 VALUES ('". $l ."','" . $r  . "','" . $i . "','". $n ."','" . $a . "','0')");
 mysql_query($slot) OR print(mysql_error());

score 0 · Answer 3 · answered Apr 11 '12 at 11:12

0

You don't have an "=" after $slot, but $platz does.

answered Apr 11 '12 at 11:12

Stefan Manciu

490
1
6
19

insert into mysql db with php while loop

3 Answers3