Build user registration

When you decide to implement a user authentication The process of protecting a web site by requiring a user to enter an authorized ID and password before entering the site system for your site, the first step to take is to create a way for users to create accounts. This is the user registration process, which usually contains an insert transaction A transaction is a group of SQL statements whose effects are logically connected. Anything from simple queries to inserting, and deleting operations can be considered a transaction, as well as more complex groups of several statements which accomplish a specific task. (to add the user data into a table) together with some checks to make sure the user name is not taken, and that the confirmed password matches the entered passwords. MX User Login gives you the possibility of doing all of these actions in a single place, with the User Registration Wizard.

The User Registration Wizard is accessible from two locations:

• The MX Kollection tab of the Insert bar.
• The Application panel, Server Behaviors -> + -> MX Kollection -> User Login -> User Registration Wizard.

In order to be able to use the wizard, you must have MX Send E-mail installed, either as a separate product, or as part of the MX Kollection 3 bundle. Also, if you have MX Form Validation, a third step of the wizard will be available, allowing you to validate the form elements.

To set the dialog box options for the first step of the wizard, follow the instructions below:

1. The Connection, Table and Primary key column interface fields display the settings established in the login settings of the Control Panel. All login options are set globally.

2. If you want to change any of these settings, click the Change Login Settings button and the control panel entry mentioned above will be displayed.

3. The five buttons in the lower part of the interface offer the following functionalities:
   ·  With the < Back / Next > buttons you can navigate through the wizard's steps.
   ·  Click Finish when you are done configuring the wizard.
   ·  Click Cancel to exit without the new settings to be applied.
   ·  The Help button brings you to this help page.
   These buttons appear in all the User Registration Wizard steps.

4. Click Next to continue with configuring the wizard.

In the second step of the wizard, you will associate for each table column the form element to be displayed. To set the dialog box options, follow the instructions below:

1. In the Form fields grid, all table columns that are used in the transaction are displayed, with their associated properties: label, form element, submit type, and default value (where needed). You can add or remove columns to/from the transaction, with the + and - buttons placed on top of the grid, and you can change fields order with the up and down arrows above the grid.
2. Specify how each item should be displayed in the HTML form by selecting a row (single click) in the Form fields area and entering information in the boxes below the grid as indicated below.
3. In the Label text-box enter the text to be displayed next to the form element.
4. In the Display as drop-down menu select the form element to use for the table column. For the password field, you must select Password field, in order for the confirm password automatic generation and check. To read the detailed description for each of the available options, click here.
5. In the Submit as drop-down menu, select the data type to use when submitting information to the database A database refers to data organized and stored on a computer that can be searched and retrieved by a computer program. Most industrial-strength and many smaller database applications can be addressed using SQL (Structured Query A query is a SQL command that will extract information from the tables of a database. Essentially, a query is a request for information from your database. Language)..
6. In the Default value text-box enter a value that will be displayed by default in the form element, when the page loads.
7. Click Next to continue with configuring the wizard.

1. If you want to send welcome e-mail messages and if you want to use account activation, check the corresponding checkboxes.
   Note: The Use account activation checkbox is disabled if in the login settings of the Control Panel there is no table column specified that stores the account active state.
2. Click Finish when you are done configuring the wizard.

When you finish with the wizard configuration, it will add the HTML form, a Send E-mail trigger A trigger is a SQL procedure that performs an action when a transaction (INSERT, UPDATE, DELETE) occurs. You can use triggers to perform validation of input data, to automatically generate a value for a newly inserted row, to read from other tables for cross-referencing purposes, or to support alerts through e-mail messages. and a Throw error trigger. When you open the page in the browser, and try to register, the wizard will perform several actions:

• Check if the user name is unique.
• Compare the password field versus the confirm password field (if any).
• If everything went fine, insert the data into the table.
• As last action, send a welcome e-mail.