Released under the
CC-BY-NC-SA 4.0 license.
This exercise focuses on using web application and database, with an assumption that you are familiar with the database concepts. For the fundamental concepts of database (such as database design, SQL commands, query optimization) please refer to CS 4750 (Database systems), Intro to SQL commands (by Professor Nada Basit), Basic SQL, aggregates, joins, subqueries, and quantifiers.
You may work alone, with your project partner(s), or with another student in this course.
You may use connect-db.php (text version) and db-exercise.php (text version) as a starting point or create PHP program(s) from scratch. You will implement PHP program(s) to:
In addition to the above functionality, you may create a form allowing a user to enter data to be inserted into the table. Then, your program should be modified such that it retrieves the form data entry and subsequently reflects the database.
You may modify your interface the way you like. Get creative. Feel free to add additional elements you feel should be included and have fun!
To deploy and test your program use one of the following options:
Refer to Connecting PHP and DB based on where you host your database.
Released under the
CC-BY-NC-SA 4.0 license.