check box & text box array

[maxtech]

<?

if(isset($_POST['Add']))
{
   $itemID=$_POST['itemID'];
   $itemprice=$_POST['itemprice'];

   for($i=0;$i<sizeof($itemID);$i++)
   {
      $query = "INSERT INTO table_1 (fCol1,fCol2) VALUES('".$itemID[$i]."',$itemprice[$i])";
      echo $query."<br>";
   }
} 

?>

<form action="" method="post" >
<table width="342" border="0" align="center">
  <tr>
Item 1<input type="checkbox" name="itemID[]" value="111" /> >>
Price<input type="textbox" name="itemprice[]" size="2" maxlength="2"/>
<br />         

Item 2<input type="checkbox" name="itemID[]" value="222" /> >>
Price<input type="textbox" name="itemprice[]" size="2" maxlength="2"/>
<br />         

Item 3<input type="checkbox" name="itemID[]" value="333" /> >>
Price<input type="textbox" name="itemprice[]" size="2" maxlength="2"/>
<br />         

  </tr>
</table>

<input name="Add"  type="submit" value="   Done   " />
</form>

when i check the Item 1
& Item 2 and enter the value in
the 1st and 3rd textbox and go for submission...
at that time i am missing the posted values of the text box?why?
coz some error is there too in d looping part.can any one find it out?

[bpat1434]

I don't think text-areas can be sent in an array, I think they have to be sent in strings. You have to change the name of the text-fields to something like:

<input type="textbox" name="itemprice_1" maxlength="2" />

and then in your loop just reference it as:

$_POST['itemprice_'.$i]

[maxtech]

🆒

[bpat1434]

<td width="2%"><input type="checkbox" name="chkPColorID[<?php echo $j; ?>]" value="<? echo $colRow['fColid']?>" /></td>

Use that, and then when you loop through, just use the key of the chkPColorID array and get the textbox number....

So in short:
chkPColorID[##], where ## is the same as ## in txtPCups##

[maxtech]

<?

if(isset($_POST['btnAddPr']))
{
	$item=$_POST['chkItem'];
	$quantity=$_POST['txtQty'];

 while (list ($key1, $val1) = each ($item))
 {
	 while (list ($key2, $val2) = each ($quantity))
	 {
			$query = "INSERT INTO tbl (fItem,fQuat) VALUES('".$val1."',$val2)";
			echo $query."<br>";
	 }  
 }    


}
?>

<form action="form.php" method="post" name="frmAddProd">
	   <table border="0" width="10%">
                <tr>
          <td width="24%">Item1 </td>
          <td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td>
          <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item2 </td>
      <td width="2%"><input type="checkbox" name="chkItem[]" value="Item2" /></td>
      <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item3 </td>
      <td width="2%"><input type="checkbox" name="chkItem[]" value="Item3" /></td>
      <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item4 </td>
      <td width="2%"><input type="checkbox" name="chkItem[]" value="Item4" /></td>
      <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>
    </tr>
          </table><input name="btnAddPr"  type="submit" class="box" id="btnAddPr" value="   Done   " /> 
</form>

i am not able to form a "checkbox,textbox" pair for database insertion.....y

[bpat1434]

THE TEXTBOXES WILL NOT BE STORED AS ARRAYS IN THE POST ARRAY. YOU HAVE TO REFER TO THEM INDIVIDUALLY.

I'm sorry, but 3 posts, and still the same issue. I know you're new, but come on.

if(isset($_POST['btnAddPr']))
{
	$item=$_POST['chkItem'];
	$quantity=$_POST['txtQty'];

 foreach($_POST['chkItem'] as $key=>$val)
 {
		$val2 = $_POST['txtQty'.$key];
		$query = "INSERT INTO tbl (fItem,fQuat) VALUES('".$val."',$val2)";
		echo $query."<br>";  
 }    
}

And your form needs to be set up like:

<td width="24%">Item1 </td>
          <td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td>
          <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty0" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>
</tr>
<tr>
<td width="24%">Item2 </td>
          <td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td>
          <td width="29%"><div align="center">X</div></td>

      <td width="7%"><input name="txtQty1" type="text" class="box" size="2" maxlength="2" />          </td>
      <td width="32%">Quantity</td>

[maxtech]

<?
if(isset($_POST['btnAddPr']))
{
    $item=$_POST['chkItem'];
    $quantity=$_POST['txtQty'];

 foreach($_POST['chkItem'] as $key=>$val)
 {
        $val2 = $_POST['txtQty'.$key];
        $query = "INSERT INTO tbl (fItem,fQuat) VALUES('".$val."',$val2)";
        echo $query."<br>";  
 }    
} ?>

<form action="ruf.php" method="post" name="frmAddProd">
<table border="0" width="10%">
<tr>
	<td width="24%">Item1 </td> 
	<td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td>
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="txtQty0" type="text" class="box" size="2" maxlength="2" /> </td> 
	<td width="32%">Quantity</td> </tr> <tr> <td width="24%">Item2 </td> 
	<td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="txtQty1" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>
	<tr> <td width="24%">Item3 </td> 
	<td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="txtQty2" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>
	<tr> <td width="24%">Item4</td> 
	<td width="2%"><input type="checkbox" name="chkItem[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="txtQty3" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>

</table>
<input name="btnAddPr"  type="submit" class="box" id="btnAddPr" value="   Done   " /> 
</form>

i think u didnt test the code properly.just try out with 3 to 4 "textbox,checkbox" pair.
In the above code 4 "textbox,checkbox" pairs are present.u can test it with that.after that
check off the first and fourth checkbox and enter values in the 1st and 4th textbox and go for submission.
then u wil get an o/p:

INSERT INTO tbl (fItem,fQuat) VALUES('Item1',32)
INSERT INTO tbl (fItem,fQuat) VALUES('Item1',)

[bpat1434]

i don't test the code, that's your job. I give you a foundation, or some type of system to think about and build on. If you want me to write your code for you, it's gonna cost you.....

Oh, and by the way: it does work, you're just not posting to the right form..... check the form action and try again....

[maxtech]

yah i had posted to the right form inded. but i am not able to get all the posted values

[bpat1434]

I'm an idiot.... here's a fixed version:
It does work... and you can have as many inputs as you need.

<?php

if(isset($_POST['btnAddPr']))
{
	$item=$_POST['Item'];

echo '<pre>';
var_dump($item);
echo '</pre>';

$query = "INSERT INTO tbl (fItem,fQuat) 
		VALUES";
for($i=0; $i<count($item); $i++)
{
	if(!empty($item[$i]))
	{
		$query .= " ('".$item[$i]."', '";
		$i++;
		$query .= $item[$i]."'),";
	}
}
$query = substr($query, 0, -1);

echo nl2br($query);
} 
?>

<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post" name="frmAddProd">
<table border="0" width="10%">
<tr>
	<td width="24%">Item1 </td> 
	<td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td>
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="Item[]" type="text" class="box" size="2" maxlength="2" /> </td> 
	<td width="32%">Quantity</td> </tr> <tr> <td width="24%">Item2 </td> 
	<td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="Item[]" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>
	<tr> <td width="24%">Item3 </td> 
	<td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="Item[]" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>
	<tr> <td width="24%">Item4</td> 
	<td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td> 
	<td width="29%"><div align="center">X</div></td> 
	<td width="7%"><input name="Item[]" type="text" class="box" size="2" maxlength="2" /> </td>
	<td width="32%">Quantity</td>   

	</tr>

</table>
<input name="btnAddPr"  type="submit" class="box" id="btnAddPr" value="   Done   " /> 
</form>

[maxtech]

shld i give the same name ie, "Item[]" to both checkbox and textbox.

[bpat1434]

yeah... just like the code I posted. 😃

[maxtech]

this naming wil create a problem later bcoz when we check one checkbox and enter the values 1,2,3,4 in all textboxes
it wil create wrong queries like:

[B] Notice: Undefined offset: 5 in /var/www/test/test.php on line 14
 INSERT INTO tbl (fItem,fQuat) VALUES ('Item1', '1'), ('2', '3'), ('4', ''),

[/B]

[bpat1434]

Okay, so that sounds like a problem that deals with structure and setup, not PHP code. Time to sit down in a think tank and conjur up some ideas....

[maxtech]

<?

if(isset($_POST['btnAddPr']))
{

$item=$_POST['Item'];
$qty=$_POST['Quantity'];

while (list ($key1, $val1) = each ($item)) 
	{ 
	   while (list ($key2, $val2) = each ($qty)) 
	   { 
			//checks to see which textbox aligns with this checkbox
			if($key1!=$key2)continue;
			//key1 holds the checkbox index
			//$val1 will most likely hold the value "on" or "true" which is useless
			$query = "INSERT INTO tbl (fItem,fQuat) VALUES('".$val1."',$val2)"; 
			echo $query."<br>"; 
	   }  
	}    
}
?>

<form action="" method="post">
	   <table border="0" width="10%">
                <tr>
          <td width="24%">Item1 </td>
          <td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td>
          <td width="29%"><div align="center">X</div></td>
          <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item2 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item2" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item3 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item3" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item4 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item4" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
          </table>
<input name="btnAddPr"  type="submit" class="box" id="btnAddPr" value="   Done   " /> 
</form>

i just tried with the above code but it doent get affected due to some loopng probs ????

[bpat1434]

Okay, so using your current form, you can do the following to display your stuff:

<?php

function notempty($var)
{
	return (!empty($var));
}

if(isset($_POST['btnAddPr']))
{
	$item=$_POST['Item'];
	$qty = $_POST['Quantity'];
	$quantity = array();

$qty = array_filter($qty, "notempty");
foreach($qty as $key=>$val)
{
	$quantity[] = $val;
}
$qty = $quantity;

echo '<pre>';
var_dump($item);
var_dump($qty);
echo '</pre>';

$query = "INSERT INTO tbl (fItem,fQuat) 
		VALUES";
foreach($item as $key=>$val)
{

		$query .= " ('".$val."', '";
		$i++;
		$query .= $qty[$key]."'),";
}
$query = substr($query, 0, -1);

echo nl2br($query);
} 
?>
<form action="" method="post">
	   <table border="0" width="10%">
                <tr>
          <td width="24%">Item1 </td>
          <td width="2%"><input type="checkbox" name="Item[]" value="Item1" /></td>
          <td width="29%"><div align="center">X</div></td>
          <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item2 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item2" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item3 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item3" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
            <tr>
      <td width="24%">Item4 </td>
      <td width="2%"><input type="checkbox" name="Item[]" value="Item4" /></td>
      <td width="29%"><div align="center">X</div></td>
      <td width="7%"><input name="Quantity[]" type="text" class="box" size="2" maxlength="2" />          </td>

      <td width="32%">Quantity</td>
    </tr>
          </table>
<input name="btnAddPr"  type="submit" class="box" id="btnAddPr" value="   Done   " /> 
</form>

That works for me