How to store the user ID and password to the MySQL database

CREATE TABLE Tbl_auth_user ( USER_ID VARCHAR (Ten) is not NULL, User_password CHAR (+) not NULL, PRIMARY KEY (user_id) ); INSERT into Tbl_auth_user (user_id, User_password) VALUES (' Theadmin ', password (' Chumbawamba ')); INSERT into Tbl_auth_user (user_id, User_password) VALUES (' Webmaster ', password (' webmistress ')); Copy Code We will use the same HTML code to create the login form created in the example above. We only need to modify the login process a bit. Logon script: We must never forget to start the session Session_Start (); $errorMessage = "; if (Isset ($_post[' Txtuserid ')) && isset ($_post[' Txtpassword ']) { Include ' library/config.php '; Include ' library/opendb.php '; $userId = $_post[' Txtuserid '); $password = $_post[' Txtpassword '); Check that the user ID and password combinations exist in the database $sql = "Select user_id From Tbl_auth_user WHERE user_id = ' $userId ' and User_password = password (' $password ') "; $result = mysql_query ($sql) Or Die (' Query failed. ' . Mysql_error ()); if (mysql_num_rows ($result) = = 1) { Sessionthe set User ID and password matching, Setting up Sessions $_session[' db_is_logged_in ') = true; After logging in we go to the homepage Header (' Location:main.php '); Exit } else { $errorMessage = ' Sorry, wrong user Id/password '; } Include ' library/closedb.php '; } ?> Copy Code / /... The same HTML login form as in the previous example Instead of checking the user ID and password for hard-coded information, we query the database if both exist in the database using a select query. If we find a match we set the session variable and move to the home page. Note that the name of the session is prefixed with "db" to make it different from the previous example. In the next two scripts (main. PHP and logoff. PHP) code is similar to the previous one. The only difference is the session name. This is the code for both of these Session_Start (); is a visit to this page login? if (!isset ($_session[' db_is_logged_in ')) || $_session[' db_is_logged_in ']!== true) { No login, return to login page Header (' Location:login.php '); Exit } ?> Copy Code / /... Here are some of the HTML code Session_Start (); If the user is logged in, set the session if (Isset ($_session[' db_is_logged_in ')) { unset ($_session[' db_is_logged_in '); } Now, the user logs in, Go to login page Header (' Location:login.php '); ?> Copy Code

