Dynamic add to cart link

Hello

I'm working with dreamweaver cs4, mysql, webassist paypal extension, and php. I would like to create a products page that list the Name, Price, and a paypal add to cart link of all products on one page dynamically .

Example:

Stun Gun C $22.00 add to cart (links to paypal shopping cart for individual products)
Stun Gun S $32.00 add to cart
Black HD C $94.00 add to cart

I created a table, connected to a database, created a record set, and i've used the bindings panel to drag the name of the product and price.

Example:

Name Price Paypal
{rsProduct.title} {rsProduct.title} add to cart

How do I use the webassist extension to dynamically create a add to cart link for each product that come form the database?

the PayPal add to cart buttons are created as forms with hidden form elements for the name, price, description and other parameters.


When you select each of the hidden elements in design view, you can change the Initial value in the property inspector. Click the lightning bolt next to value and select the corresponding row from your record set.

You then need to encase the entire form in a repeat region so that it will be repeated for each record.

How would I do dynamic add to cart product option add to cart

Ex.

A drop down menu that would dynamic get its options from my data base

Stun Gun 100,000 - $22.00
Stun Gun 200,000 - $32.00
Stun Gun 300,000 - $36.00

make the price form element a select list.


set the label to be the option name and the value to the price. Then use javascript to change the value of the name field to the selected option, an example of this would look like:

<form name="form1" action="" method="post">
<select name="price" onChange="document.form1.name.value = document.form1.name.price[document.form1.name.price.selectedIndex].text"> 
<option value="22.00" selected="selected">Stun Gun 100,000</option>
<option value="32.00">Stun Gun 200,000</option>
<option value="36.00">Stun Gun 300,000</option>
</select>
<input type="hidden" name="name" value="Stun Gun 100,000" />
</form>

Since this is coming from the database shouldn't there be some dynamic php somewhere?

you would need to make the select list dynamic to use the recordset that contains your products options.