Skip to content

Latest commit

 

History

History
33 lines (21 loc) · 1.95 KB

File metadata and controls

33 lines (21 loc) · 1.95 KB

TU-bank-project-php

A university assignment project simulating a basic bank management system built with PHP and MySQL.

The project features a relational database designed in SQL Developer Data Modeler covering core banking entities — clients, accounts, employees, transactions. The application provides full CRUD operations for each table through a clean PHP interface using PDO with prepared statements, server side validation, and protection against SQL injection and XSS attacks. It also includes several reporting queries and session-based employee login system.

Database Relational Model Design (in Oracle SQL Data Modeler)

image

Home Page

homePage

Home Page (Logged In)

image

Read Operation on Employees Table

image

Create Operation on Accounts Table

accountForm

Update Operation on Accounts Table

image

Create Operation on Employees Table (Input Validation)

image

Reporting Query for Transactions Table by Client and Date-Time

image