ABSTRACT

The Loan management system is important and helps to ensure success or failure of any credit
institution. Mortgage loan problems have always been a key note on the risk of loan loss. The scope of
this project is to provide good communication and communication between the customer and the
manager. The current system can be a user-friendly system, which does not store data in the proper
security and can easily track information and contains the operation of fast-recovery information, such as
customer data, all loan details and includes many documents. The Financial Management System is
designed to perform the functions of the back offices of a bank and a non-cash financial institution offers
any sort of loan. The system can make daily operations more efficient and provide faster response.
Including adding, editing, retrieving customer information, maintaining and issuing new loans, change
the loan rate. The scope of this project is to use the loan in a very smart way. The project includes a
system analysis and style for obtaining a loan details process, settlement process, and approving the
payment process. the existing system identifies issues arising from the functionality of the book. This
project is designed to hit many issues such as data shortage, data inaccuracy, time, etc. The new
computerized system will minimize errors while providing more control over the system and more robust
management information in the form of implementation strategies. The new system was monitored to
ensure that there was no error in the systems, so the program results met the export target financial target.
to enhance the effective management of consumers, the system must also be developed to support other
bidding loan details.

1
 1.INTRODUCTION
It is basically an online application that helps in the process of organizing loan management for client
and institutions When the client or the beneficiary takes a loan or his loan from the institution, the
institution shall sign the contracts Login to the site and registration as an institution and then enter the
data of the beneficiaries and give them a user name and password, Then the customer can see his file
within the institution and know the amounts paid and the amounts remaining And the installments that
are plagued by it without the need to go to the institution and also can apply for a new loan and so the
customer service within the system , And the institutions benefit from the system to get full access to the
files of customers and knowledge of customers defaulting on payment and inclusion in a special lis You
can also view and provide loans to new loan applicants from the same clients With the services provided
by the site to customers and institutions we achieved the goal of the site and save time and effort

This program is called an loan management program. This approach is intended to simply preserve the
details of the direct lenders. This method is created to keep records about consumers who have taken out
bank loans. A registered user can sign in to the Loan system using their email id or user id and password.
After logging in to this process there are decisions to add new customers, manage old customer account
and check other details etc. Many new customers are visiting this bank, so adding new customer
information and keeping records is very easy to use. There are many other ways like changing the repo
rate, adding new accounts etc. New and unique ids are provided to everyone who subscribes in this way
and to their borrowers. There are decisions to evaluate the customer's loan amount, rate and unpaid
amount. The amount paid by any customer or can be kept there and it is easy to calculate daily how much
money is collected. Bank employees are a type of manager, the cashier can also assess their customer's
key points if any customer has not paid a monthly instalment for the past three months.. It's easy to
calculate money with a hosting account every month. this method also has the option of running a
backup, which means that if we back up the database it will never be lost. It can even take away the
working class and can even manage their account for wages. An employee may have taken out a loan
that the bank may appear to have. Therefore, this whole loan management system can be the solution to
all of the issues we face in the industry at large

2
 SYSTEM ANALYSIS

2.1 EXISTING SYSTEMS

The existing system is available only to the banks and not available to the customers who want to know
the mortgage loan processing procedures and apply. Customers need to go bank every time to get any
information its very time taking process. Once they get the information they have to go to bank to get
loan and fill the loan application. For verification of loan approve or not even customers need to go bank
each and every time. After getting the loan even customer need go bank every month to pay monthly
payment. For banks also it is tedious job to maintain details of customer by taking details through hard
copy and it is time taking for bank employees to explain all loan types and their details to every customer

Disadvantage:

• It is time consuming as the system is handled manually.

• Assurance of data security is not given.

• In long run, it is difficult to maintain records.

• Manpower requirement is huge.

• It is hectic to handle the huge transaction

2.2PROPOSED SYSTEM

This application Online Loan Management System allows applicants to go for thorough verifications of
all concerns and to choose the best suitable scheme for them. Online Loan Management System is
provided in the application with various controls provided by system Rich User Interface. The system
will make the interaction between the Admin, Employee, Customers etc. very quickly which saves lots of
time. The system is the centralized location for the entire customers at where they can find the required
Loan details of that bank. Online Loan Management System makes the overall project management
much easier and flexible. Customers can see the bank information like loans provided by that bank and
their interest details. Customers can apply for loan in online and they can verify their application status.

3
The user information can be stored in centralized database which can be maintained by the system.
Online Loan Management System can give the good security for user information. Authentication is
provided for this application only registered Users can access. After getting the loan customer can pay
term payment in online.

2.3. MODULE DESCRIPTION

Our system has two main mechanisms One is for consumers and the other is for user who
accomplishes all the bank accounts. In connection with this, we have another meeting point
which can be discussed below:
Administration: Management is the one that guarantees the user or customer that will be
registered in the system. There can be one administrative account and all additional accounts
can be user or customer. Management can't see the main points of loan accounts, only the user
and customers can see them. Management can only increase or decrease accounts.
Sign in: After registration one can sign in to the system because the system operator on behalf
of user. After this, you have conflicting workplaces available for additional actions such as
adding and removing doctors and other members etc.
Adding New Accounts: The first opportunity offered within the loan management system is to
add new customers or more important users. When a replacement customer goes to the bank,
then they may need an account or may want to open it. A customer with an account inside a
bank can only take out a loan whether the user applies for a loan or not, their account must be
opened inside the bank first. Therefore, inserting new customer information into a database is
very important for the user to perform crazy tasks. Personal address details, number, disease or
problematic and a few different things are requested.
Keeping loan details: Another function provided by this software is to maintain important
customer loan points. For example, which number entries are paid by the user and how many
are left. How many instalments have not been paid by the customer in the past etc. When and
how long your loan will pass and the loan taken by any customer.
Keeping Records: The customer can raise its main points at any time. and another loan if they
need it. it is important to take care of patient records properly. This feature is provided by this
system. It stores all the database and by entering the customer id and name it will be
downloaded whenever needed.

4
Monthly filing and interest rate: As the repo rate increases or decreases by RBI so banks also
increase their cost per unit. Therefore, it is important to understand the cost charged per unit to
the customer in relation to the customer paying the price. The price of installation can increase
or decrease if the customer wants.
Bank details: Since this method will be used for any bank there is a chance of getting a higher
bank score so points regarding bank branches when sellers take out loans from specific branches
of the bank. This program is intended to keep in mind that there may be many different banks
implementing this method. After making the main points a couple of one bank will be required
once all the details have been added and additional branches will be added. If a customer wants
to require a loan from a bank branch within the loan program, the loan will not be granted
because it would be a fraudulent offense.

5
 3.SYSTEM STUDY
3.1 FEASIBILITY STUDY
The feasibility of the project is analyzed in this phase and business proposal is put forth with a
very general plan for the project and some cost estimates. During system analysis the feasibility study
of the proposed system is to be carried out. This is to ensure that the proposed system is not a burden
to the company. For feasibility analysis, some understanding of the major requirements for the system
is essential.
Three key considerations involved in the feasibility analysis are
 ECONOMICAL FEASIBILITY
 TECHNICAL FEASIBILITY
 SOCIAL FEASIBILITY

3.1.1. ECONOMICAL FEASIBILITY

This study is carried out to check the economic impact that the system will have
on the organization. The amount of fund that the company can pour into the research and
development of the system is limited. The expenditures must be justified. Thus the developed
system as well within the budget and this was achieved because most of the technologies
used are freely available. Only the customized products had to be purchased.

3.1.2 TECHNICAL FEASIBILITY

This study is carried out to check the technical feasibility, that is, the technical
requirements of the system. Any system developed must not have a high demand on the
available technical resources. This will lead to high demands on the available technical
resources. This will lead to high demands being placed on the client. The developed system
must have a modest requirement, as only minimal or null changes are required for
implementing this system.

6
 3.1.3 SOCIAL FEASIBILITY
The aspect of study is to check the level of acceptance of the system by the user.
This includes the process of training the user to use the system efficiently. The user must not
feel threatened by the system, instead must accept it as a necessity. The level of acceptance
by the users solely depends on the methods that are employed to educate the user about the
system and to make him familiar with it. His level of confidence must be raised so that he is
also able to make some constructive criticism, which is welcomed, as he is the final user of
the system.
3. 2 SYSTEM REQUIREMENTS:
HARDWARE REQUIREMENTS
 Pentium IV and above
 Processor

 Processor Speed  1.4 Hz

 Ram Size  1 GB

 Hard Disk Size  80GB

SOFTWARE REQUIREMENTS:

 Operating System : Windows 7 Ultimate / Professional

 Programming Language : PHP, HTML,
 Scripting language : Java Script
 DataBase : MySQL Database and MySQL utilities

7
 4. SYSTEM DESIGN

DATA FLOW DIAGRAM:

A Data Flow Diagram (DFD) is a traditional visual representation of the information

flows within a system. A neat and clear DFD can depict the right amount of the system
requirement graphically. It can be manual, automated, or a combination of both.

It shows how data enters and leaves the system, what changes the information, and where
data is stored.

The objective of a DFD is to show the scope and boundaries of a system as a whole. It
may be used as a communication tool between a system analyst and any person who plays
a part in the order that acts as a starting point for redesigning a system. The DFD is also
called as a data flow graph or bubble chart.

The following observations about DFDs are essential:

1. All names should be unique. This makes it easier to refer to elements in the DFD.
2. Remember that DFD is not a flow chart. Arrows is a flow chart that represents the
order of events; arrows in DFD represents flowing data. A DFD does not involve
any order of events.
3. Suppress logical decisions. If we ever have the urge to draw a diamond-shaped
box in a DFD, suppress that urge! A diamond-shaped box is used in flow charts to
represents decision points with multiple exists paths of which the only one is
taken. This implies an ordering of events, which makes no sense in a DFD.
4. Do not become bogged down with details. Defer error conditions and error
handling until the end of the analysis.

Standard symbols for DFDs are derived from the electric circuit diagram analysis and are
shown in fig:

8
Circle: A circle (bubble) shows a process that transforms data inputs into data outputs.

Data Flow: A curved line shows the flow of data into or out of a process or data store.

Data Store: A set of parallel lines shows a place for the collection of data items. A data
store indicates that the data is stored which can be used at a later stage or by the other
processes in a different order. The data store can have an element or group of elements.

Source or Sink: Source or Sink is an external entity and acts as a source of system inputs
or sink of system outputs.

9
4.1.UML DIAGRAMS

Systems design is the process of defining the architecture, components, modules,

interfaces, and data for a system to satisfy specified requirements. One could see it as the
application of systems theory to product development. There is some overlap with the
disciplines of systems analysis, systems architecture and systems engineering. If the broader
topic of product development "blends the perspective of marketing, design, and
manufacturing into a single approach to product development, then design is the act of
taking the marketing information and creating the design of the product to be manufactured.

Systems design is therefore the process of defining and developing systems to satisfy
specified requirements of the user.
UML DIAGRAMS

The Unified Modelling Language (UML) is a standard language for specifying,

10
 visualizing, constructing, and documenting the artifacts of software systems, as well as for
business modeling and other non-software systems. The UML represents a collection of best
engineering practices that have proven successful in the modeling of large and complex
systems. The UML is a very important part of developing objects oriented software and the
software development process. The UML uses mostly graphical notations to express the
design of software projects. Using the UML helps project teams communicate, explore
potential designs, and validate the architectural design of the software.
As the strategic value of software increases for many companies, the industry looks
for techniques to automate the production of software and to improve quality and reduce
cost and time-to-market. These techniques include component technology, visual
programming, patterns and frameworks. Businesses also seek techniques to manage the
complexity of systems as they increase in scope and scale. In particular, they recognize the
need to solve recurring architectural problems, such as physical distribution, concurrency,
replication, security, load balancing and fault tolerance. Additionally, the development for
the World Wide Web, while making some things simpler, has exacerbated these
architectural problems. The Unified Modeling Language (UML) was designed to respond to
these needs. Simply, Systems design refers to the process of defining the architecture,
components, modules, interfaces, and data for a system to satisfy specified requirements
which can be done easily through UML diagrams. a class diagram in the Unified Modeling
Language (UML) is a type of static structure diagram that describes the structure of a
system by showing the system's classes, their attributes, operations (or methods), and the
relationships among the classes. It explains which class contains information. The goal is for
UML to become a common language for creating models of object oriented computer
software. In its current form UML is comprised of two major components: a Meta-model
and a notation. In the future, some form of method or process may also be added to; or
associated with, UML.
CONTENTS OF UML

In general, a UML diagram consists of the following features:

 Entities: These may be classes, objects, users or systems behaviors.

 Relationship Lines that model the relationships between entities in the

11
 system.
 Generalization -- a solid line with an arrow that points to a higher
abstraction of the present item.
 Association -- a solid line that represents that one entity uses another
entity as part of its behaviour.
 Dependency -- a dotted line with an arrowhead that shows one entity
depends on the behaviour of another entity.

In this project four basic UML diagrams have been explained

1) Class Diagram

2) Use Case Diagram

3) Sequence Diagram

• USE CASE DIAGRAM

A usecase diagram in the Unified Modelling Language (UML) is a type of

behavioural diagram defined by and created from a Use-case analysis. Its purpose is to
present a graphical overview of the functionality provided by a system in terms.
A use case is a methodology used in system analysis to identify, clarify, and
organize system requirements. The use case is made up of a set of possible sequences of
interactions between systems and users in a particular environment and related to a
particular goal. It consists of a group of elements (for example, classes and interfaces) that
can be used together in a way that will have an effect larger than the sum of the separate
elements combined. The use case should contain all system activities that have significance
to the users. A use case can be thought of as a collection of possible scenarios related to a
particular goal, indeed, the use case and goal are sometimes considered to be synonymous.
A use case diagram in the Unified Modeling Language (UML) is a type of behavioral
diagram defined by and created from a Use-case analysis. Its purpose is to present a
graphical overview of the functionality provided by a system in terms of actors, their goals
(represented as use cases), and any dependencies between those use cases.
12
 The main purpose of a use case diagram is to show what system functions are
performed for which actor. Roles of the actors in the system can be depicted.

13
CLASS DIAGRAM

UML class diagrams model static class relationships that represent the fundamental
architecture of the system. Note that these diagrams describe the relationships between
classes, not those between specific objects instantiated from those classes. Thus the diagram
applies to all the objects in the system. A class diagram in the Unified Modeling Language
(UML) is a type of static structure diagram that describes the structure of a system by
showing the system's classes, their attributes, operations (or methods), and the relationships
among the classes. It explains which class contains information.
A class diagram consists of the following features:

 Classes: These titled boxes represent the classes in the system and contain
information about the name of the class, fields, methods and access specifies.
Abstract roles of the Class in the system can also be indicated.
 Interfaces: These titled boxes represent interfaces in the system and contain

14
 information about the name of the interface and its methods. Relationship Lines
that model the relationships between classes and interfaces in the system.
 Dependency: A dotted line with an open arrowhead that shows one entity depends
on the behavior of another entity. Typical usages are to represent that one class
instantiates another or that it uses the other as an input parameter
 Aggregation: Represented by an association line with a hollow diamond at the tail
end. An aggregation models the notion that one object uses another object without
"owning" it and thus is not responsible for its creation or destruction.
 Inheritance: A solid line with a solid arrowhead that points from a sub-class to a
super class or from a sub-interface to its super-interface.
 Implementation: A dotted line with a solid arrowhead that points from a class to
the interface that it implement
 Composition: Represented by an association line with a solid diamond at the tail
end. A composition models the notion of one object "owning" another and thus
being responsible for the creation and destruction of another object.

15
SEQUENCE DIAGRAM

A sequence diagram in Unified Modelling Language (UML) is a kind of interaction

diagram that shows how processes operate with one another and in what order. It is a
construct of a Message Sequence Chart. A Sequence diagram depicts the sequence of
actions that occur in a system. The invocation of methods in each object, and the order in
which the invocation occurs is captured in a Sequence diagram. This makes the Sequence
diagram a very useful tool to easily represent the dynamic behaviour of a system.

16
 It is a construct of a Message Sequence Chart. Sequence diagrams are sometimes
called event diagrams, event scenarios, and timing diagrams. It shows object interactions
arranged in time sequence. It depicts the objects and classes involved in the scenario and the
sequence of messages exchanged between the objects needed to carry out the functionality
of the scenario. Sequence diagrams are typically associated with use case realizations in the
logical view of the system under development. Sequence diagram address the dynamic view
of the system.
 Elements of sequence diagram

The sequence diagram is an element that is used primarily to showcase the

interaction that occurs between multiple objects. This interaction will be shown over certain
period of time. Because of this, the first symbol that is used is one that symbolizes the
object.
 Lifeline

A lifeline will generally be generated, and it is a dashed line that sits vertically, and
the top will be in the form of a rectangle. This rectangle is used to indicate both the instance
and the class. If the lifeline must be used to denote an object, it will be underlined.
 Messages

To showcase an interaction, messages will be used. These messages will come in the
form of horizontal arrows, and the messages should be written on top of the arrows. If the
arrow has a full head, and it’s solid, it will be called a synchronous call. If the solid arrow
has a stick head, it will be an asynchronous call. Stick heads with dash arrows are used to
represent return messages.
 Objects

Objects will also be given the ability to call methods upon themselves, and they can
add net activation boxes. Because of this, they can communicate with others to show
multiple levels of processing. Whenever an object is eradicated or erased from memory, the
"X" will be drawn at the lifeline's top, and the dash line will not be drawn beneath it. This
will often occur as a result of a message. If a message is sent from the outside of the
diagram, it can be used to define a message that comes from a circle that is filled in. Within

17
a UML based model, a Super step is a collection of steps which result from outside stimuli.

18
4.2. DATABASE DESIGN
Database design is the process of producing a detailed data model of database. This data model
contains all the needed logical and physical design choices and physical storage parameters needed to
generate a design in a data definition language, which can then be used to create a database. A fully
attributed data model contains detailed attributes for each entity.The term database design can be used to
describe many different parts of the design of an overall database system. Principally, and most correctly,
it can be thought of as the logical design of the base data structures used to store the data. In the relational
model these are the tables and views. In an object database the entities and relationships map directly to
object classes and named relationships. However, the term database design could also be used to apply to
the overall process of designing, not just the base data structures, but also the forms and queries used as
part of the overall database application within the database management system (DBMS).
The process of doing database design generally consists of a number of steps which will be carried out by
the database designer. Usually, the designer must:
 Determine the data to be stored in the database.
 Determine the relationships between the different data elements.
 Superimpose a logical structure upon the data on the basis of these relationships.
Within the relational model the final step above can generally be broken down into two further steps, that
of determining the grouping of information within the system, generally determining what are the basic
objects about which information is being stored, and then determining the relationships between these
groups of information, or objects. This step is not necessary with an Object database.

19
5. COMPUTATIONAL ENVIRONMENT
20
 The whole Project is divided in two parts the front end and the back end.
FRONT END

The front end is designed using of html , Php ,css, Java script
 HTML- HTML or Hyper Text Markup Language is the main markup language for
creating web pages and other information that can be displayed in a web browser.HTML
is written in the form of HTML elements consisting of tags enclosed in angle brackets
(like <html>), within the web page content. HTML tags most commonly come in pairs
like <h1> and </h1>, although some tags represent empty elements and so are unpaired,
for example <img>. The first tag in a pair is the start tag, and the second tag is the end tag
(they are also called opening tags and closing tags). In between these tags web designers
can add text, further tags, comments and other types of text-based content. The purpose of
a web browser is to read HTML documents and compose them into visible or audible web
pages. The browser does not display the HTML tags, but uses the tags to interpret the
content of the page.HTML elements form the building blocks of all websites. HTML
allows images and objects to be embedded and can be used to create interactive forms. It
provides a means to create structured documents by denoting structural semantics for text
such as headings, paragraphs, lists, links, quotes and other items. It can embed scripts written in
languages such as JavaScript which affect the behavior of HTML web pages.

 CSS- Cascading Style Sheets (CSS) is a style sheet language used for describing the look
and formatting of a document written in a markup language. While most often used to
style web pages and interfaces written in HTML and XHTML, the language can be
applied to any kind of XML document, including plain XML, SVG and XUL. CSS is a
cornerstone specification of the web and almost all web pages use CSS style sheets to
describe their presentation.CSS is designed primarily to enable the separation of
document content from document presentation, including elements such as the layout,
colors, and fonts. This separation can improve content accessibility, provide more
flexibility and control in the specification of presentation characteristics, enable multiple
pages to share formatting, and reduce complexity and repetition in the structural content
21
 (such as by allowing for table less web design).CSS can also allow the same markup page
to be presented in different styles for different rendering methods, such as on-screen, in
print, by voice (when read out by a speech-based browser or screen reader) and on
Braille-based, tactile devices. It can also be used to allow the web page to display
differently depending on the screen size or device on which it is being viewed. While the
author of a document typically links that document to a CSS file, readers can use a
different style sheet, perhaps one on their own computer, to override the one the author
has specified. However if the author or the reader did not link the document to a specific
style sheet the default style of the browser will be applied.CSS specifies a priority scheme
to determine which style rules apply if more than one rule matches against a particular
element. In this so-called cascade, priorities or weights are calculated and assigned to
rules, so that the results are predictable.

 JAVA SCRIPT- JavaScript (JS) is a dynamic computer programming language. It is

most commonly used as part of web browsers, whose implementations allow client-side
scripts to interact with the user, control the browser, communicate asynchronously, and
alter the document content that is displayed. It is also being used in server-side
programming, game development and the creation of desktop and mobile applications.
JavaScript is a prototype-based scripting language with dynamic typing and has first-
class functions. Its syntax was influenced by C. JavaScript copies many names and
naming conventions from Java, but the two languages are otherwise unrelated and have
very different semantics. The key design principles within JavaScript are taken from the
Self and Scheme programming languages. It is a multi- paradigm language, supporting object-
oriented, imperative, and functional programming styles. The application of JavaScript to use
outside of web pages—for example, in PDF documents, site-specific browsers, and desktop
widgets—is also significant. Newer and faster JavaScript VMs and platforms built upon them
(notably Node.js) have also increased the popularity of JavaScript for server-side web
applications. On the client side, JavaScript was traditionally implemented as an interpreted
language but just-in-time compilation is now performed by recent (post-2012) browsers.

 PHP- PHP is a server-side scripting language designed for web development but also
22
 used as a general-purpose programming language. PHP is now installed on more than 244
million websites and 2.1 million web servers. Originally created by Rasmus Lerdorf in
1995, the reference implementation of PHP is now produced by The PHP Group. While
PHP originally stood for Personal Home Page, it now stands for PHP: Hypertext
Preprocessor, a recursive backronym.PHP code is interpreted by a web server with a PHP
processor module, which generates the resulting web page: PHP commands can be
embedded directly into an HTML source document rather than calling an external file to
process data. It has also evolved to include a command-line interface capability and can
be used in standalone graphical applications. PHP is free software released under the PHP
License. PHP can be deployed on most web servers and also as a standalone shell on almost every
operating system and platform, free of charge.

 BACK END- The back end is designed using mysql which is used to design the databases

 MYSQL- MySQL ("My S-Q-L", officially, but also called "My Sequel") is (as of July
2013) the world's second most widely used open-source relational database
management system (RDBMS). It is named after co-founder Michael Widenius
daughter, My. The SQL phrase stands for Structured Query Language. The MySQL
development project has made its source code available under the terms of the GNU
General Public License, as well as under a variety of proprietary agreements. MySQL
was owned and sponsored by a single for- profit firm, the Swedish company MySQL
AB, now owned by Oracle Corporation

o .MySQL is a popular choice of database for use in web applications, and is a central
component of the widely used LAMP open source web application software stack (and
other 'AMP' stacks). LAMP is an acronym for "Linux, Apache,
o MySQL, Perl/PHP/Python." Free-software-open source projects that require a full-featured
database management system often use MySQL. For commercial use, several paid editions
are available, and offer additional functionality.

23
o Applications which use MySQL databases include: TYPO3, MODx, Joomla, WordPress,
phpBB, MyBB, Drupal and other software. MySQL is also used in many high-profile,
large-scale websites, including Wikipedia, Google (though not for searches), Facebook,
Twitter, Flickr, and YouTube

24
 6. SAMPLE SOURCE CODE
Addgroup.php:
<?php
extract($_POST);
if(isset($save))
{

$sql=mysqli_query($conn,"select * from groups where group_name='$g_name' or

registration_number='$reg_no'");
$r=mysqli_num_rows($sql);
if($r!=true)
{
mysqli_query($conn,"insert into groups
values('','$g_name','$region','$district','$division','$ward','$village','$reg_no','$activity','$category','$m
embers','$leader','$loan','$capital',now())");

$err="<div class='alert alert-success'>New Group has been added successfully!</div>";

}

else
{

$err="<div class='alert alert-danger'>This Group name or Registration number already exists

choose diff group name</div>";

}
}

?>
<script src="add_group.js"></script>

25
<h2 align="center">Add New Group</h2>
<form method="post">

<div class="row">
<div class="col-sm-4"></div>
<div class="col-sm-4"><?php echo @$err;?></div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Name</div>
<div class="col-sm-5">
<input type="text" name="g_name" pattern="[a-z A-Z]*" class="form-control"
required/></div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Registration Number</div>
<div class="col-sm-5">
<input type="text" name="reg_no" class="form-control" required/></div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Activity</div>
<div class="col-sm-5">
<select name="activity" class="form-control" required>
<option value="">---Select Activity---</option>
<option>Activity 1</option>
<option>Activity 2</option>
<option>Activity 3</option>
<option>Activity 4</option>

26
 </select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Category</div>
<div class="col-sm-5">
<select name="category" class="form-control" required>
<option value="">---Select Group Category---</option>
<option>Group of Men only </option>
<option>Group of Women only</option>
<option>Group of both Men and Women</option>
<option>Group of Youth only</option>
</select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Total Members</div>
<div class="col-sm-5">
<input type="number" pattern="[0-9]*" class="form-control" name="members" />
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Leader Name</div>
<div class="col-sm-5">
<input type="text" pattern="[a-z A-Z]*" class="form-control" name="leader" required
/>
</div>
</div>

27
 <div class="row" style="margin-top:10px">
<div class="col-sm-4">Loan Information</div>
<div class="col-sm-5">
<input type="text" class="form-control" name="loan" />
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Group Capital</div>
<div class="col-sm-5">
<input type="number" pattern="[0-9]*" class="form-control" name="capital"
required/>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Select Region</div>
<div class="col-sm-5">
<select onchange="showDistrict(this.value)" name="region" class="form-control"
required>
<option value="">---Select Region---</option>
<?php
$region=mysqli_query($conn,"select * from region");
while($reg1=mysqli_fetch_assoc($region))
{?>
<option value="<?php echo $reg1['region_id'];?>"><?php echo
$reg1['region_name'];?></option>
<?php
}

28
 ?>
</select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Select District</div>
<div class="col-sm-5">
<select name="district" onchange="showDivision(this.value)" id="district"
class="form-control" >
<option value="">---Select District---</option>
</select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Select Division</div>
<div class="col-sm-5">
<select name="division" onchange="showWard(this.value)" id="division"
class="form-control" >
<option value="">---Select Division---</option>
</select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Select Ward</div>
<div class="col-sm-5">
<select name="ward" onchange="showVillage(this.value)" id="ward" class="form-
control" >
<option value="">---Select Ward---</option>
</select>

29
 </div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4">Select Village</div>
<div class="col-sm-5">
<select name="village" id="village" class="form-control" >
<option value="">---Select Village---</option>
</select>
</div>
</div>

<div class="row" style="margin-top:10px">

<div class="col-sm-4"></div>
<div class="col-sm-4">

<input type="submit" value="Add New Group" name="save" class="btn btn-

success"/>
<input type="reset" class="btn btn-danger"/>
</div>
<div class="col-sm-4"></div>
</div>
</form>
Display_Loan.php:
<?php
$q=mysqli_query($conn,"select * from loan");
$rr=mysqli_num_rows($q);
if(!$rr)
{
echo "<h2 style='color:red'>No any Loan Records exists !!!</h2>";
echo "<a style='text-decoration:underline' href='index.php?page=add_loan'>Allot New Loan ?</a>";

30
}
else
{
?>
<script>
function Deleteloan(id)
{
if(confirm("You want to delete this Record ?"))
{
window.location.href="delete_loan_record.php?id="+id;
}
}
</script>
<h2 align="center">All Loan Details</h2>

<table class="table table-bordered table-hover table-striped">

<tr>
<form method="post" action="index.php?page=search_loan">
<td colspan="7">
<select name="seachLoan" class="form-control" required>
<option value="">Select Group</option>
<?php
$q1=mysqli_query($conn,"select * from groups");
while($r1=mysqli_fetch_assoc($q1))
{
echo "<option value='".$r1['group_id']."'>".$r1['group_name']."</option>";
}
?>
</select>
</td>
<td colspan="5">
<input type="submit" value="Search Loan" name="sub" class="btn btn-warning" />

31
 </td>
</form>
</tr>
<tr>
<td colspan="12">

<a title="Add New Loan Records" href="index.php?page=add_loan"><button

class="btn btn-success btn-sm">Add New Loan <span class="glyphicon
glyphicon-plus"></button></a>
&nbsp; &nbsp;

<a title="Print all Loan Records" href="print_loan_record.php"><button class="btn

btn-primary btn-sm">Print <span class="glyphicon glyphicon-print"></button></a>

</td>
</tr>
<Tr class="active">
<th>#</th>
<th>Group</th>
<th>Loan Source</th>
<th>Original Amount</th>
<th>Interest</th>
<th>Time(Yr)</th>
<th>Total Payment</th>
<th>EMI(Per Month)</th>
<th>Payment Schedule</th>
<th>Due Date</th>
<th>Actions</th>

</Tr>
<?php
error_reporting(1);

32
$rec_limit =10;

/* Get total number of records */

$sql = "SELECT count(loan_id) FROM loan ";

$retval = mysqli_query($conn,$sql);

if(! $retval )
{
die('Could not get data: ' . mysqli_error());
}
$row = mysqli_fetch_array($retval, MYSQL_NUM );
$rec_count = $row[0];

if( isset($_GET{'pagi'} ) ) {
$pagi = $_GET{'pagi'} + 1;
$offset = $rec_limit * $pagi ;
}else {
$pagi = 0;
$offset = 0;
}

$left_rec = $rec_count - ($pagi * $rec_limit);

$sql = "SELECT * ". "FROM loan ".
"LIMIT $offset, $rec_limit";

$retval = mysqli_query($conn, $sql);

if(! $retval )
{
die('Could not get data: ' . mysqli_error());

33
 }

$inc=1;
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{

echo "<Tr>";
echo "<td>".$inc."</td>";

$q1=mysqli_query($conn,"select * from groups where group_id='".$row['group_id']."'");

$r1=mysqli_fetch_assoc($q1);

echo "<td>".$r1['group_name']."</td>";
echo "<td>".$row['loan_come_from']."</td>";
echo "<td>".'$'.$row['loan_amount']."</td>";
echo "<td>".$row['loan_interest']."%"."</td>";
echo "<td>".$row['payment_term']." year/s"."</td>";
echo "<td>".'$'.$row['total_payment_with_intereset']."</td>";
echo "<td>".'$'.$row['emi_per_month']."</td>";
echo "<td>".$row['payment_schedule']."</td>";
echo "<td>".$row['due_date']."</td>";

?>

<Td><a href="javascript:Deleteloan('<?php echo $row['loan_id']; ?>')" style='color:Red'><span

class='glyphicon glyphicon-trash'></span></a>

34
<a href="index.php?page=update_loan_record&loan_id=<?php echo $row['loan_id']; ?>"
style='color:green'><span class='glyphicon glyphicon-edit'></span></a></td>

<?php

echo "</Tr>";
$inc++;
}

//for shoing Pagination

echo "<tr><td colspan='12'>";

if( $pagi > 0 )
{
$last = $pagi - 2;
echo "<a href = \"index.php?page=display_loan&pagi=$last\">Last 10 Records</a> |";
echo "<a href = \"index.php?page=display_loan&pagi=$pagi\">Next 10 Records</a>";

}
else if( $pagi == 0 )
{
echo "<a href = \"index.php?page=display_loan&pagi=$pagi\">Next 10 Records</a>";
}
else if( $left_rec < $rec_limit ) {
$last = $pagi - 2;
echo "<a href = \"index.php?page=display_loan&pagi=$last\">Last 10 Records</a>";
}

35
 echo "</td></tr>";
?>

</table>
<?php }?>
Print_Loan_Record.PHP
<?php
include('../connection.php');
$q=mysqli_query($conn,"select * from loan");

?>
<link rel="stylesheet" href="../css/bootstrap.min.css"/>
<table class="table table-bordered">
<tr height="30" class="info">
<th colspan="7" align="center"><center>All Loan Records</center></th>
</tr>
<Tr class="active">
<th>Sr.No</th>
<th>Group Name</th>
<th>Loan Source</th>
<th>Amount</th>
<th>Interest</th>
<th>Payment Schedule</th>
<th>Due Date</th>

</Tr>
<?php

$i=1;
while($row=mysqli_fetch_assoc($q))
{

36
echo "<Tr>";
echo "<td>".$i."</td>";

$q1=mysqli_query($conn,"select * from groups where group_id='".$row['group_id']."'");

$r1=mysqli_fetch_assoc($q1);

echo "<td>".$r1['group_name']."</td>";
echo "<td>".$row['loan_come_from']."</td>";
echo "<td>".'$'.$row['loan_amount']."</td>";
echo "<td>".$row['loan_interest'].'%'."</td>";
echo "<td>".$row['payment_schedule']."</td>";
echo "<td>".$row['due_date']."</td>";

?>

<?php

echo "</Tr>";
$i++;
}
?>

<tr>
<script>
function printpage()
{
//Get the print button and put it into a variable
var printButton = document.getElementById("printpagebutton");
//Set the print button visibility to 'hidden'
printButton.style.visibility = 'hidden';

37
 //Print the page content
window.print()
//Set the print button to 'visible' again
//[Delete this line if you want it to stay hidden after printing]
printButton.style.visibility = 'visible';
window.print();
}
</script>

<td colspan="7" align="center">

<button id="printpagebutton" class="btn btn-primary" onClick="printpage()"><span
class="glyphicon glyphicon-print"></span> &nbsp;Print</button>
</td>
</tr>

</table>
SearchLoan.php:
<?php
$search=$_POST['seachLoan'];
//echo $search;
$q=mysqli_query($conn,"select * from loan where group_id='$search'");
$rr=mysqli_num_rows($q);
if(!$rr)
{
echo "<div class='alert alert-danger'><h2>No Result Found!</h2></div>";

}
else
{
?>
<script>
function Deleteloan(id)

38
 {
if(confirm("You want to delete this Record ?"))
{
window.location.href="delete_loan_record.php?id="+id;
}
}
</script>
<h2 align="center" >Search Results</h2>

<table class="table table-bordered">

<tr>
<td colspan="9"><a href="index.php?page=display_loan">Go Back </a></td>
</tr>
<Tr class="active">
<th>#</th>
<th>Name</th>
<th>Loan Source</th>
<th>Amount</th>
<th>Interest</th>
<th>Payment Schedule</th>
<th>Due Date</th>
<th>Actions</th>
</Tr>
<?php

$i=1;
while($row=mysqli_fetch_assoc($q))
{

echo "<Tr>";

39
echo "<td>".$i."</td>";

$q1=mysqli_query($conn,"select * from groups where group_id='".$row['group_id']."'");

$r1=mysqli_fetch_assoc($q1);

echo "<td>".$r1['group_name']."</td>";
echo "<td>".$row['loan_come_from']."</td>";
echo "<td>".'$'.$row['loan_amount']."</td>";
echo "<td>".$row['loan_interest'].'%'."</td>";
echo "<td>".$row['payment_schedule']."</td>";
echo "<td>".$row['due_date']."</td>";

?>

<Td><a href="javascript:Deleteloan('<?php echo $row['loan_id']; ?>')" style='color:Red'><span

class='glyphicon glyphicon-trash'></span></a>
<a href="index.php?page=update_loan_record&loan_id=<?php echo $row['loan_id']; ?>"
style='color:green'><span class='glyphicon glyphicon-edit'></span></a></td>
<?php

echo "</Tr>";
$i++;
}
?>

</table>
<?php }?>

40
 7. TESTING
The purpose of testing is to discover errors. Testing is the process of trying to discover every
conceivable fault or weakness in a work product. It provides a way to check the functionality of
components, sub assemblies, assemblies and/or a finished product It is the process of exercising
software with the intent of ensuring that the Software system meets its requirements and user
expectations and does not fail in an unacceptable manner. There are various types of test. Each test
type addresses a specific testing requirement
7.1. UNIT TESTING
Unit testing involves the design of test cases that validate that the internal program logic
is functioning properly, and that program inputs produce valid outputs. All decision branches
and internal code flow should be validated. It is the testing of individual software units of the
application .it is done after the completion of an individual unit before integration. This is a
structural testing, that relies on knowledge of its construction and is invasive. Unit tests
perform basic tests at component level and test a specific business process, application, and/or
system configuration. Unit tests ensure that each unique path of a business process performs
accurately to the documented specifications and contains clearly defined inputs and expected
results.
Test strategy and approach
Field testing will be performed manually and functional tests will be written in detail.
Test objectives
 All field entries must work properly.
 Pages must be activated from the identified link.
 The entry screen, messages and responses must not be delayed.
Features to be tested
 Verify that the entries are of the correct format
 No duplicate entries should be allowed
 All links should take the user to the correct page.

7.2 INTEGRATION TESTING

41
 Integration tests are designed to test integrated software components to determine if they
actually run as one program. Testing is event driven and is more concerned with the basic
outcome of screens or fields. Integration tests demonstrate that although the components
were individually satisfaction, as shown by successfully unit testing, the combination of
components is correct and consistent. Integration testing is specifically aimed at exposing
the problems that arise from the combination of components.
Test Results: All the test cases mentioned above passed successfully. No defects
encountered.

7.3 FUNCTIONAL TEST

Functional tests provide systematic demonstrations that functions tested are available
as specified by the business and technical requirements, system documentation, and user
manuals.
Functional testing is centered on the following items:
Valid Input : identified classes of valid input must be accepted.
Invalid Input : identified classes of invalid input must be rejected.
Functions : identified functions must be exercised.
Output : identified classes of application outputs must be exercised.
Systems/Procedures: interfacing systems or procedures must be invoked.
Organization and preparation of functional tests is focused on requirements, key
functions, or special test cases. In addition, systematic coverage pertaining to identify
Business process flows; data fields, predefined processes, and successive processes must be
considered for testing. Before functional testing is complete, additional tests are identified
and the effective value of current tests is determined.

7.4 WHITE BOX TESTING

White Box Testing is a testing in which in which the software tester has knowledge of the inner
workings, structure and language of the software, or at least its purpose. It is purpose. It is used to
test areas that cannot be reached from a black box level.

42
7.5 BLACK BOX TESTING
Black Box Testing is testing the software without any knowledge of the inner
workings, structure or language of the module being tested. Black box tests, as most other
kinds of tests, must be written from a definitive source document, such as specification or
requirements document, such as specification or requirements document. It is a testing in
which the software under test is treated, as a black box .you cannot “see” into it. The test
provides inputs and responds to outputs without considering how the software works.

43
8.SCREEN LAYOUTS

44
 9.CONCLUSION

Ultimately, in the loan management system, the result of all diligence in a solid loan management
system is here. is software that helps the user to find out about various banks and their branches
easily. This software reduces the amount of manual data import and provides more performance. Its
system is very friendly and can easily be used by anyone. It also reduces the amount of time it takes
to document customer information and other modules. Finally, we can say that this software
performs all the tasks correctly and performs the task.

45
 10. BIBLIOGRAPHY
REFERENCES
 http://www.w3schools.com/html/html_intro.asp
 http://www.w3schools.com/css/css_background.asp
 http://www.w3schools.com/js/js_datatypes.asp
 http://www.w3schools.com/sql/sql_insert.asp
 http://www.w3schools.com/sql/sql_update.asp
 http://www.w3schools.com/php/php_forms.asp
 Fundamentals of software engineering by Rajib mall, PHIlearning
 Web development and application development by Ivan Byross BPB publications

46