I have connected to a MySQL database through API Express. The MySQL table contains user info (name, address, username, password, etc..).
When App user enters Username & Password in Login page on my App I would like to check the MySQL table records for a match. If there is a match, then user is directed to a page on the App. If no match, then login error message.
Is there a script to check for a match?
Thank you in advance.
Hello Ed,
You can use simple MySQL query "SELECT", and check result on the event success. If server's response is empty - user is not found, else - user signed-in successfully.
Thank you Sergiy!
Would you happen to have a sample script that I can follow? Thanks.
Just use the mapping to hold
Don't quite follow.
Hopefully, Sergiy has a sample script that I can use.
Please look at this example of using SQL requests: https://devcenter.appery.io/documenta...
Thanks Sergiy.
I was able to setup the SQL SELECT query. Thanks!
How would I go about doing the following? Do I need a script?
"check result on the event success. If server's response is empty - user is not found, else - user signed-in successfully"
Hello Sergiy,
After setting up the SQL SELECT query through API Express what is the next step to validate Login? Can you provide the steps. Will I need a script? If so, do you have an example? Thanks.
Hello,
Can you provide a sample JAVASCRIPT for Login Validation to use on my App login page (that will validate Usernames & Passwords stored in MySQL Database)? Thanks.
I am following this thread and would like to see more details as well