Web Development Project: First National Bank System

This project details the implementation of a web-based bank system, simulating the core functionalities of a financial institution. The system encompasses user registration, where users provide personal details to create accounts, and a secure login process using hashed passwords. After successful login, users access a homepage to manage their accounts, including adding new accounts, transferring funds, changing passwords, and viewing transaction histories. The system also includes a logout feature to end user sessions. Account creation involves password confirmation and initial balance setup, with randomly generated account numbers for security. Users can edit account status (open/close) and perform fund transfers between accounts, with error handling for insufficient funds. A transaction list page displays all activities related to each account. The project includes database schema with tables for account holders, accounts, and transactions, along with instructions to set up the environment (Apache, MySQL, PHP) and database import using phpMyAdmin. The solution is available on Desklib.

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`)
)