IST366: Project III
PHP interface to University database
Create a PHP script that does the following:
- Connects to the University database.
- Prints the list of all students as a table. Information about each student
should include:
- student name (first and last);
- title of the student major (not MID, the title);
- number of classes this student already took (that is, has a grade for them);
- GPA.
- Originally this table should be ordered by last names, but you should include
an option for the user to sort the table by any column. For example, you can make the
headers of the columns in the table to be links to the same script with different value
of order_by parameter.
- This page also should have a button upon clicking on which the user should get
an interface which allows him/her to add a new user to the Student table. That is,
you should also create an html file with the interafe (as convenient as you imagination allows)
and another PHP script that adds the new student to the table.
- All these script should be located in your own www directory on
ist.linux-site.net.
Due date: Monday April 15, 11:59pm