Need to update multiple text boxes when checkbox is present

mnewbegin

I have a inventory software I'm making.

I used to update the items when it was single items with this code..

// Check if add to order button is active
if($add){
for($j=0;$j<$count;$j++){
$add_id = $addcheckbox[$j];
$sql = "UPDATE _products SET onOrder='1', orderNum='$ordernumber' WHERE productID='$add_id'";
$addresult = mysql_query($sql);
}

// if successful redirect page
if($addresult){
echo "<meta http-equiv=\"refresh\" content=\"1;URL=pending.php\">";
}
}

I found this, which I think is the answer
http://phpbuilder.com/board/showthread.php?t=10355036

But im having problems implementing it to the current code I'm using.
heres my current page of code, and a screenshot of the page.

What I'm trying to make happen is have the updated number get filled into the database where the box is checked.

My current page im working on.

<?php
session_start();
include 'dbc.php';
include 'functions.php';
if (!isset($_SESSION['user']))
{
 die ("Access Denied");
}




?>



<h2><b>Inventory</b> </h2>
<?php if (isset($_SESSION['user'])) { ?>
<p>Logged as <?php echo $_SESSION['user']; ?> 
| <a href="settings.php">Settings</a> | <a href="logout.php">Logout</a> </p>

<?php
//connect to database
$sql="SELECT * FROM _products WHERE pending='1' ORDER BY productID ASC";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
?>

<link href="styles.css" rel="stylesheet" type="text/css">

<center>



<p>&nbsp;</p>

<a href="inv_main.php">Main</a>
<br>

</p>
<table width="700" border="0" cellspacing="1" cellpadding="0">
<tr>
<td>
<table width="700" border="1" cellspacing="0" cellpadding="3">
<tr>
<form name="form1" method="post" action="">
<td height="52" colspan="10" bgcolor="#d5e8f9" class="mnuheader"><div align="center"><strong><br><h3>Pending</h3>
</strong></div></td>
</tr>

<tr>
<td bgcolor="#74889b" class="mnubody" align="center"><span class="style1">#</span></td>
<td bgcolor="#74889b" class="mnubody" align="center"><span class="style1">ID:</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Number:</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Desc:</strong></td> 
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Count # on hand</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Weight Each:</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Customer:</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">Update:</strong></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1">ADD:</span></td>
<td bgcolor="#74889b" class="mnubody" align="center"><strong class="style1"># to ADD:</span></td>
</tr>


<?php  

for($a; $a < mysql_num_rows($result); $a++) 
{ 
$rows = mysql_fetch_array($result); 
echo ($a % 2 == 0) ? '<tr>' : '<tr class="altrow">' . "\n"; 
?>  


<td align="center" bgcolor="#FFFFFF"><input name="checkbox[]" type="checkbox" id="checkbox[]" value="<? echo $rows['productID']; ?>"></td>
<td><? echo $rows['productID']; ?></td> 
<td><? echo $rows['productNum']; ?></td>  

<td> <? echo $rows['productDesc']; ?></td>  

<td><? echo $rows['productCount']; ?></td>
<td><? echo $rows['weight']; ?></td>
<td><? echo $rows['customer']; ?></td>  


<td align="center"><a href="update.php?productID=<? echo $rows['productID']; ?>"><img src="images/interface/edit.png" border="0"/></a></td>
<td align="center" bgcolor="#FFFFFF"><input name="addcheckbox[]" type="checkbox" id="addcheckbox[]" value="<? echo $rows['productID']; ?>"></td>
<td align="center"><input name="numberAdded" type="text" id="numberAdded" size="5" value="<? echo $rows['productCount']; ?>"></td>
</tr>  

<?php  

}  

?> 



<?php
}
?>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><input name="remove" type="submit" id="remove" value="Remove From Pending"></td>

<td colspan="3" align="center" bgcolor="#FFFFFF"></td>

<td colspan="2" align="center" bgcolor="#FFFFFF"><?php showOrderList();?></td>
<td colspan="3" align="center" bgcolor="#FFFFFF"><input name="add" type="submit" id="add" value="Add"> </td>

</tr>
<?php
// Check if delete button active, start this
if($remove){
for($i=0;$i<$count;$i++){
$remove_id = $checkbox[$i];

$sql = "UPDATE _products SET pending='0' WHERE productID='$remove_id'";   

$result = mysql_query($sql);
}
// if successful redirect to inv_main.php
if($result)
{
echo "<meta http-equiv=\"refresh\" content=\"0;URL=pending.php\">";
}
}


// Check if add to order button is active
if($add){
for($j=0;$j<$count;$j++){
$add_id = $addcheckbox[$j];




$sql = "UPDATE _products, _productsonorder SET _productsonorder.quantity=_productsonorder.quantity+$numberAdded,_products.productCount=_products.productCount-$numberAdded WHERE _products.productID=_productsonorder.productID
AND _productsonorder.productID ='$add_id'";
$addresult = mysql_query($sql);
}

// if successful redirect page
if($addresult){
echo "<meta http-equiv=\"refresh\" content=\"1;URL=pending.php\">";
}
}



?>
</table>
</form>
</td>
</tr>
</table>

<?php

?>

</center>



<?php
mysql_close();
?>

Krik

You told us what you use to do.

You told use about a solution you think may work.

You showed us what you are currently have.

But you never told us what your are try to do.

Its a bit hard to answer a question that was never asked or expounded on.

mnewbegin

sorry, I called my post what I was trying to do?

'Need to update multiple text boxes when checkbox is present "

so I thought that was pretty direct asking?

Theres a set of checkboxes on the right, in the ADD column. When this is clicked I need to take the number that is in the box to the right of it, and some how put it into an array, so when I insert that into the tables, it adjusts the quantities.

My script all ready updates the quantities, but it takes the text box value from the last textbox, and uses that as the primary number since the text boxes are named the exact same thing.

Krik

I can be a bit dense when it come to questions. But I will say even that little bit more info did help me to see what your were trying to do.

Ok I am assuming that the "numberAdded" is the number that needs to be updated when the corresponding "addcheckbox" is checked.

Make the "numberAdded" an array also this will make it so "numberAdded[1]" and "addcheckbox[1]" are related so when you loop through them the corresponding fields will have the same index number and hence you can extract the value accordingly.

if($add){
    for($j=0;$j<$count;$j++) {

    $sql = "
    UPDATE _products, _productsonorder 
    SET _productsonorder.quantity = _productsonorder.quantity + " . $numberAdded[$j] . ", _products.productCount = _products.productCount - " . $numberAdded[$j] . "
    WHERE _products.productID = _productsonorder.productID AND _productsonorder.productID = '". $addcheckbox[$j] . "'
    ";

    $addresult = mysql_query($sql);
}

mnewbegin

I guess I'm a bit dense,

I don't think I have either array created right?

but the thing I don't get it handles the array of the checked boxes, for deleting and adding to order. And I dont think thats defined.

I guess I have a few holes to fill into my original code to make it work.

The original php code I called "code im working on" in my post is how my page looks now, I guess I don't understand how im associating the 2 arrays? correctly.