Compare Checkboxes

[diesel77]

Im sure your all aware of those checkboxes on price comparison sites that allow you to compare product specs side by side....well thats what im trying to do with not much luck.

my checkboxes are not submitting the data to the results page

Im using Dreamweaver with a MySql database, so ive made a enum column for the Y - N values, set the default to N


What should i be doing? i cant really find any helpful tutorials on this.

should there be a recordset query on the results page that captures it?

[accelerator]

What language are you coding in? Post your script and people may be able to help.

Rgds

Accelerator

[tbp]

Post your code and i`ll show you how to fix it.

Be around a bit longer today, but have to go to hospital tomorrow. Will hopefully be recovered enough to be online in the evening, otherwise i`ll have a look friday.

[Donk]

Here's a piece of code that might give you some ideas:

PHP Code:

<pre>
<form method="post">
<?php
if ($_POST['check']){
foreach ($_POST['check'] as $key=>$value){
echo $key."--".$value."<br />";
}}

for ($i=0;$i<10 ;$i++)
{
?>
<input name="check[<?php echo $i;?>]" type="checkbox" value="Y" />
<? } ?>
<input name="submit" type="submit" value="Submit" />
</form>
</pre>

[diesel77]

Im not a coder just a dreamweaver, but making an effort to pick things up.
Remember this is inside a repeat region.

On the results page i have draged a data source that corresponds to the enum ('Y', 'N') table column from the Data Bindings panel ....so far its only returning 'N'

Ive tried toying with the following two codes (prod_check is my enum column)

<form action="un3.php" method="post" name="form1"><?php do { ?><table width="37%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><input type="checkbox" name="checkbox[<?php echo $row_Recordset1['prod_id']; ?>]" value="Y"></td>
      </tr>
  </table><?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?><p>
    <input type="submit" name="Submit" value="Submit">
    </p></form>

<form action="un3.php" method="post" name="form1"><?php do { ?><table width="37%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><input <?php if (!(strcmp($row_Recordset1['prod_check'],"Y"))) {echo "checked=\"checked\"";} ?> type="checkbox" name="checkbox[<?php echo $row_Recordset1['prod_id']; ?>]" value="Y"></td>
      </tr>
  </table><?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?><p>
    <input type="submit" name="Submit" value="Submit">
    </p></form>

[tbp]

With your code:

PHP Code:

<input name="check[<?php echo $i;?>]" type="checkbox" value="Y" />

You are half right. You have two ways of doing this. You can either do:

PHP Code:

<input name="check[]" type="checkbox" value="Y" /> 


Which would put all the results into an array called check, which you can read using

PHP Code:

$_POST['check'] 


Or you could give each input box a unique name eg

PHP Code:

<input name="check_<?php echo $i; ?>" type="checkbox" value="Y" />

You could then loop through the $_POST array, and see if the field contains "check" and then split it if it does to get the number eg

PHP Code:

foreach($_POST as $key=>$value){
  if(substr_count($key,"check") > 0){
    $temp = explode("_",$key)
    $variable_number = $temp[1];
    $variable_value = $value;
  }
} 


You just can't assign an index for the array in the HTML as you were doing.

[diesel77]

Hey Tbp,
Ive used your code, but im still getting the same problem.
I stuck a ";" before foreach and $variable_number as it was giving me a Parse error: syntax error

<form name="form1" method="post" action="un3.php">
<?php $_POST['check'];
  foreach($_POST as $key=>$value){ 
  if(substr_count($key,"check") > 0){ 
    $temp = explode("_",$key);
    $variable_number = $temp[1]; 
    $variable_value = $value; 
  } 
}  
?>  
  <?php do { ?>
    <table width="33%" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td><input name="check[<?php echo $row_Recordset1['prod_id']; ?>]" type="checkbox" value="Y" /></td>
      </tr>
          </table>
    <?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?><p>
    <input type="submit" name="Submit" value="Submit">
  </p>
  <p>&nbsp;</p>
</form>

Ive also tried

<td><input name="check[]" type="checkbox" value="Y" /></td>

<td><input name="check[<?php echo $i; ?>]" type="checkbox" value="Y" /></td>

<td><input name="check_<?php echo $i; ?>" type="checkbox" value="Y" /></td>

Im wondering if the problems lies with the ENUM Values in the database or something from the results page that would capture this?