How to compare values in login page with values from database in App Designer?

2 views (last 30 days)
Yusof Zainol Abidin
Yusof Zainol Abidin on 4 Jan 2021
I want to get the editfield values and compare it with the value in database for login purpose. Can anyone help me?
This is my code to compare the values.
a=app.UsernameEditField.Value;
b=app.PasswordEditField.Value;
conn = database('Wicapp','root','');
v = exec(conn,'select Username from wicapp.users');
w = exec(conn,'select Password from wicapp.users');
v=fetch(v);
w=fetch(w);
v1=v.Data;
w1=w.Data;
if strcmpi(a, v1)&&strcmpi(b,w1)
run('receive_try_interface.mlapp')
end

Answers (1)

Prabhanjan Mentla
Prabhanjan Mentla on 9 Jan 2021
Hi,
You can follow this steps.
  • You can open connection
  • Check whether user exists in the database with the help of this type of sql query.
  • If user exists then, fetch the password and compare it with the given password.
  • If both passwords match then “Login Success” else login fail.
To connect from Appdesigner to a database toolbox you can check this link. I recommend you to go through the Database Toolbox documentation from here.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by