POTD 5: Database Interfacing
Due 28-Oct-2025, 1pm ESTPurpose: Hands-on experience with database interfacing, using PHP and PDO to manipulate the database
Please note: This exercise focuses on making a web application interact with a database. For the fundamental concepts of web development, please refer to CS 4640 (Web Programming Language).
You may work individually or with your project team member(s). In this activity, you will be exposed to simple web programming. This activity provides an overview of database programming, a very brief introduction to HTML, CSS, and PHP; as well as web deployment. Please note: our focus is on the database part, not the web programming part.
The intention of this activity to help you get started with your project (if you plan to develop a web app using PHP). If you are already familiar with HTML, CSS, and PHP, feel free to use this activity to refresh your memory or simply do it for fun. If you do not plan to develop a PHP project, you may do this activity using any language of your choice.
Overall, you will
- Understand how database programming works in general (overview)
- Understand how web programming works in general. (Here is a very brief intro)
- Prepare your database
- Write a small web program to interact with your database
For this POTD, there are three options. Complete at least one option.
- Follow the POTD description to develop a small PHP-based "maintenance request" software
- Use the language you plan to use for your course project to develop a "maintenance request" software interacting with a small database
- Use any language of your choice or try some new language to develop a "maintenance request" software interacting with a small database
You may use a template (template.zip) as a starting point or create a PHP program from scratch. You will implement a PHP program to:
- Create a table (this is optional)
- You may follow along and create a requests table to maintain information about the maintenance requests, or
- You may create a table you plan to use for your CS 4750 project
- Insert data into a table
- Display existing data on the screen
- Update a table with some data
- Delete data from a table
- Drop a table from the database (this is optional)
Example screen is shown below
Optional:
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
- To deploy your web program: use one of the following options to deploy your PHP program
Additional resource: Basic web deployment
- To test your program
- Be sure the web server is available (if you use XAMPP, start your local web server)
- Access your web page via a web browser. Enter the URL based on where you host your PHP program
- Create a table, using the PHP program. Access your database and verify that the table has been created
- Insert data into the table, using the PHP program. Access your database and verify that the record (or row) of data has been inserted
- Retrieve data, using the PHP program. Access your database. Verify that the data retrieved and displayed on the screen (browser) match the data in your database.
- Update data, using the PHP program. Access your database. Verify if the record (or row) of data is updated correctly
- Delete data, using the PHP program. Access your database. Verify if the record (or row) of data is deleted correctly
- Drop a table, using the PHP program. Access your database. Verify if the table is dropped (completely removed from a database) successfully
Grading rubric
[Total: 10 points]: Done (or provide evidence of your attempt, full or reasonable effort)- (5 points) — Providing evidence of your attempt, minimal effort
(-2.5 points) for 24 hours late (submitted after 28-Oct-2025 1pm EST, by 29-Oct-2025 1pm EST)
(-5 points) for 48 hours late (submitted after 29-Oct-2025 1pm EST, by 30-Oct-2025 1pm EST)
Submission
- Each team submits only one copy.
- Upload all of your source code files to POTD 5 on Gradescope. Please remove your credential from the connection code; e.g., remove your username and password from connect-db.php)
- Make sure you connect your partner to your group on Gradescope so that everyone receives credit.
- Please verify that your POTD is accessible. Making your submission available to instructors and course staff is your responsibility; if we cannot access or open your file(s), we have to assign a zero grade. Be sure to test access to your file(s) before the due date.
Copyright © 2025 Upsorn Praphamontripong
Released under the
CC-BY-NC-SA 4.0 license.
Last updated 2025-10-11 18:23