Melanie Corral
Project_2
Overview
My project is meant to be a class schedule manager that will communicate with a database to retrieve and push data from a web browser. The user will start at the ClassRoster page that will display a list of courses. The user may click on the schedule button to be directed to the schedule. They may also click on the view course button to be taken to a new page that will display more information about the course. From the course details page, the user may add the course to their schedule. From the schedule the user will see all the courses they added, and they may remove the courses they no longer desire.
Explanations
Here is the class roster. It displays the general details of each class such as the course id, times, instructor and meeting times. From here users may either go to the class schedule, or may click on a view course button for the paticular class they are intrested in. If the user is to click on the the view course button, they will be taken to that specific course's details. This is done using SQL code to fetch the roster_id of the course and push it to the next page.
This is where we push the roster id to the course page when the user clicks View Course.
This is the Class Details page. It displays the general details of a course along with some additional information. The user may click on the Course List button to be taken back to the Class Roster or they may click on the Add Course button to add the course to their schedule. Notice the URL. The id in the URL is the roster_id of the course. This is a direct result from that id push done earlier. This was pushed to us from class roster. We GET the id and use it to display this specific classes details.
This is the code where we GET the id and insert/add the details of that course into the schedule. I use script to automatically redirect the user to their schedule page.
This is the Schedule Page. It displays the user's schedule. It displays the same infromation as the Class Roster, only instead of every class, it will only display the courses the user has added. From here the user may choose to go back to Class Roster, to add more classes or Delete a class from the schedule. I made sure that no duplicates would show on the schedule page, but the same cant be said about the Schedule table in the database. I have not figured out a way to delete duplicates from the schedule table.
Here is the code for deleting a course from the schedule. As done prev, we get the id of the course and Delete the row with the same roster_id from the schedule.
