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. — Lion
– Lion, Commented Apr 11, 2012 at 11:22

Armatus · Accepted Answer · 2012-04-11 11:09:28Z

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, 2012 at 11:09

Armatus

2,20117 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Roman Bartel Over a year ago

oh my just a typo costed me some time thanks a lot! sorry to bother for a typo!

Glenn · Accepted Answer · 2012-04-11 11:13:25Z

1

 $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());

answered Apr 11, 2012 at 11:13

Glenn

4992 gold badges7 silver badges19 bronze badges

Comments

Stefan Manciu · Accepted Answer · 2012-04-11 11:12:09Z

0

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

answered Apr 11, 2012 at 11:12

Stefan Manciu

5001 gold badge6 silver badges19 bronze badges

Collectives™ on Stack Overflow

insert into mysql db with php while loop

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related