Recently a collegue contacted me for some help with his university degree. The project was to create a website that was backed by a database. My background is mainly PHP and MySQL however, the course had been teaching them how to manipulate an MDB Access Database file using ASP. The outline of the task was a document management system for projects.
- A user would enter their unique company number into a page
- It would list available projects for that company
- User would select the project and login with a username and password
- The website would list all files which he had permission to access
The tutorials the lecturer had given out used dreamweaver to create the ADODB.Connection , however it seemed an over complicated way of doing it. After a bit of online research my first ASP project is below ( Could be better but only had an evening to do it! )
code here : http://pastebin.com/7s739FKa
This code manages the Company ID input then list the projects from that company
Takes the project ID from index.asp and checks the permissions table after username and password verficiation for files they have access to
code here : http://pastebin.com/BmNiXZgz
File here : http://www.pariswells.com/upload/db.mdb
Users -> Username , Password and ID
Projects -> Project Name , Company ID Associated with that Project and Project ID
Permissions -> FileID and UserID
Company -> Company Name , Company Number and ID
Definitely prefer PHP to ASP!