CS4750 - Database Systems

POTD 5: Database Interfacing

Due 21-Mar-2024 23-Mar-2024, 12pm/noon EST

Purpose: 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

sample maintenance request screen for potd5

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

[20-Mar, updated]
(-2.5 points) for 24 hours late (submitted after 21-Mar-2024 12pm EST, by 22-Mar-2024 12pm EST)
(-5 points) for 48 hours late (submitted after 22-Mar-2024 12pm EST, by 23-Mar-2024 12pm EST)

(-2.5 points) for 24 hours late (submitted after 23-Mar-2024 12pm EST, by 24-Mar-2024 12pm EST)
(-5 points) for 48 hours late (submitted after 24-Mar-2024 12pm EST, by 25-Mar-2024 12pm 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.

CC-BY-NC-SA 4.0 license.
Last updated 2024-03-15 18:23