check box issues

[ricrhys]

so my page is slowly coming on, thanks to help here, i now have a problem with check boxes, the idea is that the user can check multiple boxes, then click submit and go to page or check out where there order is displayed, im using the refcode of the games as the primary key, i need to know how to do a loop that runs through the boxes to see if they are checked?

this is the line of code i used to generate the boxes, will this enable me to use the ref code as the key

echo "<input type='checkbox' name='box' value=''" . $rowl['refcode'] .">";

cheers ric

[illzz]

Hi there again!

Try changing:

echo "<input type='checkbox' name='box' value=''" . $rowl['refcode'] .">";

to:

echo "<input type='checkbox' name='box[]' value='" . $rowl['refcode'] . "' />";

Changes:
1 -- box -> box[] -- On the "action" page, the value of $_POST['box'] will be an array containing the values of the boxes that were checked.

2 -- moved the 2nd single quote after the refcode.
Original syntax: value=''refcode
Fixed syntax: value='refcode'

3 -- Closed the input with />. To make it valid... that is, unless is is being closed outside of the code you posted.

Note: if this is from the loop I supplied in the other thread, then I believe that the variable is $row instead of $rowl.

[ricrhys]

me again and guess what im still struggling here, i cant work out the foreach loop to see what boxes are ticked
heres what ive got

echo '<form name="chec" action="cart.php" method="post">'; 

foreach ($row as $box)
{
$res = pg_query ($conn, "select title, description, price from TopGames where $_POST[box]")
}
{
echo "<table border='1'>";

while ($laRow = pg_fetch_row($res)) {
echo "<tr>";
{
echo "<td>";

}
{
echo "<input type='checkbox' name='box[]' value='" . $row['refcode'] ."' />";
}
{
echo "</td>";

[illzz]

Disclaimer: This code is untested.

The problem with your foreach loop is that you are redefining $res before doing anything with it. There was also a problem with the WHERE clause in your database query.

In this case try using Implode.

<?php
  $lsWhereClause = " WHERE (refcode='" . implode("' OR refcode='", $box) . "' ";
  $res = pg_query ($conn, "select refcode, title, description, price from TopGames " . $lsWhereClause . ";")
?>

As for the rest of the code, it looks like you're going a little overboard with the brackets.
Try this:

<?php
  echo '<form name="chec" action="cart.php" method="post">';
  echo "<table border='1'>";
  while ($laRow = pg_fetch_row($res))
  {
    echo "<tr>";
    echo "<td>";
    echo "<input type='checkbox' name='box[]' value='" . $laRow['refcode'] ."' />";
    echo "</td>";
    echo "</tr>";
  }
?>