Operation Manual

683
Building applications visually
Last updated 11/30/2015
Note: Not all database providers support prepared commands. If your database does not support it, you might get an
error message when you run the page. Switch to Code view and change the Prepared property to false.
If the stored procedure takes parameters, you might create a page that gathers the parameter values and submits
them to the page with the stored procedure. For example, you may create a page that uses URL parameters or an
HTML form to gather parameter values from users.
More Help topics
Building a registration page
Note: The user interface has been simplified in Dreamweaver CC and later. As a result, you may not find some of the
options described in this article in Dreamweaver CC and later. For more information, see
this article.
About registration pages
Your web application can contain a page that requires users to register the first time they visit your site.
A registration page is made up of the following building blocks:
• A database table to store login information about the users
• An HTML form that lets users select a user name and password
You can also use the form to obtain other personal information from users.
• An Insert Record server behavior to update the database table of site users
• A Check New Username server behavior to make sure the user name entered by the user is not taken by another user
Storing login information about users
A registration page requires a database table to store the login information entered by users.
• Make sure your database table contains a user name and a password column. If you want logged-in users to have
different access privileges, include an access privilege column.
• If you want to set a common password for all users of the site, configure your database application (Microsoft Access,
Microsoft SQL Server, Oracle, and so on) to enter the password in each new user record by default. In most database
applications, you can set a column to a default value each time a new record is created. Set the default value to the
password.
• You can also use the database table to store other useful information about the user.
The next step in creating a registration page is to add an HTML form to the registration page to let users choose a
user name and password (if applicable).
Add an HTML form for selecting a user name and password
You add an HTML form to the registration page to let users select a user name and password (if applicable).
1 Create a page (File > New > Blank Page) and lay out your registration page using the Dreamweaver design tools.
2 Add an HTML form by placing the insertion point where you want the form to appear and selecting Form from the
Insert menu.