Lab Exercise: Design a User Login Page Using Authentication with a Database Table
Objective: Be familiar with user authentication
Steps:mysql> insert into users (user_name, user_email, user_password, joining_date) values ('jamoore', 'jamoore@txwes.edu', md5('csc6341'), now()); Query OK, 1 row affected (0.00 sec) mysql> select * from users; +---------+-----------+-------------------+----------------------------------+---------------------+ | user_id | user_name | user_email | user_password | joining_date | +---------+-----------+-------------------+----------------------------------+---------------------+ | 1 | yzhang | yzhang@txwes.edu | d167119c3234bd9b478c932ebf131a66 | 2024-10-20 23:43:55 | | 2 | sshree | sshree@txwes.edu | d167119c3234bd9b478c932ebf131a66 | 2024-10-20 23:44:30 | | 3 | pgautam | pgautam@txwes.edu | d167119c3234bd9b478c932ebf131a66 | 2024-10-20 23:44:49 | | 4 | jamoore | jamoore@txwes.edu | 54ff7d4facb506eafd9a4e878d7cac10 | 2024-10-22 23:01:19 | +---------+-----------+-------------------+----------------------------------+---------------------+ 4 rows in set (0.00 sec)