(PHP)

1) Create a database with the following requirements:

- Name: userdb

- Table: usertb

- Fields: username, password

Add these 2 records to the table:

- userone, pwo

- usertwo, pwt

2) Write and test a function that has the following requirements:

- the function accepts 2 variables (username & password)

- the function connect to the database created in section 1 (above)

- the function returns true if the username exist in the database and matches its password else, it returns false

- remember to close the connection to the database before the return so other parts of this program will work properly

3) Create a login interface and 2 additional pages with the following requirements:

- login page (name it as login.php) that uses the function created in section 2 (above) to authenticate the login information submitted by the user

- if the login information passes, then give the user access to the main page (name it as main.php). The main page displays the records (all records) of the table usertb (created in section 1 above)

- the main page also has a link that allows the user to log out to end the session and take the user to the logout page (name it as logout.php)

4) Add the following requirements to the main page

- 2 text boxes and a button that allows the ability to add more records to the usertb table (one record at a time)

- no data validation is required

- this can be done via function or non-function (you choose)