Perform the following tasks A. Create a table (users) in mysql database with following columns: User_id (varchar)
Question:
Perform the following tasks
A.
Create a table (users) in mysql database with following columns:
User_id (varchar)
Password (varchar)
Insert single record (memona,112) in the table
(show output here after taking the screenshort)
B.
create a web page for registration of user with 3 input fields (user id, password, re-enter password) and 1 submit button. The purpose of
This page is to get the information from user. When user hit the submit button the control will transfer to the next page i.e., registration_pro.php.
C.
On registration_pro.php, you need to check that user have entered the both passwords (password, re-enter password) same. If no, prompt user with alert message. Otherwise, you need to verify the user_id, which user entered to do registration, from database. If user_id already occupied, prompt user with alert message. Otherwise, successfully done the registration by inserting (user id, password) in the table, users.
(use your own name for registration)
(show php code here)
(show output of the code)
Show the table records also before and after data insertion through registration pages.
Quantitative Analysis for Management
ISBN: 978-0133507331
12th edition
Authors: Barry Render, Ralph M. Stair, Michael E. Hanna, Trevor S. Ha