close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQLi User Authentication

Thread began 6/23/2014 7:57 pm by randyrie405335 | Last modified 6/24/2014 1:46 pm by Jason Byrnes | 1009 views | 3 replies |

randyrie405335

MySQLi User Authentication

Your MySQLi User Authenticate tutorial is of little help so I need detailed help how to setup authentication with various access levels. Here is what I need: Database table has fields including Username, Password and AccessLevel (Admin or Membership). The access level is to have either an "Admin" or a "Member" level. So with a single sign-on, the logon setup should determine which pages the user can view, depending on which level is set for each limited-access page. I have no idea how to use your extension's setup screens to accomplish this.

Sign in to reply to this post

Jason ByrnesWebAssist

MySQLi User Access cant do single login user levels like this.

You would need to create a Login for each user level. In the login behavior, the first ssetting is to set the login name. Use a unique nale for each login.

On the Find Record Tab, set it to filter the Username and Password columns on the login form elements, for the user level, enter the user level value Admin for the admin login and Member for the member login, etc.

When applying the restrict access behavior to a page, select the corresponding login name.

Sign in to reply to this post

randyrie405335

So an Admin would have to also logon as a Member to view the Member pages, etc., etc? Is there a way the add both Member and Admin to the Admin logon so an administrator can view all restricted pages and still restrict a Member to view only the Member-restricted pages? Is there someway to tweak the code to permit this?

Sign in to reply to this post

Jason ByrnesWebAssist

No, There is not a way to do single login with user levels, the admin would need to login as admin to view admin pages and login as memeber to view member pages.


When Data Bridge is updated to use MySQLi, it will possible to use Security Assist to create user level authentication.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...