MySQLi Check New Username

In order to prevent duplicate user registrations, a check must be performed on new user registrations in order to make sure the username (often an email address) doesn't already exist in the table containing your user records. MySQLi Check New Username accomplishes this task by searching a table for any matches using the value and column of your choosing.

Check New Username - General

  1. Use the Trigger select list and associated Trigger Dynamic Data button to select the event in which username lookup will occur..
    • Any Form Post: Any form posted to the current page that the server behavior is applied to triggers the data insert
    • Before Page Load: The data insert is triggered when the current page that the server behavior is applied to is loaded.
    • On Form Submit: Any form submitted on the same page that the server behavior is applied to trigger the data insert.
    • Button [button name] pressed: The server behavior is triggered if the specified button on the page is clicked.
    • Dynamic Data: Server-side code can be specified in the dynamic data interface (accessed through the lightning bolt) to create a trigger specific to your needs if one in the list does not meet your requirements
  2. Use the Connection and Table menus to specify the database table that contains the column you wish to search..
  3. Use the Failure Redirect field and it's associated file browse button to select a page you would like to redirect to in the event that a lookup is successful

 

Check New Username - Find Record

  1. Enter the value you you wish to 'search' for in your table. Select the column you wish to search and either enter a static value, a variable, or use the associated Dynamic Data button to select a value from Bindings.
  2. Make a selection in the Submit as list to designate the data type you will be comparing your value to. In most cases, this will be preset for you based on your column type. However, you can select any of the following:
    • Text
    • Integer
    • Double
    • Date
    • Checkbox Y,N
    • Checkbox 1,0
    • Checkbox -1,0

After clicking OK, the Check New User Server Behavior will be applied to the current page. Changes can be made by editing the MySQLi Check New User Server Behavior from the Server Behaviors panel.