Web development tutorial

Tutorial created by Ray Borduin, WebAssist

Categories: eCart, PowerStore, Dreamweaver, MySQL, PHP

0 ratings | Sign in to rate this tutorial | View comments

Print tutorial
Share this tutorial

If you are requiring customers to be logged in and registered on your website prior to completing a purchase, you have the opportunity to automatically populate some of the details on the checkout page.
Fields such as Name, Address etc. can be automatically completed based on information entered into your database.

This tutorial guides you through binding the form fields on your eCart checkout page with the user information that is stored in your database.

next section

Requirements

If you have not yet set up the Login/Register functionality for your checkout page, review that tutorial now.

You should have the following items ready to go:

Dreamweaver CS 3 or higher
eCart checkout page with SecurityAssist login

next section

Creating the recordset

The first step is to create the recordset for the data you intend to display.

We will not be providing instructions for storing credit card details. This is an insecure practice and is not advised for any website.

In Dreamweaver, open the checkout page that was created by eCart.
From the Server Behaviors panel, choose Add > Recordset.
Enter a name for your Recordset.
For this example, we will enter rsUser.
From the Connection menu, choose your database connection.
From the Table menu, choose the database table that contains your user's information.
This needs to be the same database table that SecurityAssist used to create your register and login functionality.
Leave the All option selected for Columns.
From the Filter menu, choose the key column of your users table.
For the table in our example, the key column is UserID.
Leave = (equals) in the next menu.
Choose Session Variable from the next menu.
Enter UserID in the text field.
Click OK.

Binding the form fields

The next step is to bind the initial value of each of your form fields to the information for the user who is logged in.

Step 1: Basic form elements

Select the first form field to bind.
From the Properties Inspector, choose the Init val lightning bolt.
In the Dynamic Data window, expand the Recordset you just created.
Select the database column that matches the form field you have selected.
For example, if you selected the First Name field, choose the database column for first name.
Click OK.
Repeat this process for all other form fields.

Step 2: Menu Lists/Radio buttons

If you have menu lists or radio buttons that you want to set the initial value for, the steps are slightly different.

Select the menu list/radio button.
From the Properties Inspector, choose the Dynamic button.
Choose the set value equal to lightning bolt.
Select the appropriate recordset binding.
Click OK.

Reviews and comments

Comments will be sent to the author of this tutorial and may not be answered immediately. For general help from WebAssist, please visit technical support.

Sign in to add comments

0 ratings | Sign in to rate this tutorial

Automatically populate form fields on your checkout page

Step 1: Basic form elements

Step 2: Menu Lists/Radio buttons

Build websites with a little help from your friends

Build websites from already-built web applications

Want your website pre-built and hosted?

Everything else!

U.S. 858.201.4911 | International +1.858.201.4911

We've earned your trust.

Connect with us.