This is a very simple project. Its basically a login system and a page for data entry.
Create user login system with features:
- User can register (The usual limiting features: 16 character limit for username. Password atleast 4 letters long)
- "Forgot password" link: sends random password to email that they must change after login.
- "config.php" is a file that will contain system variables like database name, DB user and DB password.
The registration data goes into a table "User:, with fields:
-UserID (unique autoincrement number for each user)
-Password(text which stores the password in MD5 has for security)
-Date and time of registration
Login system should be cookie based so users can stay logged in if they click "Remember me". The login system will be secure so cookies cannot be "stolen". If a password is stored in the cookie, it must be stored in MD5 has, and not in plain text.
This user login already exists on the web and I have tested it:
[url removed, login to view]
(download zip file and run SQL file to create the DB tables)
However, I need some additional features. You can either take this already existing login system and modify it for the additional features, or create your own system - its up to you.
After loggin in, user sees a link "table1.php" and after clicking on that link, he can enter two text fields (field1, field2) for the DB table "table1". i.e.:
-UserID (this will automatically be inserted from the logged-in user's user_ID from table "User" defined above)
These two data fields form one row of the table. User can add in more rows, delete or edit existing rows. The link "table1.php" also displays the 5 most recently entered rows by that user. Ofcourse user should only be able to view and make changes to rows they have created.
Let me know if you have any questions.