This needs to be done in php 5 and mySQL 4.1
Need a php page with username and password input boxes, and user clicks Login button. Query the User table for username and password. If invalid, display error message. If valid, display new page with 2 input boxes Field 1 and Field 2. Require that data be entered in both. When user clicks Submit, create a new record in NewTable with Field 1, Field 2, and UserID (get UserID from the User table - each username/password record will have an auto-generated ID).
On the login page, also provide a link for user to enter his username to retrieve password (password should be emailed to user).
Lastly, once logged in, create link (on the page where user enters Field 1 and Field 2) to another page that displays all the records in NewTable for the user.
When bidding, please describe how you will implement secure pages (cookie, URL sessions, ...) and why you recommend that approach.
Deliverables should include php code and table definitions.