passing more than one variable in a checkbox

tcooper02

I have a form that displays a table with a checkbox along with name, description, vendor, date, cost and comments. I can display the table from the database, but if I select 2 checkboxes maybe from 10 records, I get the results from 2 selections but always the last record. This is what I have:

echo "<form method='post' action='purchview.php?'>";
echo "<table border='1'>";
echo "<tr> <th>Selection</th> <th>Name</th> <th>Description</th> <th>Vendor</th> <th>Date</th>
<th>Cost</th> <th>Comments</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array($table))
{
// Print out the contents of each row into a table
echo "<tr>";
echo "<td><input type='checkbox' name='chkbox[]'
value='on'
<? if($chkbox==='on') {echo 'checked';}?></td>";
echo "<td><input type='Text' name='user_name' value={$row['user_name']}></td>";
echo "<td><input type='Text' name='Description' value={$row['Description']}></td>";
echo "<td><input type='Text' name='Vendor' value={$row['Vendor']}></td>";
echo "<td><input type='Text' name='Date' value={$row['Date']}></td>";
echo "<td><input type='Text' name='Cost' value={$row['Cost']}></td>";
echo "<td><input type='Text' name='Comments' value={$row['Comments']}></td>";
echo "</tr>";
}
echo "<td>$row<align='center'><input type='submit' name='submit' value='submit'></td>";
echo "</table>";
echo "</form>";

This is what I have for purchview.php:

<?php
foreach ($POST['chkbox'] as $value)
{
echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Description</th> <th>Vendor</th> <th>Date</th>
<th>Cost</th> <th>Comments</th> </tr>";
// Print out the contents of each row into a table
echo "<tr><td>";
echo "$POST[user_name]";
echo "</td><td>";

echo "$POST[Description]";
echo "</td><td>";
echo "$POST[Vendor]";
echo "</td><td>";
echo "$POST[Date]";
echo "</td><td>";
echo "$POST[Cost]";
echo "</td><td>";
echo "$_POST[Comments]";
echo "</td>";
echo "</tr>";
echo "</table>";
}
?>

Please help!!!! Thanks, tcooper02

Weedpacket

The other fields (user_name, Description, etc.) need to be arrays, too. You'd be well-advised to put indexes in the field names as well, chkbox[0], chkbox[1],..., user_name[0], user_name[1], ... as well so that all those arrays stay in sync. Otherwise if one of the descriptions (say) is missing, there will be no way of telling which one it was.

rahaiffi

Amnser my question first.....

phpstuck

Use the following to set the varible and it it will send all of different checkbox values (checked) in the particular ARRAY the ", " just says a comma then a space will seperate them in the database.

$String1 = implode(", ", $_POST['array name here']);

//insert into DB below

tcooper02

Thanks Weedpacket. I made the other fields arrays, user_name[0], Description[0], etc but when I hit submit after selecting only 2 checkboxes for the rows i'd like, I get 2 rows as I want, but still receiving the last record. Is there something I need different in the php code that will report my results? This is my first stab at mysql/php so your help is very much appreciated. Thanks again

Weedpacket

Because the fields are now arrays, they have to be treated like arrays. Do you know how many of these rows there will be?

for($i=0; $i<$total_rows; $i++)
{
   if(!isset($_POST['chkbox'][$i])) continue; // This one wasn't checked.
  echo "<table>";
  //...yadayada e.g.,
   echo $_POST['Comments'][$i];  // The comments that go with the $ith checkbox.
}

tcooper02

Place the following and not getting anything on the following php:

<?php
foreach ($POST['chkbox'] as $value)
{
for($i=0; $i<$total_rows; $i++)
{
if(!isset($POST['chkbox'][$i])) continue; // This one wasn't checked.
echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Description</th> <th>Vendor</th> <th>Date</th>
<th>Cost</th> <th>Comments</th> </tr>";
// Print out the contents of each row into a table
echo "<tr><td>";
echo $POST[user_name][$i];

echo "</td><td>";

echo $POST[Description][$i];
echo "</td><td>";
echo $POST[Vendor][$i];
echo "</td><td>";
echo $POST[Date][$i];
echo "</td><td>";
echo $POST[Cost][$i];
echo "</td><td>";
echo $POST[Comments][$i];
echo "</td>";
echo "</tr>";
echo "</table>";
}
}

?>

Weedpacket

Lose this:

 foreach ($_POST['chkbox'] as $value)
{

(and the matching };

set error reporting to E_ALL; and fix the problems it will alert you to
use print_r($_POST) to see exactly what you're getting
In the original code <? if($chkbox==='on') {echo 'checked';}?></td>"; doesn't have much use - where is $chkbox supposed to get its value from?
And in case you misunderstood what I said in the first place, change the loop in the original code so that it keeps a counter $i (starting from 0) and name the fields user_name[<?php echo $i?>] so that all the fields on the same row have the same index, and all the fields on different rows have different indices

tcooper02

could you show me what you mean in #5? i'm getting results, but still the last record but now with $i, i'm only receiving the 1st character of each field i'd like to echo. I am very new with this, but understanding once led:

<?php
error_reporting(E_ALL);
print_r($POST);
for($i=0; $i<6; $i++)
{
if(!isset($POST['chkbox'][$i])) continue; // This one wasn't checked.
echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Description</th> <th>Vendor</th> <th>Date</th>
<th>Cost</th> <th>Comments</th> </tr>";
// Print out the contents of each row into a table
echo "<tr><td>";
echo ($POST['user_name'][$i]);

echo "</td><td>";

echo ($POST['Description'][$i]);
echo "</td><td>";
echo ($POST['Vendor'][$i]);
echo "</td><td>";
echo ($POST['Date'][$i]);
echo "</td><td>";
echo ($POST['Cost'][$i]);
echo "</td><td>";
echo ($POST['Comments'][$i]);
echo "</td>";
echo "</tr>";
echo "</table>";
}

?>

thanks again for your help and hopefully this response will get me across the hurdle.

Weedpacket

tcooper02 wrote:
...i'm only receiving the 1st character...

So, your form fields, how have you named them? When you look at the code in the browser you should be seeing something like

<td><input type='Text' name='Description[0]' value=wibble></td>

and

<td><input type='Text' name='Cost[5]' value=42></td>

(And I notice here that you've forgotten to put quotes around the value= attribute's value. That will cause problems as soon as "wibble" is a description with a space in it.)