Implementing a Banking System

This assignment is about creating a banking system that allows users to register, login, and manage their accounts. The system has various features such as adding new accounts, making payments, viewing transactions, and changing passwords. The system also includes a database schema with three tables: account_holder, account, and transaction.

We have implemented the following requirements:
1. Register
User will visit website and register to First National Bank. User would be providing
details like Name, address, contact number, date of birth and password. After user has
been registered successfully, user would be given USER ID which would be used to
login.

2.
Login
User will visit website to login using the USER ID given and password entered by user.
After the user submit the details, password is checked again the hashed password
using the third party PASSWORDHASH (http://www.openwall.com/phpass/). If the
details are wrong, error message is shown otherwise user is shown their homepage.

3. Home Page
After successful login, user will see their homepage where they can Add Account, Pay
to another account, change password and check their account Transaction.
4. Log-out Page
After user clicks on log out, all sessions are destroyed and user is shown login page.
5. Add Account
Initially, user has no account. Now user can open new account by confirming the
password and starting balance in the account. We have asked password again to
increase the security. In case password entered is wrong, error message is shown.

After entering correct details, account is opened and we can now edit the account and
also check all transactions done. The account number is created by system randomly to
avoid any collusion.
6. Edit account Page
After clicking on account number, user will see the open to close or open the account.
User can close or open the account.
7. Payment/Transfer
User can transfer the amount or make payment of any bill from its any open account to
other account. The other account are all the accounts open in First National Bank. The
source account would be debited and destination account would be credited. In case
user tries to send more amount than present in account, error message is shown.

8. Transaction list Page
When Transaction list page is opened, it shows all the activities related to that order.
9. Change Password

When user wants to change password, user has to enter correct old password to verify
if user is real or not.

Steps to Run Code
1. Install Apache, mysql and PHP in your system. If you are using windows, you have to
install XAMPP which comes with apache, mysql and php. After installing it, go to the
directory where you have installed it, mostly install in C drive. Go to XAMPP folder,
now move to htdocs folder. Copy the code into that folder.
2. If you are using Linux, after installing LAMP, go to /var/www directory and copy your
code.
3. If you are using MAC, after installing LAMP, go to /Library/Webserver/Documents and
copy your code.
4. Open phpmyadmin or mysql workbench to create database. Click on Import icon and
use a2.sql to create database with pre-filed data.
5. Go to browser, open url like http://localhost/bank/index.php
Database Schema
We have created three tables - account_holder, account and transaction.
The account_holder tables stores the information about the user. The account table stores the
information of user’s account. The transaction table stores the information about each transaction of an
account.
CREATE TABLE `account` (
`accountNumber` int(11) NOT NULL,
`userId` int(11) NOT NULL,
`balance` decimal(10,2) NOT NULL,

`status` enum('open','closed') DEFAULT 'open',
`openingDate` date NOT NULL,
`modDt` date NOT NULL,
PRIMARY KEY (`accountNumber`)
)
CREATE TABLE `account_holder` (
`userId` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`password` varchar(100) NOT NULL,
`address` varchar(100) NOT NULL,
`contactNumber` varchar(12) NOT NULL,
`dob` date NOT NULL,
`entryDt` date NOT NULL,
`modDt` date NOT NULL,
PRIMARY KEY (`userId`)
)
CREATE TABLE `transaction` (
`transactionId` int(11) NOT NULL AUTO_INCREMENT,
`accountNumber` int(11) NOT NULL,
`amount` decimal(10,2) NOT NULL,
`transactionType` enum('Credit','Debit') DEFAULT 'Debit',
`comment` text NOT NULL,
`transactionDate` date NOT NULL,
PRIMARY KEY (`transactionId`)
)