|
|
|
|
Once the user authentication system is in place, you can continue and construct the rest of the application. The first thing to do now is display a list of available products. And since the view_products page was selected as the default redirect when the login operation is successful, it will be created first.
To create the page elements follow the next steps:
Open the view_products page in Dreamweaver.
The page will display all available products in the database. To retrieve them, you must create a recordset. Click on the Plus (+) button of the Bindings tab, and select the Recordset (Query) option.
In the dialog box that opens enter a name for
the recordset (e.g. rsProducts), select the
connOrders database connection created at
the beginning of the tutorial and the product_prd
table.
After you've set the new recordset options, click OK to add it to the page.
To display the records from the newly created
recordset, you will use a dynamic table. You can add a Dynamic
Table from the Application tab of
the Insert bar. Configure it to display
all records and set border, padding and spacing options according to your
particular taste in design:
The table displays all recordset retrieved columns, including the product ID, which is of no use for the end-user. Therefore, remove this column entirely. Also, change the column headers from the table column names into something more human readable (e.g. name_prd into Name, price_prd into Price, quantity_prd into Available) and set the Header property on them.
What the user is interested in is the possibility of adding one of the products to his or her order. To do so, you must add a new link next to each product, pointing to the add_to_order page. And in order for the page to recognize the product to add, you must pass its ID as an URL parameter.
To add the new link, create a new column at the end of the table. Right click in one of the last cells and select Table > Insert Rows or Columns. Add a new column after the current selection. In the second cell, enter the "Add to order" text. Right click on it, and select the Make link option. In the dialog box select the add_to_order page, and then click on the Parameters button to define the URL parameters to pass.
Add a new parameter named id_prd,
and for the value click the Dynamic Data
icon. Select the id_prd field of the rsProducts recordset:
Confirm the changes to all interfaces, by clicking
the OK buttons. Save the page and upload
it to the server. To access it, you must have created your own account
or use one of the pre-made user names.
Below the product list, a series of links must be available for the visitor in order to allow completing or clearing the order. If using the files from the zip package, these links are already on page (except the logout), but if you've created a blank file you must manually add them:
View order - link to view_order.
Clear order - link to clear_order.
Complete order - link to complete_order.
Logout - to create this link, enter the text,
select it, and apply the Logout User server
behavior from the Server Behaviors Tab > + >MX
Kollection > User Login. In the dialog box that opens, set the
redirect page to the site index and click OK to apply it.
Now that the product list page is completed, you can continue and create the logic in the add_to_order page, that will add a new element to the order.