MySQLi Log In user

Log In User, when used in conjunction with Restrict Access To Page and Log Out User, provides the neccessary functionality for restricting your sites content to certain users. Log In User will compare the stored username and password in the table of your choosing to that entered by your user. Their logged in state will be maintained in a session variable and will persist until they log out or the session expires.

Log In User - General

  1. Use the Login Name field to specify a unique identifier for your login, restrict access, and log out functionality. Multiple login types (user, admin, etc) can be held using multiple Login Names.
  2. Use the Trigger select list and associated Trigger Dynamic Data button to select the event in which login processing 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
  3. Use the Connection and Table menus to specify the database table that contains the column you wish to search..
  4. Use the Success Redirect field and it's associated file browse button to select a page you would like to redirect to in the event that a login is successful.
  5. Use the Return to restrticted page (when applicable) checkbox to redirect back to a restricted page after successful login.
  6. User 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 login attempt fails.

Login User - Find Record

  1. Enter the values (username and password) 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 values 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

Login User - Store Values

  1. Enter the session variable names you would like the corresponding columns from your log in record stored as. These values will only be stored in the event of a successful login.

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