KARNATAK UNIVERSITY

DHARWAD
Janata Shikshana Samiti’s

Shri Manjunatheshwra Institute of UG & PG

Studies Vidyagiri, Dharwad-580004.

A PROJECT REPORT ON
“E-POSTAL SERVICE”
BACHELOR OF COMPUTER SCIENCE
OF
KARNATAK UNIVERSITY, DHARWAD

PROJECT GUIDED BY
Miss.Padmavathi Shyadambi

Submitted By
Soumya Nerkar Alakya CH
BSC(CS) VI SEMESTER BSC(CS)VI SEMESTER
REG NO:18M10168 REGNO:18M10106
DEPARTMENT OF COMPUTER SCIENCE
2020-2021
 JANATA SHIKSHAN SAMITI’S
SHRI MANJUNATHESHWARA INSTITUTE OF UG & PG
STUDIES, VIDYAGIRI, DHARWAD-580004

CERTIFICATE

This is to certify that Miss. SOUMYA NERKAR AND Miss.ALAKYA CH has

satisfactorily completed project work entitled “E-POSTAL SERVICE” for the
partial fulfilment of BSC(CS) prescribed by Karanatak University, Dharwad
during the academic year 2020-2021.

Miss.Padmavathi Shyadambi Sri.Vivek M Laxmeshwar Dr. Ajith Prasad

Project Guide [HOD] Computer Department Principal

Examiners:
1) 2)
 ACKNOWLEDGEMENT

The successful presentation of this project is an acknowledgement of the

immense support extended by JSS Shri Manjunatheshwara Institute of UG & PG Studies,
Vidyagiri, Dharwad Which has provided opportunities to fulfil the most cherished desired
to reach our goal. We would like to express our heartfelt thanks to our President Shri.
Vishwaprasanna teertha of Pejavar math of Udupi, Chairman Padmabhushan Pujya Dr. D.
Veerendra Heggade and Dr. N. Vajrakumar, Secretory of JSS.

We would like to express our sincere gratitude to our beloved Principal Dr.
Ajith Prasad who gave us inspiration and moral support. We offer our heartily gratitude
to our H.O.D Shri. Vivek M. Laxmeshwar of Computer Science Department who gave us
knowledge and an opportunity to do the project on “E-POSTAL SERVICE”, which also
helped us in doing a lot of research and where expose to many new things.

We would also take this opportunity to offer our sincere gratitude to our Project
Guide Miss.Padmavathi Shyadambi for her excellent support throughout the development
of this project and for providing the necessary information on our request at all times.

We also thank all Teaching and Non-Teaching staff of Computer Science

Department for helping us in all aspects. We thank our parents for providing all the facilities
to complete and make this project successful.

SOUMYA NERKAR (18M10168)

ALAKYA CH (18M10106)
 DECLARATION

We, Soumya Nerkar and Alakya CH, students of sixth semester BSC(CS), Department of
Computer Science, JSS SMI UG AND PG STUDIES VIDYAGIRI, DHARWAD, Karnatak
University declare that the project entitled “E-POSTAL SERVICE” has been submitted in
partial fulfillment of the course requirement for the award of degree in Bachelor of Science
(Computer Science), Karnatak University, Dharwad during the academic year 2020-2021. We
have not submitted the matter embodied to any other university or institution for the award of
any other degree.

Date: 5-08-2021 Soumya Nerkar

Place: Dharwad Alakya CH
 CONTENTS
1. PROJECT SYNOPSIS………………………………………...1
2. FRAMEWORK………………………………………………….3
2.1. HTML
2.2. DreamWeaver
2.3. PHP
2.4. WAMP
2.5. My Sql

3. PROJECT SUBJECT…………………………………………..7
4. SOFTWARE REQUIREMENTS SPECIFICATION………….10
4.1. Introduction
4.1.1. Purpose
4.1.2. Document Conventions
4.1.3. Scope
4.1.4. References
4.2. General Description
4.2.1. Product Functionalities
4.2.2. User Characteristics
4.3. Specific Requirements
4.3.1. Functional Requirements
4.3.2. Other Non-Functioal Requirements
4.3.3. External Interface Requirements

5.DESIGN OF THE SYSTEM……………………………………15

5.1. Introduction
5.2. Data Flow Diagram
5.3. ER- Diagram

6. IMPLEMENTATION…………………………………………..21
6.1. Introduction
6.2. Database Evolution
7. DATABASE TABLES…………………………………………26
7.1. Tables Used In Database

8. SCREEN SHOTS……………………………………………...29
9. SOURCE CODE……………………………………………….34
10.TESTING……………………………………………………….59
10.1. Software Testing
10.1.1. Introduction
10.1.2. Levels Of Testing
10.2. Validating The Tables
10.3. Functional Testing

11. CONCLUTION………………………………………………..69
12. BIBLIOGRAPHY……………………………………………..67
12.1. Books
12.2. Websites
 1. PROJECT SYNOPSIS

1.1 INTRODUTION
• Speedy and efficient information processing is required to our socially and highly
developed technology.
• Computer can help the intolerable burden of handling the ever-increasing amount
of information with government department, public services and business concerns
expected to contain because of their ability to analyze information as well as to retain,
update and reproduce it because of their versality to present it in a variety of forms.
• This may also lead to problems occurring due to information explosion.

1.2 INPUTS OF THE PROJECT

1. Customer details
2. Account details
3. Deposit (FD)
4. Schemes details
5. Rate of interest
6. Add notifications

1.3 OUTPUT OF THE PROJECT

1. Customer Profile
2. Transaction
3. View Scheme Details
4. View Notification
5. Reports

1.4 PROCESS LOGIC

Customer details Customer Profile

Account details Transaction

Deposit View Scheme Details

E-Postal
Schemes details Service View Notification

Rate of interest Reports

Add notifications
1.5 TOOLS/PLATFORM
Browser (Google Chrome)

1.6 FRONT END

▪ HTML
▪ CSS
▪ XML

1.7 BACK END

▪ MySql
Programming Language
▪ JAVA Script
▪ PHP
▪ JSON

1.8 DURATION OF THE PROJECT

2 Months

1.9 MEMBERS OF THE PROJECT

Soumya Nerkar 18M10168
Alakya CH 18M10106

1.10 LIMITATIONS
▪ It is very time-consuming process.
▪ The person must wait for long time for officers.
If any officers are not available in the town the process delay.
▪ It uses internet.

1.11 SCOPE OF THE APPLICATION

▪ It takes very less time for completion of process.
▪ The application and requests can be verified by the officers wherever they are, and
can take necessary actions.
▪ It is very easy for giving complaints and suggestions.
 2.FRAMEWORK
2.1 HTML
HTML means Hypertext Markup Language. HTML is a method of describing the format of
document, which allows them to be viewed on computer screen. Web browsers display HTML
documents, program which can navigate across networks and display a wide variety of types
of information. HTML pages can be developed to be simple text or to be complex multimedia
extra advantages containing, moving images, virtual reality, and java applets.
Hypertext Markup language (HTML) is used to creating the web page either of static
or dynamic and used to develop the user-friendly web pages.
HTML is used for developing web pages .HTML is popularly used in World Wide Web
(WWW). It uses ASCII characters for both the main text and formatting instructions the main
text is data and the whole information is used by the browser to format the data. A HTML
document is simply a text file, which contains certain information you would like to publish.
A set of instruction embedded in a document is called Markup Language. These
instructions describe what the document text means and how it should look in a display. The
language also tells you how to make a document with other document on your local systems.
The World Wide Web and other inter resources such as FTP.
The global publishing format of the Internet is HTML. It allows authors to use not only text
but also format that text with headings, list and tables, and also includes still images videos,
and sound within text. Readers can access pages information from any where in the world at
the click of mouse button information can be downloaded to readers own PC or workstations
HTML pages can also be used for entering a data and as a front end for commercial transaction.

2.2 Dreamweaver
A website authoring program originally developed by Macromedia. It does many things
including allowing designer to move back and forth between visual and HTML modes.

2.3 PHP
PHP is a scripting language originally designed for producing dynamic webpages. It has
evolved to include a command line interface capability and can be used in standalone graphical
application. While PHP was originally created by RasmusLerdorf in 1995, the main
implementation of PHP is now produced by the PHP Groups and serves as the de facto standard
for PHP as there is no formal specification.
 PHP is a scripting language under the PHP License; however, it is incompatible with
the GNU General Public License (GPL). Due to restrictions on the usage of the term PHP. It is
widely used general-purpose scripting language that is especially suited for web development
and can be embedded into HTML. It generally runs on a web server, taking PHP code as its
input, I am creating web pages as out puts. It can be deployed on web servers and on almost
every operating system and platform free of charge. PHP in installed on more the twenty
million web sites and one million web servers.

PHP Architecture

Usage
PHP primarily acts as a filter, taking input from a file or stream containing text and/or
PHP instructions and outputs another stream of data; most commonly the output will be HTML.
It can automatically detect the language of the user. From PHP 4, the PHP parser compiles
input to produce byte code for processing by the Zend Engine, giving improved performance
over its interpreter predecessor. Originally designed to create dynamic web pages, PHP’s
principal focus is server-side scripting, and it is similar to other server-side scripting languages
that provide dynamic content from a web server to a client, such as Microsoft’s Active Server
Pages, Sun Microsystems JavaServer Pages, and mod_perl. PHP has also attracted the
development of many frameworks that provide building blocks and a design structure to
promote rapid application development (RAD). Some of these include CakePHP, Symfony,
CodeIgniter, and Zend Framework, offering features similar to other web application
frameworks.
The WAMP architecture has become popular in the web industry as a way of deploying web
applications. PHP is commonly used as the PHP in this bundle alongside Linux, Apache and
MySQL, although they may also refer to Python or Perl. As of April 2007, over 20 million
Internet domains were hosted on servers with PHP installed, and PHP was recorded as the most
popular Apache module. Significant websites are written in PHP including the user-facing
portion of Facebook, Wikipedia (MediaWiki), Yahoo!, MyYearbook, Wordpress.
In addition to server-side scripting, PHP can be used to create stand-alone, compiled
applications and libraries, it can be used for shell scripting.

2.4 WAMP
Stands for “Windows Apache MySQL, and PHP”. WAMP is a variation of LAMP for
windows system and is often installed as a software bundle (Apache, MySQL, and PHP). It is
often used for web development and internal testing but may also be used to serve live wed
site.
The important part of the WAMP is Apache (or “Apache HTTP Server”) which is used
to run the web server within the windows. By running the locate Apache Web Server on a
Windows machine, a web developer can test web pages in a web browser with out-publishing
live on the internet.
WAMP also includes MySQL and PHP, which are two of the most common
technologies used for creating dynamic web sites. MySQL is a high-speed database while PHP
is a scripting language that can be used to access data from data base. by installing these two
components locally a developer can build and test a dynamic web site before publishing it to a
public web server.
While Apache, MySQL and PHP are open-source components that can be installed
individually, they are usually installed together. One popular package is called “WAMP
Sever”, which provides a user-friendly way to install and configure the “AMP” components on
windows.
 2.5 MY SQL
What is Database?
Quite simply, Its an organised collection of data. A Database management system (DBMS)
such as access file maker Pro, Oracle or SQL server provides you with the software tools you
need to organize that data in a flexible manner. It includes facilities to add modify or delete
data from database, ask questions (or queries) about the data stored in the database and produce
reports summarizing selected contents.
My SQL is a multithreaded, multi-user SQL database management system
(DBMS). The basic program runs as a server providing multi-user access to several databases.
My SQL was owned and sponsored by a single for-profit firm the Sidish company. My SQL
now a subsidiary of Sun Micro System, which hold the copy write to most of the database. The
data in My SQL is stored in database objects called Tables. A table is a collection of related
data entries and consist of columns and rows. Databases are useful when storing information
categorically.

System Requirements
Minimum Hardware Required for project
• Domain: Web Application
• Processor: Pentium III and above
• RAM: 128 MB
• Monitor: VGA monitor
• Keyboard and a mouse
• Celeron or higher processor
• 256MB RAM
• 40 GB Hard Disk
• Windows NT/2000/XP
• Macromedia Dream weaver

Minimum Software Required for project

FRONT END:
▪ HTML
▪ CSS
▪ XML

BACK END:
▪ MySql
Programming Language: JAVA Script, PHP, JSON
 3.PROJECT SUBJECT

▪ Speedy and efficient information processing is required to our socially and highly
developed technology.
▪ Computer can help the intolerable burden of handling the ever-increasing amount
of information with government department, public services and business concerns
expected to contain because of their ability to analyze information as well as to
retain, update and reproduce it because of their versality to present it in a variety of
forms.
▪ This may also lead to problems occurring due to information explosion.
About the project
▪ POST OFFICE works in every walk of our life. Through the automation of this
system one can easily generate the information about the customer available and
about the old records.
▪ Our proposed system software can fulfill the requirements which are demanded by
the customer.
▪ The proposed system E-Postal Service can manage the activities like applying FD,
giving suggestions and complaints, calculating rate of interest and notification
about government schemes and postal exams.
This project includes following features: -
▪ Having customer information and total amount payable.
▪ For the help of user, it displays each and every detail about required topics.
▪ Maintains all the old record for later reference.
▪ Have provision for automatic update as per the status.

Objectives of the proposed system

1. Immediate retrieval of information – The main objective of the new system is to
provide for quick and efficient retrieval of information, any type of information would
be available to the user whenever he requires. Facility would be provided for online
query to cut down on the response time greatly.
2. Immediate storage of information – In the proposed system, it will be easy to store
information at any given time at the correct places. The location of storage would be
easily available, and user will face no difficulty.
3. Prompt updating of information – In the proposed system, the information will
always remain up to date as the updating will be prompt and without any efforts. This
factor will be of great importance in the proposed system as it determines the integrity
of the information stored.
 4. Fast computation of information – The computation of information will be quite fast
in the proposed system. Not only mathematical calculations, but also logical
comparisons will be quick in the new system.
5. Planned approach toward working – The working is the service center information
system will be well planned and organized. The data will be stored properly in the data
store, which will help in retrieval of information as well as in its storage.

3.1 NUMBER OF MODULES

▪ Manage E-Letter (Individual/Group)
1. Admin
▪ Approve Status
▪ Login
▪ Manage Fixed deposit
a. Upload receipt
b. View Status
▪ Manage Users

▪ Logout

2. User
▪ Register
▪ Login
▪ Apply E-Letter (Individual/Group)
▪ Create Fixed deposit
a. Upload receipt
b. View Status
▪ My Profile
▪ Logout
3. Deposit
4. Feedback
5. Notification
Module Description
ADMIN
• Admin Login
The main activities in the application are the admin login page for admin. The other modules are
followed by this login page. This module records only admin and password of the admin.
 • Manage E – letter
Admin can manage the user’s e – letter and admin can transmit the respective addresses.
• Approve status
Admin can transmit the letters then admin can upload the status of approval.
• Manage fixed deposit
Admin can manage the fixed deposit account details and transaction details are maintained.

• Manage users and logout

An admin can manage users account and their details, status and then, the terminate the admin
account
USER

• User Login
The main activities in the application are the user login page for user. The other modules are
followed by this login page. This module records only user and password of the user.

• User Registration
Another main function of our proposed system is registration, in order to register with the unique
application details such as name; password, email, place and time are required.
• Apply E – letter
A user can apply letter based on user’s content is a service under which printed, or even
handwritten messages of customers are scanned and transmitted as email through internet.
• Create Fixed Deposit
A user can create their Fixed deposit in e – post department. The post office fixed deposit (POFD), also
known as ‘post office time deposit’ is a convenient alternative to the fixed deposits provided by banks.
Through this fixed deposit scheme that is offered by the Indian Postal Services, an individual can earn
a guaranteed return on the money deposited for a fixed period of time.
i.Upload receipt
A user create their fixed deposit and update their accounts details. Then, User will upload receipt of
fixed deposit.
View status
A user can view status of deposit process and account maintenance details. User can view whole
status.
My profile and Logout
User view my profile and if the user can update the profile details and then, the terminate their
account.
 4. SOFTWARE REQUIREMENTS SPECIFICATION

4.1 INTRODUCTION
SRS is the official statement of what is required by the system developers; it includes both
user requirements for the system and detailed specification of the system requirements. This
document is used while designing the proposed system and can also be used in the future if the
system is to be enhanced.

4.1.1 Purpose

The purpose of this Requirements Elicitation document is to provide a clear understanding as

to what actually the Industry Management Syatem is and to identify the critical requirements
essential for the project’s successful completion.

This document explains our team architecture, our teams’s initial understanding of the user
needs.

4.1.2 Document Conventions

Main Section Title: Font: Times New Roman, Bold: Size 16

Sub Section Title: Font: Times New Roman, Bold: Size 14

Other Text Matter: Font: Times New Roman, Bold: Size 12

4.1.3 Scope

This document is intended for providing an abstract overview of the system and general
overview of the entire project. The scope of the document:

▪ Team Architecture,
▪ System Functional and Non-Functional Requirements
▪ Prototype of the System,
▪ Online payment acceptance for wide range of services.

4.1.4 Reference

https://codeshoppy.com/shop/product/e-post-office/

https://youtu.be/PKFczWVvrjA
https://studentprojectguide.com/php-projects/epost-office-management-system/

https://www.w3schools.com/

4.2 General Description

This section will give an overview of the whole application. The explanation of the application
will be in its context to show the application interacts with other systems and introduce the
basic functionality of it. It will also describe all the constraints and assumptions for the
application.

4.2.1 System Perspective

As per the requirements of the client, to build a customized application that facilitates to
maintain the entire details of the e-postal service to get through the demerits of existing manual
system with new implementations such as:

▪ It takes very less time for completion of process.

▪ The application and requests can be verified by the officers wherever they are and can
take necessary actions.

▪ It is very easy for giving complaints and suggestions.

Existing System

▪ In the present system the user has to do the transaction manually.

▪ It takes lot of time for transaction as they are maintaining the records in the book.

Proposed System

The proposed system is E-POST. Here everything is done online. The activities like
depositing can be done through online. No waiting is required. And feedbacks can be given
through online. Even if the officer is not available in the village, he can verify application
online. It is very quick process than the existing system.
4.2.1 Product Functionalities

E-Postal Service Project should support the following functionalities:

▪ Login: Sign in into the web application.

▪ Sign up: User registration.
▪ Applying for the fixed deposit amount.
 ▪ Applying E-Letter.
▪ Giving the feedback.

4.2.2 User Characteristics

End Users

▪ No specific knowledge or skills are required from the end user.

▪ End user should have basic idea about computer operations.

Administrator

▪ Administrator must be having good knowledge of database management system.

▪ Administrator must be capable to manage user rights.

4.3 Specific Requirements

4.3.1 Functional Requirements

a) Login

▪ Start the application.

▪ User enters the username and password.
▪ System does authentication and main screen is displayed.

Authorization Fails

▪ Prompt the user that he typed the wrong password.

▪ Allow him to re-enter the password.

b) Change Password

▪ User initiates the change password command.

▪ User is prompted for to enter old password, new password and confirm password.
▪ System does authentication.
▪ New password is registered with the system.

Authorization Fails

▪ Prompt the user that he typed wrong password and allow him to re-enter. Give him 3
chances.
c) Forgot Password

▪ User initiates the forgot password command.

▪ User is prompted to enter email and prompted with a link to recover password.
▪ System authenticaton.

Authorization Fails

▪ Allow the user to re-enter the password.

▪ New password and confirm password do not match. Allow the user to re-enter the
password. Give him 3 chances.

d) Depositing the amount

▪ After successfully logging into the system, the depositor has to apply the FD amount,
and then enter the registration date, maturity date and year.
▪ The only requirement here is that the depositor needs to log into the system.

4.3.2 Other Non-Functional Requirements:

a) Performance Requirements

▪ Should run on 500MHz, 64mb machine.

▪ 90% of responses should be within 3 second, except for downloading for which more
time is acceptable.

b) Security Requirements

▪ This application requires a user name with password is required to verify the
identification of the user.

4.3.3 External Interface Requirements

a) User Interfaces

Most user-friendly interface has been designed, Login pages for the users and admin. The
main interfaces used in the system are the forms and menus.

b) Hardware Interfaces

The system does not require any additional hardware interfaces, so the user need not
focus on the hardware apart from the standard hardware.
c) Software Interfaces

WAMP server, internet browser installed on the server machine.

 5.DESIGN OF THE SYSTEM

5.1 Introduction

The purpose of the decision phase is to plan a solution of the problem specified by the
requirements document. This phase is the first step in moving the problem domain to the solution
domain. It involves the process, in which conceiving, planning and carrying out the plan
generating the necessary report, In other words, the design phase act as a bridge between SRS
and implementation phase. The design of the system is perhaps the most critical factor affecting
the quality of the software, and as a major impact on the later phase, particularly the testing and
maintenance.

Software Design

Design is the key phase of any project. It is the first step in moving from the problem
domain to the solution domain. The input to the design phase is the specifications of the system
to be designed. The output of the top-level design is the architectural design, or the system design
for the software system to be built. A design should be very clear, verifiable, complete, traceable,
efficient and simple.

Architecture Design
The architecture design defines the relationship among major structural element of the
program. Architecture diagram shows the relationship between different components of system.
This diagram helps to understand the overall concept of system.
 Admin Web Wamp
Browser Server
which
manages Internet
user
interaction
with
website

Mysql

Logical design
The graphical representation of system data and how the process transforms the data
is known as Data Flow Diagram. It shows the logical flow of the data.
The logical design describes the detailed specification for the system, describing its
features, an effective communication and the user interface requirements. The logical design
of proposed system should include the following.

1. External system structure.

2. Relationship between all the activities.
3. The physical construction and all the activities.
4. Global data.
5. Control flow.
6. Derived program structure.

Design Principles

Basic design principles that enable the software engineer to navigate the design process are:

▪ The design process should not suffer from “Tunnel vision”.

▪ The design should be traceable to analysis model.

▪ The design should not reinvent the wheel.

▪ The design should minimize the intellectual distance between the software and the

problem, as it exists in the real world.

 ▪ The design should exhibit uniformity and integrity.

▪ The design should be structured to accommodate changes.

▪ The design is not coding, and coding is not design.

▪ The design should be reviewed to minimize the conceptual errors.

5.2 Data Flow Diagram

The data flow diagram (DFD) is one of the important modeling tools. It shows the user
of the data pictorially. DFD represents the flow of the data between different transformations
and processes in the systems. The data flow diagram shows logical flow of the data. It represents
the functional dependencies within a system. It shows output values in a computation or derived
from input values. It is a simple pictorial representation or model for system behavior. It
specifies, “What is to be done but not how is to be done”. It describes the logical structure of the
system. It relates data information to various processess of the system. It follows top-down
approach.
Data Flow Diagram Notations
Data Flow:

It may be from file-to-file or file-to-process or process-to-process. It is generally in terms

of attributes. There may be either an input data flow or output data flow.
Functional processing

The process is nothing but the transformation of data. It starts

With the subject and has the verb followed by the subject.
Data store

It includes file, data base and repository.

Actor/source/sink
The files which are outside the system and used by the process or processes of the system.

Objectives
• To graphically document boundaries of a system.
• To provide hierarchy breakdown of the system.
• To show movement of information between a system and its environment.
• To document information flows within the system.
• To aid communication between users and developers.

Context level diagram (zero level DFD)

Fig level 0 DFD: E-Postal Service

Context level diagram (one level DFD)

Fig level 1 DFD: E-Postal Service.
 5.3 ER Diagram

Fig (5.3): E-R Daigram of E-Postal Service.

 6. IMPLEMENTATION
6.1 Introduction
Implementation is the process of converting a new revised system design into operation. The
objective is to put the new revised system, which has been tested into operation while holding
costs, risks and personal irritation to the minimum. A critical aspect of the implementation
process is to ensure that there will be no description in the function of the organization. The
best methods for going control while implementation is that, any new system would be to use
well planned test files for testing all new programs. Another factor to be convinced in the
implementation phase in the acquisition of the hardware and software. Once the software is
developed for the system and testing is carried out, it is the process of making the newly
designed system fully operational and consistent in performance
Example
<?php

Echo “WELCOME TO OUR PROJECT”

?>

Speed optimization
As with many scripting languages, PHP scripts are normally kept as human-readable
source code, even on production web servers. In this case, PHP scripts will be compiled at
runtime by the PHP engine, which increases their execution time. PHP scripts are able to be
compiled before runtime using PHP compilers as with other programming languages such as
C (the language PHP and its extensions are written in). Code optimizers aim to reduce the
computational complexity of the compiled code by reducing its size and making other changes
that can reduce the execution time with the overall goal of improving performance. The nature
of the PHP compilers such that there are often opportunities for code optimization, and an
example of a code optimizer is the Zend Optimizer PHP extension.

Another approach for reducing overhead for high load PHP servers is using PHP accelerators.
These can offer significant performance gains by caching the compiled form of a PHP script in
shared memory to avoid the overhead of parsing and compiling the code every time the script
runs.

Example to display message using HTML page

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Untitled Document</title>

</head>

<body>

<h1>WELCOME TO OUR PROJECT</h1>

</body>

</html>
Output

6.2 Database Evolution

SQL was invented in the year 1960’s by E. F. Cod of IBM in order to increase data integrity
and reduce repetitive data. RDBMS did not appear until the late 70’s when Sybase and Oracle
introduced systems.
SQL server was originally a Sybase product. Microsoft bought the product outright from Sybase
and by version 7.0, the version prior to 2000 all the code had been rewritten by Microsoft’s
programming.
Features of SQL
• The entire SQL has been divided into 4 major categories
1. Data Manipulation Language.
2. Data Definition Language.
3. Transaction control language.
4. Data Control Lnaguage.
• It is simple English like language and uses simple commands such as SELECT,
CREATE, DROP etc.
• It is not having conditional loops, variables and most of the commands are single line
commands.
• To implement application logics, SQL has got extension language popularly called as
PL/SQL (Procedural language of SQL).
 • One of the key features of sql server is the XML support. XML has grown to be standard
technology for organizations that share data on the web.

Security
Views are basically used as a part of security, means in many organizations end user will
never be given original tables and all data entry will be done with the help of views only. But
the database administrator will be able to see everything because all the operations done by the
different users will come to the same table.
Queries

A query is a question or a request. With MySql, we can query a database for specific
information and have a record set returned.

Create a connection to a database

Before you can access data in a database, you must create a connection to the database. In
PHP, this is done with the mysql_connect () function.

Syntax

Mysql connect (server name, username, password);

Server name: Optional Specifies the Server to connect.

Default values is localhost: 3306

<?php
$con=mysql_connect('localhost','root','');
mysql_select_db ('project', $con); ?>

Steps to create a database in PHPMyAdmin

1) The following figure shows your PHPMyAdmin interface, just enter your database name and
click the 'Create' button to create your database.

2) Now to create a new table enter your table name and the number of fields in the table, then
click the 'Go' Button.
 3)The next step is to create the fields, just enter values for each field name, type, length of the
field, null option and mention whether it is a primary key or not. Then click the 'Save' button
to complete your table creation.

4) The following figure is displayed upon successful creation of your table

Steps to Drop Table in PHPMyAdmin

Login to phpmyadmin. Click 'databases'

List of your databases will appear. Click the one that is your WordPress database.

Note the size of the 'wp_bad_behaviour_log' table - this is one to be emptied in this example.
Now select the box to the left of the table you wish to empty.
Note: Your table may have a different name, and unless you have been told, do NOT empty a
table that is used by the Word Press core.

From the drop-down menu, highlight and click the 'Empty' option.
You will now get a confirmation screen.
This is your last chance to check - there is no 'UNDO' function here!
Click 'Yes' and you will be returned to viewing all the tables in your install.
And your table has been cleared out.
If you needed to Drop a table, follow exactly the same, but select 'Drop' from the menu.
 7.DATABASE TABLES

7.1 Tables Used In Our Project

Table structure for account_holder table
Primary Key: account_holder_id
Field Type Null Default

account_holder_id Int (11) No NULL

user_id Int (11) No NULL

account_type Varchar (50) No NULL

account_no Bigint (20) No NULL

created_date Date No NULL

branch_id Int (11) No NULL

account_status Varchar (50) No NULL

Table structure for branch_details table

Primary Key: branch_id
Field Type Null Default

branch_id Int (11) No NULL

branch_name Varchar (100) No NULL

branch_address Varchar (400) No NULL

Table structure for e_letters table

Primary Key: e_letter_id
Field Type Null Default

e_letter_id Int (11) No NULL

from_user_id Int (11) No NULL

to_user_id Int (11) No NULL

Subject Varchar (100) No NULL

Message Varchar (500) No NULL

Date Date No NULL

Status Varchar (50) No NULL

 Table structure for fd_details table
Primary Key: fd_id
Field Type Null Default

fd_id Int (11) No NULL

user_id Int (11) No NULL
fd_amount Int (11) No NULL
fd_interest_id Int (11) No NULL
fd_registration_date Date No NULL
fd_status Varchar (200) No NULL
maturity_date Date No NULL
maturity_year Int (11) No NULL
Table structure for login table
Primary Key: login_id
Field Type Null Default

login_id Int (11) No NULL

user_name Varchar (100) No NULL
Password Varchar (100) No NULL
Type Varchar (100) No NULL
security_question Varchar (100) No NULL

security_answer Varchar (100) No NULL

Table structure for notification table

Primary Key: notification_id
Field Type Null Default

notification_id Int (11) No NULL

notification_name Varchar (100) No NULL

notification_description Varchar (500) No NULL

notification_date Date No NULL

notification_status Varchar (100) No NULL

Table structure for transaction table
Primary Key: transaction_id
Field Type Null Default

transaction_id Int (11) No NULL

account_holder_id Int (11) No NULL

transaction_type Varchar (100) No NULL

transaction_amt Int (11) No NULL

transaction_datetime Date No NULL

Table structure for user_details table

Primary Key: user_id
Field Type Null Default

user_id Int (11) No NULL

user_full_name Varchar (200) No NULL

user_dob Date No NULL

user_address Varchar (300) No NULL

user_email_id Varchar (50) No NULL

user_contact_no Bigint (10) No NULL

user_pincode Int (11) No NULL

user_photo Varchar (200) No NULL

 8.SCREEN SHOTS

Fig 1. A VIEW OF HOMEPAGE

Fig 2. A VIEW OF LOGIN PAGE

Fig 3. A VIEW OF USER REGISTRATION PAGE

Fig 4. A VIEW OF ACCOUNT HOLDER TABLE

Fig 5. A VIEW OF BRANCH DETAILS TABLE

Fig 6. A VIEW OF DEPOSIT TABLE

Fig 7. A VIEW OF WITHDRAWALS DETAILS TABLE

Fig 8. A VIEW OF FD-CALCULATOR DETAILS TABLE

 Fig 9. A VIEW OF USER DETAILS TABLE

Fig 10. A VIEW OF E-LETTER TABLE

 9.SOURCE CODE

ACCOUNT HOLDER
FORM
<!doctype html>
<html class="no-js" lang="en">
<style type="text/css">
<!--
.style1 {
font-size: 30px;
font-weight: bold.
}
.style2 {font-size: 26px; font-weight: bold; }
-->
</style>

<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser.
Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your
experience.</p>
<![endif]-->

<?php include('sidebar.php'); ?>

<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
<!-- Mobile Menu start -->
 <?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->
<?php include('top_menu.php'); ?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-tb-15">
<div class="container-fluid">

<div class="row">

</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline12-list">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>All Form Element</h1>
</div>
</div>
<div class="sparkline12-graph">
<div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="all-form-element-inner">
<form name="form1" id="formID" method="post" action="account_holder_insert.php">
<p align="center" class="style2">Account Holder</p>
<table width="543" height="399" border="0" align="center">
<tr>
<td width="98">User Name </td>
<td width="168"><select class="validate[required] form-control" name="user_id"
id="user_id">
 <option value="" >Select User</option>
<?php
include("../dbconnect/db_connect.php");
$sql1="select * from user_details";
$res1=mysqli_query($conn,$sql1);
while($row1=mysqli_fetch_array($res1))
{
?>
<option value="<?php echo $row1['user_id']; ?>"><?php echo
$row1['user_full_name']; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>Account Type </td>
<td><input name="account_type" class="validate[required,custom[onlyLetter]] form-
control" type="text" id="account_type"></td>
</tr>
<tr>
<td>Account Number</td>
<td><input name="account_no" type="text" class="validate[required,custom[bank]]
form-control" id="account_no"></td>
</tr>
<tr>
<td>Created Date </td>
<td><input name="created_date" type="text" class="validate[required,custom[date]]
form-control" id="created_date"></td>
</tr>
<tr>
<td>Branch Name </td>
 <td><select name="branch_id" id="branch_id" class="validate[required] form-control">
<option value="" >Select User</option>
<?php
include("../dbconnect/db_connect.php");
$sql2="select * from branch_details";
$res2=mysqli_query($conn,$sql2);
while($row2=mysqli_fetch_array($res2))
{
?>
<option value="<?php echo $row2['branch_id']; ?>"><?php echo
$row2['branch_name']; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>Account Status</td>
<td><input name="account_status" type="text" id="account_status"
class="validate[required,custom[onlyLetter]] form-control"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit" class="btn btn-info">
<input type="reset" name="Reset" value="Reset" class="btn btn-danger">
</div></td>
</tr>
</table>
<p align="center" class="style1">&nbsp;</p>
<p>&nbsp; </p>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Basic Form End-->
<?php include('footer.php'); ?>
<?php include('val.php'); ?>
</body>

</html>

Insert
<?php
include("../dbconnect/db_connect.php");
$user_id=$_POST['user_id'];
$account_type=$_POST['account_type'];
$a_no=$_POST['account_no'];
$create_date=$_POST['created_date'];
$branch_id=$_POST['branch_id'];
$a_status=$_POST['account_status'];

$sql="insert into account_holder

values(null,'$user_id','$account_type','$a_no','$create_date','$branch_id','$a_status')";
mysqli_query($conn,$sql);
?>
<script>
alert("Values are insered..!!" );
document.location="account_holder.php";

</script>

Delete
<?php
include("../dbconnect/db_connect.php");

$account_holder_id=$_REQUEST['account_holder_id'];

$sql="delete from account_holder where account_holder_id='$account_holder_id'";

mysqli_query($conn,$sql);
?>
<script>
alert('deleted...');
document.location="account_holder_view.php";
</script>

View
<!doctype html>
<html class="no-js" lang="en">

<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser.
Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your
experience.</p>
<![endif]-->
 <?php include('sidebar.php'); ?>
<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
<!-- Mobile Menu start -->
<?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->

<!-- Static Table Start -->

<div class="data-table-area mg-tb-15">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline13-list">
<div class="sparkline13-hd">
<div class="main-sparkline13-hd">
<h1>Account Holder</h1>
</div>
</div>
<div class="sparkline13-graph">
<div class="datatable-dashv1-list custom-datatable-overright">
<div id="toolbar">
<a
href="account_holder.php" class="btn btn-primary">ADD NEW</a>
<select class="form-control">

<option value="">Export Basic</option>

<option value="all">Export All</option>

<option value="selected">Export Selected</option>

 </select>
</div>
<table id="table" data-toggle="table" data-pagination="true" data-
search="true" data-show-columns="true" data-show-pagination-switch="true" data-show-
refresh="true" data-key-events="true" data-show-toggle="true" data-resizable="true" data-
cookie="true"
data-cookie-id-table="saveId" data-show-export="true" data-click-
to-select="true" data-toolbar="#toolbar">
<thead>

<tr>
<th>Account Holder Id </th>
<th>User Id </th>
<th>Account Type </th>
<th>Account Number </th>
<th>Created Date </th>
<th>Branch Id </th>
<th>Account Status </th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
include("../dbconnect/db_connect.php");
$sl=1;
$sql="select * from account_holder ah,user_details uid where ah.user_id=uid.user_id";
$res=mysqli_query($conn,$sql);
while($row=mysqli_fetch_array($res))
{
?>
<tr>
 <td>&nbsp;<?php echo $sl++; ?></td>
<td>&nbsp;<?php echo $row['user_full_name'];?></td>
<td>&nbsp;<?php echo $row['account_type'];?></td>
<td>&nbsp;<?php echo $row['account_no'];?></td>
<td>&nbsp;<?php echo $row['created_date'];?></td>
<td>&nbsp;<?php echo $row['branch_id'];?></td>
<td>&nbsp;<?php echo $row['account_status'];?></td>
<td><a href="account_holder_edit.php?account_holder_id=<?php echo
$row['account_holder_id'];?>" >Edit</a></td>
<td><a href="account_holder_delete.php?account_holder_id=<?php echo
$row['account_holder_id'];?>" onClick="return confirm('Are u sure want to
delete...');">Delete</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Static Table End -->
<?php include('footer.php'); ?>
</body>

</html>

Update
<?php
include("../dbconnect/db_connect.php");
$user_id=$_POST['user_id'];
$account_type=$_POST['account_type'];
$a_no=$_POST['account_no'];
$create_date=$_POST['created_date'];
$branch_id=$_POST['branch_id'];
$a_status=$_POST['account_status'];
$account_holder_id=$_POST['account_holder_id'];

$sql="update account_holder set

user_id='$user_id',account_type='$account_type',account_no='$a_no',created_date='$create_
date',branch_id='$branch_id',account_status='$a_status' where
account_holder_id='$account_holder_id'";
mysqli_query($conn,$sql);

?>
<script>
alert('Row is Updated..');
document.location="account_holder_view.php";
</script>

Edit
<!doctype html>
<html class="no-js" lang="en">

<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser.
Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your
experience.</p>
 <![endif]-->

<?php include('sidebar.php'); ?>

<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
<!-- Mobile Menu start -->
<?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->
<?php include('top_menu.php'); ?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-tb-15">
<div class="container-fluid">

<div class="row">

</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline12-list">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>Account Holder</h1>
</div>
</div>
<div class="sparkline12-graph">
<div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
 <div class="all-form-element-inner">
<?php
include("../dbconnect/db_connect.php");

$account_holder_id=$_REQUEST['account_holder_id'];
$sql="select * from account_holder where account_holder_id='$account_holder_id'";
$res=mysqli_query($conn,$sql);
$row=mysqli_fetch_array($res);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php include('val.php'); ?>
<form name="form1"id="formID" method="post" action="account_holder_update.php">
<input type="hidden" value="<?php echo $row['account_holder_id'];?>"
name="account_holder_id">
<p>Account Holder</p>
<table width="543" height="399" border="0" align="center">
<tr>
<td width="98">User Name </td>
<td width="168"><select class="validate[required] form-control"name="user_id"
id="user_id">
<option value="" >Select User</option>
 <?php

$sql1="select * from user_details";

$res1=mysqli_query($conn,$sql1);
while($row1=mysqli_fetch_array($res1))
{
?>
<option value="<?php echo $row1['user_id']; ?>" <?php
if($row1['user_id']==$row['user_id']){ ?> selected <?php } ?>><?php echo
$row1['user_full_name']; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>Account Type </td>
<td><input class="validate[required,custom[onlyLetter]] form-control"
name="account_type" type="text" id="account_type"value="<?php echo
$row['account_type'];?>"></td>
</tr>
<tr>
<td>Account Number</td>
<td><input class="validate[required,custom[bank]] form-control"name="account_no"
type="text" name="account_no" type="text" id="account_no"value="<?php echo
$row['account_no'];?>"></td>
</tr>
<tr>
<td>Created Date </td>
<td><input class="validate[required,custom[date]] form-control"name="created_date"
type="text" id="created_date"value="<?php echo $row['created_date'];?>"></td>
</tr>
<tr>
 <td>Branch Name </td>
<td><select class="validate[required] form-control"name="branch_id" id="branch_id">
<option value="" >Select User</option>
<?php
include("../dbconnect/db_connect.php");
$sql2="select * from branch_details";
$res2=mysqli_query($conn,$sql2);
while($row2=mysqli_fetch_array($res2))
{
?>
<option value="<?php echo $row2['branch_id']; ?>" <?php
if($row1['branch_id']==$row['branch_id']){ ?> selected <?php } ?>><?php echo
$row2['branch_name']; ?></option>
<?php
}
?>
</select></td>
</tr>
<tr>
<td>Account Status</td>
<td><input class="validate[required,custom[onlyLetter]] form-
control"name="account_status" type="text" id="account_status"value="<?php echo
$row['account_status'];?>"></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit"class="btn btn-info">
<input type="reset" name="Reset" value="Reset"class="btn btn-danger">
</div></td>
</tr>
</table>
<p>&nbsp; </p>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Basic Form End-->
<?php include('footer.php'); ?>
<?php include('val.php'); ?>
</body>

</html>

BRANCH DETAILS FORM

Form
<!doctype html>
<html class="no-js" lang="en">
<style type="text/css">
<!--
.style1 {
font-size: 26px;
font-weight: bold;
}
-->
</style>
<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser.
Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your
experience.</p>
<![endif]-->

<?php include('sidebar.php'); ?>

<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
<!-- Mobile Menu start -->
<?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->
<?php include('top_menu.php'); ?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-tb-15">
<div class="container-fluid">

<div class="row">

</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline12-list">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>Branch Details</h1>
 </div>
</div>
<div class="sparkline12-graph">
<div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="all-form-element-inner">
<form name="form1" id="formID" method="post" action="branch_details_insert.php">
<p>&nbsp;</p>
<p align="center" class="style1">Branch Details</p>
<table width="450" height="200" border="0" align="center">
<tr>
<td>Branch Name </td>
<td><input name="branch_name"class="validate[required,custom[onlyLetter]] form-
control" type="text" id="branch_name"></td>
</tr>
<tr>
<td>Addrees</td>
<td><textarea name="address"class="validate[required,custom[onlyLetter]] form-
control" id="address"></textarea></td>
</tr>
<tr>
<td colspan="2"><div align="center">
<input type="submit" name="Submit" value="Submit"class="btn btn-info ">
<input type="reset" name="Reset" value="Reset" class="btn btn-danger">
</div></td>
</tr>
</table>
<p>&nbsp; </p>
<p>&nbsp;</p>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Basic Form End-->
<?php include('footer.php'); ?>
<?php include('val.php'); ?>
</body>

</html>

Insert
<?php
include("../dbconnect/db_connect.php");
$branch_name=$_POST['branch_name'];
$address=$_POST['address'];
$sql="insert into branch_details values(null,'$branch_name','$address')";
mysqli_query($conn,$sql);

?>
<script>
alert("values are inserted..!!");
document.location="branch_details.php";
</script>

Delete
<?php
include("../dbconnect/db_connect.php");

$branch_id=$_REQUEST['branch_id'];

$sql="delete from branch_details where branch_id='$branch_id'";

mysqli_query($conn,$sql);
?>
<script>
alert('deleted...');
document.location="branch_details_view.php";
</script>

View
<!doctype html>
<html class="no-js" lang="en">

<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser.
Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your
experience.</p>
<![endif]-->

<?php include('sidebar.php'); ?>

<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
 <!-- Mobile Menu start -->
<?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->

<!-- Static Table Start -->

<div class="data-table-area mg-tb-15">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline13-list">
<div class="sparkline13-hd">
<div class="main-sparkline13-hd">
<h1>Branch Details</h1>
</div>
</div>
<div class="sparkline13-graph">
<div class="datatable-dashv1-list custom-datatable-overright">
<div id="toolbar">
<a
href="branch_details.php" class="btn btn-primary">ADD NEW</a>
<select class="form-control">

<option value="">Export Basic</option>

<option value="all">Export All</option>

<option value="selected">Export Selected</option>

</select>
</div>
<table id="table" data-toggle="table" data-pagination="true" data-
search="true" data-show-columns="true" data-show-pagination-switch="true" data-show-
refresh="true" data-key-events="true" data-show-toggle="true" data-resizable="true" data-
cookie="true"
 data-cookie-id-table="saveId" data-show-export="true" data-click-
to-select="true" data-toolbar="#toolbar">
<thead>
<!---------------end of
templete--------------------->

<tr>
<th>Sl no</th>
<th>Branch Name </th>
<th>Address</th>
<th>Edit</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php
include("../dbconnect/db_connect.php");
$sl=1;
$sql="select * from branch_details bid,account_holder aid where
bid.branch_id=aid.branch_id";
$res=mysqli_query($conn,$sql);
while($row=mysqli_fetch_array($res))
{
?>

<tr>
<td>&nbsp;<?php echo $sl++; ?></td>
<td>&nbsp;<?php echo $row['branch_name'];?></td>
<td>&nbsp;<?php echo $row['branch_address'];?></td>
<td><a href="branch_details_edit.php?branch_id=<?php echo $row['branch_id'];?>"
>Edit</a></td>
 <td><a href="branch_details_delete.php?branch_id=<?php echo $row['branch_id'];?>"
onClick="return confirm('Are u sure want to delete...');">Delete</a></td>
</tr>
<?php
}
?>

<!-------------------------------------------------------------->
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Static Table End -->
<?php include('footer.php'); ?>
</body>

</html>

Update
<?php
include("../dbconnect/db_connect.php");
$branch_name=$_POST['branch_name'];
$address=$_POST['address'];
$branch_id=$_POST['branch_id'];
$sql="update branch_details set branch_name='$branch_name',branch_address='$address'
where branch_id='$branch_id'";
mysqli_query($conn,$sql);
?>
<script>
alert('Row is Updated..');
document.location="branch_details_view.php";
</script>

Edit
<!doctype html>
<html class="no-js" lang="en">

<?php include('metatag.php'); ?>

<body>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong>
browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to
improve your experience.</p>
<![endif]-->

<?php include('sidebar.php'); ?>

<!-- Start Welcome area -->
<?php include('header.php'); ?>
<!-- Mobile Menu start -->
<!-- Mobile Menu start -->
<?php include('mobile_menu.php'); ?>
<!-- Mobile Menu end -->
<?php include('top_menu.php'); ?>
<!-- Basic Form Start -->
<div class="basic-form-area mg-tb-15">
<div class="container-fluid">

<div class="row">

</div>
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="sparkline12-list">
<div class="sparkline12-hd">
<div class="main-sparkline12-hd">
<h1>Branch Details</h1>
</div>
</div>
<div class="sparkline12-graph">
 <div class="basic-login-form-ad">
<div class="row">
<div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
<div class="all-form-element-inner">
<?php
include("../dbconnect/db_connect.php");

$branch_id=$_REQUEST['branch_id'];
$sql="select * from branch_details where branch_id='$branch_id'";
$res=mysqli_query($conn,$sql);
$row=mysqli_fetch_array($res);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Untitled Document</title>
</head>

<body>
<?php include('val.php'); ?>
<form name="form1"id="formID" method="post" action="branch_details_update.php">
<div align="left">
<input type="hidden" value="<?php echo $row['branch_id'];?>" name="branch_id">
</div>
<p>&nbsp;</p>
<p align="center"></p>
<p align="center">Branch Details</p>
<table width="410" height="229" border="0" align="center">
<tr>
<td height="56">Branch Name </td>
<td><input class="validate[required,custom[onlyLetter]] form-
control"name="branch_name" type="text" id="branch_name" value="<?php echo
$row['branch_name'];?>"></td>
</tr>
<tr>
<td height="98">Addrees</td>
<td><textarea class="validate[required,custom[onlyLetter]] form-
control"name="address" id="address"><?php echo
$row['branch_address'];?></textarea></td>
</tr>
<tr>
<td colspan="2"><div align="center">
 <input type="submit" name="Submit" value="Submit"class="btn btn-info">
<input type="reset" name="Reset" value="Reset"class="btn btn-danger">
</div></td>
</tr>
</table>
<p align="center"></p>
<p>&nbsp; </p>
<p>&nbsp;</p>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- Basic Form End-->
<?php include('footer.php'); ?>
<?php include('val.php'); ?>
</body>

</html>
 10.TESTING

10. 1 SYSTEM TESTING

10.1.1 Introduction
Testing is a process of executing a program with the indent of finding an error. Testing is a
crucial element of software quality assurance and presents ultimate review of specification,
design and coding. System Testing is an important phase. Testing represents an interesting
anomaly for the software. Thus, a series of testing are performed for the proposed system before
the system is ready for user acceptance testing. The code is tested at various levels in software
testing. Unit, system and user acceptance testings are often performed.
Testing Objectives

• Testing is a process of executing a program with the intent of finding an error.

• A good test case is one that has a probability of finding an as yet undiscovered error.
• A successful test is one that uncovers an undiscovered error.

Testing Principles
• All tests should be traceable to end user requirements.
• Tests should be planned long before testing begins.
• Testing should begin on a small scale and progress towards testing in large.
• Exhaustive testing is not possible.
• To be most effective testing should be conducted by a independent third party.

The primary objective for test case design is to derive a set of tests that has the highest livelihood
for uncovering defects in software. To accomplish this objective two different categories of test
case design techniques are used. They are:

• White box testing.

• Black box testing.

White-Box Testing and Black-Box Testing

White Box Testing: White box testing focus on the program control structure. Test cases
are derived to ensure that all statements in the program have been executed at least once during
testing and that all logical conditions have been executed.

Black Box Testing: Black box testing is designed to validate functional requirements
without regard to the internal workings of a program. Black box testing mainly focuses on the
information domain of the software, deriving test cases by partitioning input and output in a
manner that provides through test coverage. Incorrect and missing functions, interface errors,
errors in data structures, error in functional logic are the errors falling in this category.

Testing strategies: A strategy for software testing must accommodate low-level tests that are
necessary to verify that all small source code segment has been correctly implemented as well
as high-level tests that validate major system functions against customer requirements.

There are two general strategies for testing software. They are as follows:

Code Testing: This examines the logic of the program. To follow this test, cases are developed
such that every path of program is tested.

Specification Testing: Specification Testing examines the specification, starting what the
program should do and how it should perform under various conditions. Then test cases are
developed for each condition and combinations of conditions and to be submitted for processing.

10.1.2 Levels of Testing

The stages of Testing Process are:

Unit Testing: Individual components are tested to ensure that they operate correctly. Each
component tested independently without other system components. Ex. Check for Username and
Password with the table, after the next module is loaded.

Integration Testing: Integration testing is a systematic technique for constructing the program
structure while at the same time conducting test to uncover errors associated with interfacing.
This testing is done using the bottom-up approach to integrate the software components of the
software system in to functioning whole.

System Testing: System testing is actually a series of different tests whose primary purpose
is fully to exercise the computer-based system. The system tests that where applied are recovery
testing and performance testing. Finally, a review or audit is conducted which is a final
evaluation that occurs only after operating the system long enough for user to have gained a
familiarity with it. System testing was done by the inspection team to verify that all the
functionality identified is the software requirement specification has been implemented. Defects
that crept in the system has been found defect free and is working well. System testing is
concerned with interfaces, design logic, control flow recovery, procedures throughput, capacity
and timing characteristics of the entire system. For blank field, alphabets, number and special
character validation.

Acceptance Testing: User acceptance of the system is the key factor for the success of any
system. This is done by user. The system is given to the user and they test it with live data.
Acceptance testing involves the planning and execution of functional test. Performance tests,
stress tests in order to demonstrate that the implemented system satisfies its requirements. Two
sets of acceptance test can be run, those developed by the customer. The system has been tested
for its performance at unit level by the individuals through performance testing that is designed
to test the run time performance of the software. The performance of the fully integrated system
is tested and was found good.
 10.2 Validating the tables

Login Form

Fig (10.2.1): login

Fig (10.2.2): login

The above screenshot is showing the error message that we should enter valid username and
password.
 ACCOUNT HOLDER Table
Adding a new value to the table

Fig (10.2.3): Account Holder

Login Form

Fig (10.2.4): Logout

BRANCH DETAILS Table

Fig (10.2.5): Branch Details

E-Letter Table

Fig (10.2.6): E-Letter

 FD-DETAILS Table

Fig (10.2.7): FD-Details

NOTIFICATION TABLE

Fig (10.2.8): Notification.

 Transaction Table

Fig (10.2.9): Transaction

USER-DETAILS Table

Fig (10.2.10): User Details

 10.3 Functional Testing

Test No Test Case Expected Result Actual Result Result

1 Valid
Username It should display respective
Respective Home is Fig
and page according to user type.
displayed (10.2.1)
Password

2 Invalid It should give appropriate

Username error message saying “Enter
Error message displayed Fig
and proper User-ID and
(10.2.2)
Password Password”

3 Add/Update
/Delete Add/Delete/Update action is Added/Updated/Deleted Fig
Member taken. Member message Displayed (10.2.3)
Details

4 It should logout correctly and Logout message displayed

Logout should not go to the home and login page is shown Fig
page (10.2.4)

5 Insert Values will be inserted in the

Choose branch name and
branch table
Fig
branch address and submit
details
(10.2.5)
the values

6 Blank field
It should give appropriate
while Display appropriate error Fig
error message
inserting message (10.2.6)
7 Valid FD FD details is stored while
It should insert the FD
details inserting
details into the database Fig
should be
while inserting (10.2.7)
provided

8 Insert values Display appropriate error

without message
It must give an error Fig
notification
message while inserting (10.2.8)
status and
submit

9 Insert values It will display the error

without message
It must give an error Fig
account
message while inserting (10.2.9)
holder name
and submit

10 Enter It will display the error Fig

It should give appropriate
invalid message (10.2.10)
message as “Mobile number
mobile
entered is incorrect”
number
 11.CONCLUSION
Software is said to have attained its objective only when it need all requirements of the user,
further the user himself is the person to judge the success of the system. Every attempt has been
made to ensure that the system is fully functional and works effectively and efficiently. The
system has been tested with simple data to cover all possible options and checked for all outputs.
Since the system is flexible and modular, further modification of this packge can be easily
incorporated.

Importance of the system

• Less manual work.
• Increased efficiency.
• Decreases the rate of errors.
• It reduces the time consumption.
• Quick (instant) result.

12.BIBLIOGRAPHY
12.1 Books

1. “Software Engineering”, by Ian Somerville, Sixth Edition, Pearson Education Ltd

2007.
2. “Web Programming”, by ‘Chris Bates’ Wiley Dreamtech India, 2nd Edition.
3. IEEE SRS Format.
4. Database Management Systems, by Navathe.

12.2 Websites
1. http://www.hotscripts.com/category/php/ for Php
2. http://en.wikipedia.org/wiki/PHP for Php.
3. http://www.mysql.com/click.php?e=35050 for MySql.