Programming SLQ

Question

COMMA-SEPARATED VALUES 

Maximum of 3 members each group. Create a program that simulates a simple registration and login function. Your program should access, write, edit and update data in the credentials.csv file.

Note: Create your own credentials.csv file. Add one record having the following value:

           Juan Dela Cruz, January-1-1995, [email protected], Admin, 123456

STEP 1: At the start of the program execution, it should prompt the user of the following options:

1. Register
2. Login

STEP 2: If the user chose option #1, the program will prompt the user on the following fields:

1. First Name
2. Middle Name
3. Last Name
4. Date of birth
5. Email address
6. Username
7. Password
8. Confirm Password

 

STEP 2a: Password and Confirm Password should match, thus, incorrect inputs on those 2 fields should not be accepted.

STEP 2b: After filling up the fields correctly, the program will then display the following:

1. Display Profile
2. Reset Password
3. Log-out

STEP 2c: Options #1 - Display Profile and #2 - Reset Password’s functions are optional. No need to code it for the meantime. Option #3 – Log out, once selected, should redirect the user to STEP 1’s display.

STEP 3: If the user chose option #2, the program will prompt the user on the following fields:

1. Username
2. Password

STEP 3a: The username and password should match with the records present in the credentials.csv, that means, the program should be able to validate the user’s input with the data in the file. Assuming the user incorrectly entered the wrong password, the program should return an error message corresponding to that action.

STEP 3b: If the user successfully logged in his/her account, it will show the same display as that of STEP 2b. Likewise, the only functioning option in that display is Option #3 – Log out, which when selected, will redirect the user to STEP 3’s display.

STEP 4: Save your program and the credentials.csv and add it in a compressed/zip file named Module5_<GroupName-SectionAndStrand>. 

Answer 1

SELECT * from CREDENTIALS where USERNAME = username AND EMAIL=email;

INSERT INTO CREDENTIALS values (firstName,middleName,LastName,DOB,email,userName,pw);

UPDATE CREDENTIALS Set PASSWORD=pw where USERNAME=username and Email=Email