Police Station Database Website

Overview

This project was created to learn about databases and how to connect code to a phpMyAdmin localhost database server. XAMPP was used to host the server to create and use database information on phpMyAdmin. Databases, tables, and information were created using SQL statements.

The fullstack website was created for two views: a normal viewer and a police officer with more viewer privileges. There is a registration system for the two different views which displays different pages and viewership of private and public data based on the user. The code pulls information using SQL statements from the database.

Team

• ●Raiya Haque – FullStack Developer
• ●Orion Yang – FullStack Developer

General Features

• ●Registration & Login: User logs in as a viewer or an officer, controlled using sessions and database-stored credentials
• ●Logout: Logs the user out with security to prevent session roundabout exploits

Regular User Features

• ●Home: Displays Crime and Criminal Information – ID, Type, Dates, Criminal Name, Status, etc.
• ●Search: Search by entering a character. Can filter by Criminal or Probation Officer

Officer User Features

• ●Home: Same crime info view with Update (using SQL procedures like updateClassification, updateStatus) and Delete (using deleteCrime procedure) capabilities
• ●Search: Search for criminals, probation officers, and Crime Officer Badge Numbers using SQL function searchCrimeOfficer
• ●Add Crime & Criminal: Submit crime and criminal information forms that insert into the database using SQL procedures addCrime and addCriminal

Tech Stack