Final Project

Due: 11:00pm, Thursday, December 15, 2022

Assignment Description

The goal of this project is to develop a basic data driven web application. The theme of your project is up to you, but it must meet the following criteria:

• The application data must be stored in a SQLite database.

• The PDO library must be used to access the database.

• The application must have a login / logout mechanism for users.

• A user must be able to manipulate data in some fashion. (It does not necessarily need to use all CRUD operations depending on the theme of the application.)

• All data submitted via forms must be validated and appropriate error messages must be shown to the user if the data is not valid.

• Each page in of the web application must link to the same external CSS style sheet.

• The CSS style sheet must have at least ten rules and be named style.css.

• The server-side code must be modular. (That is, do not put all the code in a single file.)

• The web application must be sufficiently complex. (This criteria is somewhat subjective; if you think your idea for the web application is too simplistic, then ask me.)

• The home page of the web application must be named index.php.

For this project, you can earn up to a 5% bonus towards your final course grade by exceeding the basic criteria listed above. The bonus points will be awarded at my discretion depending on the quality of the enhancements. If you choose to implement additional features, add a file named README.txt in the final-project-handout directory containing the details of the additional features.

Instructions

To start the assignment, login to your university Linux account and copy the assignment code to a location somewhere under your home directory. The assignment code is located at:

/export/home/public/schwesin/csc242/projects/final-project-handout

This directory contains empty files named index.php for the home page and style.css for the style sheet. Do not change the names of those files.

To submit your assignment, execute the following command from within your final-project-handout directory:

    ~schwesin/bin/submit csc242 final-project

Grading Criteria

• Concise, accurate documentation following the CSC Department documentation guidelines

• Correct implementation of the specification

• The HTML documents passes validation

• The CSS style sheet passes validation

Note: If the code has syntax errors or does not execute properly (this includes warnings from the PHP interpreter), you will receive a failing grade for this assignment. If the submission includes material that was not covered in class and the material is not properly cited, then you will receive a failing grade for this assignment.