Check user name/email with Spry AJAX

When user is registering a new account it is often important to check user name or email for uniqueness to make sure it hasn't been already registered.

In this short tutorial you will learn how to build this functionality in Dreamweaver using standard Recordset, Show Recordset is not Empty Server Behavior and Spry Server Action object from  Spry Data Utilities Toolkit

Adding Spry Server Action

Click Spry Server Action icon located on the Spry tab of the insert panel.

In the dialog select "verify_email_form" from the Form dropdown.
Select "email_check_loader" image from the Display progress indicator dropdown.
Finally enter "checkEmail" as the function to be invoked upon success.



Click OK to insert the object.

Adding Database check

1.Create a new web page and save it as check_email.php (use another extension if you are using ASP, ColdFusion, etc.)

2.Switch to the Code View and delete all HTML.

3.Type the following:
This email address already exists in our database.\nPlease use another one.
Use new line character ("\n") to format the text.

4.Add a recordset which selects a record from your database based on submitted email address ("email" Form Variable):

5.Finally in the Code View select the text you have typed in step 3 and insert Show If Recordset Is Not Empty Server Behavior:

Conclusion

That's all! You can upload the files to your server and test the functionality.