Proper Use of a WHILE Loop

texmansru47

I have a two part entry form (parent form where I get the Batch Number) and it calls a javascript popup window so I can enter in all the units of a product that belongs to the Batch Number that was selected. Everything works except the while loop. Apparently the loop works... but it scrolls through the entire while loop after the first unit is entered into the batch which defeats the purpose of having a loop to regulate the quantity of product that is to be in that batch number.

Here is my code which I'm having issues with. I need to be able to enter in the first unit into the selected batch, the screen refreshes (which it does) then be able to enter the second unit BUT the WHILE LOOP needs to count against ever new entry not just the first one. My second unit entry is placed in the database but I need the while loop as the Quantity restrictor for each batch (in each batch there is a specified quantity of product)... so if the QTY is 3 I can only enter 3 units into the database... now I can enter an infinite amount of product since the loop exhausted itself on the first entry and I have no stops in the loop so it rolls on.

Any ideas???? 😕 Here is the code:


<head>
<title>Receiving</title>
</head>

<?php 

if (isset($_GET['param1']) && !empty($_GET['param1'])){
    $BatchNumData=$_GET['param1'];     

    echo "Your Batch Number is:\n$BatchNumData"; }
    elseif ($_SERVER['REQUEST_METHOD'] == 'POST'){    

    $BatchNumData=$_POST['param1']; 
    echo "Your Batch Number is:\n$BatchNumData";           

    // Connect to mysql database     

    $con = mysql_connect("localhost","user","xxxx") or die('Connection: ' . mysql_error());; 
    mysql_select_db("test", $con) or die('Database: ' . mysql_error());  

// Insert form values into database     
$sql = mysql_fetch_array(mysql_query("SELECT * FROM `batch` WHERE `BatchNum`= '$BatchNumData'")) or die(mysql_error());               
// ^^ SELECT THE DATA TO BE COPIED ^^      
$Batch=$sql['BatchNum'];     
$Qty=$sql[Qty];     
$1Num=$sql['1Num'];     
$ModelType=$sql['ModelType'];     
$Sku=$sql['OEMSku'];     
$Card=$sql['CardType'];     
$growit = 0; 

while ($growit <= $Qty) {
     @mysql_query("INSERT IGNORE INTO `recv` (`ProdNum`, `SerNum`, `BatchNum`, `ModelType`, `ModelSku`, `1Num`,`CardType`, `DateRecv`) VALUES ('" . $_POST['ProdNum'] . "', '" . $_POST['SerNum'] . "', '$Batch', '$ModelType','$Sku','$1Num', '$Card', Now())")  or die(mysql_error());     
     @mysql_query("DELETE FROM `recv` WHERE `ProdNum` = 0");      
     $growit = $growit + 1;  
     $Countdown = $Qty - $growit + 1; 
     echo "<br>Count: $growit | Remaining: $Countdown\n";           
     }

     mysql_close($con);     
     }
?> 
<body bgcolor="#CCCCCC">

<P>
<form method="post" name="Recv" action="testrecv1.php"><font color="#000080" face="Arial">
<input type="hidden" name="param1" value="<?php echo $BatchNumData; ?>" />  

  <table border="0" cellpadding="3" cellspacing="2" width="400">    

   <tbody>
   <tr style="color: rgb(255, 255, 255); font-weight: bold;">        

     <td colspan="2" bgcolor="#000000"><span class="style1">Receiving Module</span></td>      

     </tr>      

     <tr>        

     <td bgcolor="#ffcc66">Serial Number: </td>        

     <td bgcolor="#cccccc"><input name="SerNum" id="SerNum" type="text"></td>      

     </tr>      

     <tr>        

     <td bgcolor="#ffcc66" width="135">Prod Number:</td>        

     <td bgcolor="#cccccc" width="300"><input name="ProdNum" id="ProdNum" type="text"></td>      

     </tr>      

     <tr>        

     <td>&nbsp;</td>        

     <td><input value="submit" name="submit" type="submit"></td>      

     </tr>    

   </tbody>  

  </table>

woodeye

Maybe I'm not fully understanding what it is you're trying to do, but from looking at your code, I think the problem that you're having with your loop is that right before your loop, you're reseting the conditional statement by saying "$growit = 0;". Therefore, your loop will always happen the same number of times everytime through. You may want to pass a variable via $GET, so that maybe instead of reinitializing the counter "$growit" to zero, you could set it like this:

$growit = (isset($_GET['growit']) ? $_GET['growit'] : 0);

And then in your form tag, you'd have to set it there too. Something like:

<form method="post" name="Recv" action="testrecv1.php?growit=<?php echo ($growit + 1); ?>">

I didn't test this code, I'm just typing off the top of my head, but I think that's right.

texmansru47

Would that interfer with the variable I'm pulling from my parent form (the param1 variable)???

If not I will try it.

Thanks,

texmansru47

I tried your code and I get the same results (after the first data is submitted) the whole loop runs.

I need to be able to enter in different data until the loop states the batch is full (that is why I'm using the $qty variable since the qty of that table will indicate the limit of product for a particular order).

Without the loop I have to hope that the user does not mix up orders and gets the quantities FUBAR.

Any ideas as to why I cannot get this to work???

😕

woodeye

I guess I'm just not clear how the whole thing is supposed to flow. You have a form where the user inputs the batch number, then that takes them to a second form where they enter a serial number and a product number, and they are supposed to enter those numbers a certain number of times, based on the $Qty field that is filled by the batch database. Is that right?

Is there a reason that you check the $GET array for 'param1' ? Does your form send it using the POST or GET method? If you need to check both, can't you just use a $REQUEST ? Or are you checking the GET array when it comes from the first form, and then POST when this form calls itself?

Why do you need the loop to repeat X number of times each time the form is submitted? Shouldn't the form be submitted to the database once for each time the 2nd form is submitted?