Checkbox method for add to cart

Step 1: The form

The layout table and form structure I will be using for this tutorial is as follows:

<form method="POST" action="<?php echo $_SERVER["PHP_SELF"]; ?><?php echo (isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] != "")?"?".$_SERVER["QUERY_STRING"]:""; ?>">

<table width="600" border="0" cellspacing="0" cellpadding="0">
           
              <tr>
                <td width="200"><input name="itemchecked[]" type="checkbox" value=""> </td>
                <td width="200" align="right">Quantity:<input name="qty_" type="text" value="1" size="3" ></td>
                <td width="200" align="right"></td>
              </tr>
             
          </table>

          <br>
          <input name="WebCartATC" type="submit" value="Add to Cart">

          </form>

A few points I would like to make at this point...

Step 2: The recordsets

We will require 2 recordsets for this tutorial.

The first being the main recordset that will contain any filters you require (such as filtering for categories if its a last catelogue of items in your store)

The second recordset will contain an un-filtered version of the above (this will be required for the search filter that will be explained futher on)

Step 3: The bindings

Next we need to add the bindings to the layout and form.

rsItems - this recordset is used for display output, so it is this we will be creating the bindings of the table and form in the code provided previously.

rsATC - (ATC just stands for Add to Cart so its just a reference for this tutorial) This recordset will be used to filter the checkboxes using the DataAssist Search server behaviour.

So using the bindings panel and making sure you only use the bindings for the rsItems recordset set up your display, making sure specifically you bind the following form elements as well...

1. Bind the ID of the rsItems recordset for the value of the input checkbox

2. Bind the ID of the rsItems recordset to 'qty_' which forms the name of the quantity input box.

Since you will have have multiple items you will need to add a repeat region inside the <table> and </table> tags

Your final code should look like this:

<form method="POST" action="<?php echo $_SERVER["PHP_SELF"]; ?><?php echo (isset($_SERVER["QUERY_STRING"]) && $_SERVER["QUERY_STRING"] != "")?"?".$_SERVER["QUERY_STRING"]:""; ?>"><table width="600" border="0" cellspacing="0" cellpadding="0">
            <?php do { ?>
              <tr>
                <td width="200"><input name="itemchecked[]" type="checkbox" value="<?php echo $row_rsItems['ItemID']; ?>"> <?php echo $row_rsItems['ItemName']; ?></td>
                <td width="200" align="right">Quantity:<input name="qty_<?php echo $row_rsItems['ItemID']; ?>" type="text" value="1" size="3" ></td>
                <td width="200" align="right"><?php echo WA_eCart_DisplayMoney($WebCart, $row_rsItems['ItemPrice']); ?></td>
              </tr>
              <?php } while ($row_rsItems = mysql_fetch_assoc($rsItems)); ?>
          </table>
          <br>
          <input name="WebCartATC" type="submit" value="Add to Cart">
          </form>

Step 1: Adding the DataAssist Search Behaviour

From the Dreamweaver Server Behaviours Panel, locate and select the DataAssist Search server behaviour.

WebAssist -> DataAssist -> DataAssist Search

Step 2: Configure the DataAssist Search

1. Set the Trigger to the Button (However its not really necessary since you can just simple select any form post (However I always make it good practice to be specific with form submits buttons)
2. For the recordset select the rsATC recordset.
3. For the Default WHERE clause - make sure you enter 0=1
4. Now click on the + icon

5. Seperate - Leave on default
6. Column - Select ItemID
7. Column Type - Leave on default (Number/Boolean)
8. Comparison - Leave on default (=)
9. Filter Type - Make sure you have selected List

10. List field name - The name of the input checkbox on the HTML form, in this case the name being, 'itemchecked'.

11. Click Finish

Step 1: Locating the Get Contents From Recordset Server Behaviour

From the Server Behaviours panel click on the + to add a new server behaviour and navigate to:

eCart -> Add to Cart -> Get Contents From Recordset

Step 2: Configure the Get Contents From Recordset Server Behaviour

As before as a code of practice I would select the button as the Trigger and again making sure you use the rsATC recordset for this server behaviour's recordset.

Then using the lightening bolt and making sure you use the bindings from the rsATC recordset fill in each of the Values for the corrisponding Cart Columns.

When you get to Quantity you will need to enter the form input binding, however as this has no named value you will need to manually enter it in rather then selecting it..so copy and paste this for the Value of the Quantity Cart column:

<?php echo ((isset($_POST["qty_".$row_rsATC['ItemID']]))?$_POST["qty_".$row_rsATC['ItemID']]:""); ?>

For the 'After operating' Redirect - Enter the page that will display the shopping cart (Usually cart.php)

Now click on OK and your done!