Storing login information about users (ColdFusion, ASP, JSP, PHP)
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).