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)

Home Page

Home Page (Logged In)

Read Operation on Employees Table

Create Operation on Accounts Table

Update Operation on Accounts Table

Create Operation on Employees Table (Input Validation)

Reporting Query for Transactions Table by Client and Date-Time