PHP HTML Database Project

Here is a PHP and HTML project developed in my Software Development I course.  This project was to build and maintain an online database of graduate students’ personal and academic information as well as professor’s notes and comments. The system required users log in with their email and password, giving them access as a student, faculty member, or administrator. Student log in roles could view their own academic information and edit personal information and their profile picture. Faculty could view any student’s information, being able to search for students by name, student id number, or by academic advisor. They could then edit student’s academic information and leave notes on the student in a comment box accessible only by other faculty members. The administrator role did not have access to any student information, but could add faculty emails to an internal list that determined whose login was granted faculty access. You can download the files for that here.  


This contains one cgi file that actually runs the show, the school logo, plus an image folder for student pictures, a couple of test data files containing mock student data, and a data file containing faculty login info.  In this system the EUIDs and passwords are the same.  You can access test data by entering in the file names as the EUID and password.  The admin login EUID and password is 123xyz. Finally, there is a user guide that documents how to use the system.