close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Is there a User Authentication tutorial for the mysqli server behaviours, I can't get it to work from the help file

Thread began 5/27/2020 2:02 pm by Stephen | Last modified 6/04/2020 12:33 pm by Ray Borduin | 30 views | 6 replies |

Stephen

Is there a User Authentication tutorial for the mysqli server behaviours, I can't get it to work from the help file

I have added the Restrict access to the page, and added a form with username and password field, then I added the Mysqli Log in User, but this is where I don't understand, where does one specifiy that the form must check the database, and where does one specify that the form submit must perform the task of checking the login, and then redirecting to the relevant pages?

I can't seem to make head or tails of the help manual attached to the behaviour.

Sign in to reply to this post

Ray BorduinWebAssist

Please attach the login page you are working on so I can see what you have done and I can comment on where you might have gone wrong.

The mysqli login user server behavior allows you to chose the database table you are looking up the registered user in and then in the Filter tab you can choose which column(s) to compare to which field(s) in the database before logging in. It also allows you to specify a success and failure redirect based on the result of that login.

Sign in to reply to this post
Did this help? Tips are appreciated...

Stephen

My test code for trying the behavior

Originally Said By: Ray Borduin
  Please attach the login page you are working on so I can see what you have done and I can comment on where you might have gone wrong.

The mysqli login user server behavior allows you to chose the database table you are looking up the registered user in and then in the Filter tab you can choose which column(s) to compare to which field(s) in the database before logging in. It also allows you to specify a success and failure redirect based on the result of that login.  
Sign in to reply to this post

Ray BorduinWebAssist

You are filtering the login with the result from a recordset. You should be using the form element values. You don't even need a recordset on the login page at all.

Sign in to reply to this post
Did this help? Tips are appreciated...

Stephen

My test code for trying the behavior

I am still unable to get it working

Sign in to reply to this post

Ray BorduinWebAssist

Open the user authentication server behavior by double-clicking on it in the Server Behaviors panel.

Then go to the "Filter" tab and select the username column and click the lightning bolt. Go to the FORM and the input field where you want people to enter their username. Now do the same thing for the password field on this tab.

Then click OK. Right now you don't have any filters to allow access, so everything would work. It isn't checking the form input at all.

Sign in to reply to this post
Did this help? Tips are appreciated...

Stephen

My test code for trying the behavior

Thank you, much appreciated.

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...