Chanchal Final Report

A
PROJECT REPORT
ON
“ELECTRICITY BILL PAYMENT SYSTEM”

Submitted To
Sant Gadge Baba Amravati University, Amravati

In Partial Fulfillment of the Requirement of
Master of Science in Computer Science Part-II Semester-IV

Examination Academic Year 2019-2020
Submitted By
Ku. Chanchal D. Rangari
Guided By
Prof. Atul K. Shingarwade
COLLEGE OF MANAGEMENT AND COMPUTER

SCIENCE, YAVATMAL
2019-2020
COLLEGE OF MANAGEMENT AND COMPUTER
SCIENCE, YAVATMAL
Department of Computer Science
Certificate
This is to certify that the project report entitled
“electricity bill payment system”
is completed by Ku. Chanchal D. Rangari in satisfactory manner as a partial

fulfillment for the completion of Master of Science in Computer Science Part-II
Semester-IV in Sant Gadge Baba Amravati University, Amravati and College of
Management & Computer Science, Yavatmal-445001, during academic Year 2019-
2020.
Prof. Atul K. Shingarwade Prof. Atul K. Shingarwade
HOD Project Guide
CMCS, Yavatmal CMCS, Yavatmal
Signature of External Signature of Internal
Date: - / /2020
Place: - Yavatmal
Acknowledgement
On the completion of this project, I wish to gratefully acknowledge, by
taking this opportunity to express my sincere gratitude to Prof. Atul K. Shingarwade,
Head of Department of Master of Computer Science, for giving me kind support and
incomparable guidance. Also, thanks to our Principal Mr. Ritesh D. Chandak for
providing their computer resources and their cooperation.
I also wish to thank Prof. Atul K. Shingarwade (Project Guide), for his
guidance and useful suggestions that proved very useful in this project. Once again
thanks to all the people who have directly or indirectly helped me in this project.
Lastly, I am sincerely thankful to all my friends who have always given their
encouraging support and been a great help all the time at various stages of
development of this project.
Ku. Chanchal D. Rangari
M.Sc. Comp. Sci. Part II SEM IV

Declaration
TO,
The Principal,
College of Management and Computer
Science, Yavatmal 445001
Respected Sir,
I hereby declare that the project “Electricity Bill Payment System” has been
submitted by “Ku. Chanchal D. Rangari” in partial fulfillment for the requirement of
degree of Master of Science in Computer Science for the academic session 2019-
2020 is accomplished by me and submitted in original to Sant Gadge Baba Amravati
University, Amravati.
All the above information is correct to the best of my knowledge.
Sign : - ________________
Name : - Ku. Chanchal D. Rangari
Class : - M.Sc. Comp. Sci. Part II Sem IV
Date :- / /2020
Place : - Yavatmal
INDEX
Sr. No Contents Page No

I List of Figures
II List Of Table
III Abstract I
IV Synopsis II
1 Introduction 2
1.1 System Study 2
1.1.1 Purpose of the system 2
1.1.2 Scope of Project 3
1.2 System Analysis 4
1.2.1 Existing System 4
1.2.2 Purposed system 4
1.2.3 Project Definition 4
1.2.4 Requirement Specification 5
1.2.5 Front End, Back End and Server 6
2 System Design 9
2.1 Use Case Diagram 11
2.2 DFD 12
2.3 ER Diagram 16
2.4 Database Design 19
2.5 Module Description 20
2.6 Output Forms 21
3 Implementation 26
4 Result and Analysis 65
5 Conclusion 67
5.1 Limitation 67
5.2 Future Scope 68
6 Bibliography& References 70
7.1 References 70
7.2 Bibliography 70
LIST OF FIGURES
Sr. No. Name Of Figure Page No.
2.1 SDLC Phases 09
2.1.1 Use Case Diagram for Login 11
2.1.2 Use Case Diagram for Registration 11
2.2.1 0 Level DFD 14
2.2.2 1 Level DFD 15
2.3.1 ER diagram 18
LIST OF TABLES
Sr. No. Name Of Table Page No.
2.4.1 Admin Table 19
2.4.2 Bank Table 19
2.4.3 Bill Table 19
2.4.4 Card Table 19
2.4.5 Customer Table 20

ABSTRACT
ABSTRACT
Our project entitled “Electricity Billing System” aims is to generate electricity

bill with all the charges and penalty. Manual system that is employed is extremely
laborious and quite inadequate. It only makes the process more difficult and harder.
The aim of our project is to develop a system that is meant to partially

computerize the work performed in the Electricity Board like generating monthly
electricity bill, record of consuming unit of energy, store record of the customer and
previous unpaid record.
We used PHP as front end and MySQL as back end for developing our
project. PHP is primarily a visual design environment. We can create a PHP
application by designing the form and that make up the user interface. Adding PHP
application code to the form and the objects such as buttons and text boxes on them
and adding any required support code in additional modular.
MySQL is a powerful relational database application with which a desktop

user can efficiently create and manipulate database systems. Access targets the
desktop category and works best for individuals and workgroup
Managing megabytes of data for multi-user access to the same database,

Access uses file-server architecture, rather than client-server architecture.
SYNOPSIS
SYNOPSIS
PROJECT TITLE
ELECTRICITY BILL PAYMENT

SYSTEM
Sant Gadge Baba Amravati University, Amravati
COLLEGE OF MANAGEMENT
AND COMPUTER SICNECE, YAVATMAL
SUBMITTED BY:
Ku. Chanchal Diliprao Rangari
MSC II
2019-2020
SYNOPSIS
PROJECT TITLE
ELECTRICITY BILL PAYMENT
SYSTEM
PROJECT MEMBER: KU. CHANCHAL D. RANGARI
PROJECT GUIDE: PROF. ATUL K. SHINGARWADE
INTRODUCTION:
The project is a web-based application where users can get instant electricity
bill and pay them online via credit card. The system automates the conventional
process of paying electricity bill by visiting the place.
The system would be having two logins admin and user login. Admin can
view user account details and can even add or updates things in their account. Admin
has to feed the system with electricity usage data into respective users account. The
system then calculates the electricity bill for every user and updates the information
into their account every month. User can then view their electricity bill and pay on the
spot before month end. If user is incapable of paying the bill before month end, it then
calculates fine for each subsequent day.
PROJECT OBJECTIVES:
The specific objectives of the project include:

 Reviewing the existing/current voting process or approach in Kenya;
 Coming up with an automated voting system in Kenya;
 Implementing a an automated/online voting system;
 Validating the system to ensure that only legible voters are allowed to vote.
SCOPE OF THE PROJECT:
Our project aims at Business process automation, i.e. we have tried computerize
various processes of Electricity Billing System. In sector of electricity board, we have
computerized their department a stock maintenance.
Scope of any software depends upon the following things:
1. It satisfy the user requirement
2. Be easy to understand by the user and operator
3. Be easy to operate
4. Have a good user interface
5. Be expandable
6. Delivered on schedule within the budget.
LIMITATIONS:
 The system excludes the need of maintaining paper electricity bill as all the
electricity bill records are managed electronically.
 Administrator doesn’t have to keep a manual track of the users. The system
automatically calculates fine
 The system excludes manual bill calculation.
 Users don’t have visit the office for bill payment.
 There is no need of delivery boy for delivering bills to user’s place.
 Thus, it saves human efforts and resources.
EXISTING SYSTEM:
Science and technology with all its fascinating advancements has been taking
human life standards to the next level. The whole world will be literally jammed
without these innovations. This project is an innovation, which makes the way of
paying electricity bill simple compared to other existing projects.
The purpose of the project is to build an application program to reduce the

manual work for managing the number of units consumed by the customers and
generating the electricity bill according to the type of customer – individual or
commercial. It displays the details of the customers, units consumed by them and bill
history. It enables them pay their bill if not paid. The date of payment will be updated
while paying the bill. It maintains error free database and easily incorporates the
future developments and changes.
PROPOSED SYSTEM:
Our project entitled “Electricity Billing System” aims is to gener electricity

bill with all the charges and penalty. Manual system that employed is extremely
The aim of our project is to develop a system that is mean partially computerize the
work performed in the Electricity Board l generating monthly electricity bill, record
of consuming unit of enter store record of the customer and previous unpaid record.
database, Access uses file-server architecture, rather than client-server architecture.
Front End: PHP: Hypertext Pre-processor (PHP) is a technology that allows software
developers to create dynamically generated web pages, in HTML, XML, or other
document types, as per client request. PHP is open source software.
Back End: MySQL: MySQL is a database, widely used for accessing querying,
updating, and managing data in databases.
Software Configuration:
DATABASE : MY SQL
SERVER : WAMP SERVER
FRONT END TOOL : PHP
Hardware Configuration:
RAM : 128MB
HARD DISK : MINIMUM 20 GB
PROJECT MODULES:
Our system has only two main interfaces. One is for the admin and the other
one is for the user, the here user can be a customer or an employee.
CHANCHAL D. RANGARI ELECTRICITY BILL PAYMENT SYSTEM
CHAPTER 1
INTRODUCTION
CMCS, Yavatmal (2019-20) 1

CHAPTER 1
INTRODUCTION
The project is a web-based application where users can get instant electricity
bill and pay them online via credit card. The system automates the conventional
process of paying electricity bill by visiting the place.
The system would be having two logins admin and user login. Admin can
view user account details and can even add or updates things in their account. Admin
has to feed the system with electricity usage data into respective user’s account. The
system then calculates the electricity bill for every user and updates the information
into their account every month. User can then view their electricity bill and pay on the
spot before month end. If user is incapable of paying the bill before month end, it then
calculates fine for each subsequent day.
1.1 SYSTEM STUDY
System analysis will be performed to determine if it is feasible to design

information based on policies and plans of the organization and on user requirements
and to eliminate the weaknesses of the present system.
 The new system should be cost effective.

 To augment management, improve productivity and services.
 To enhance user / system interface.
 To improve information, qualify and usability.
 To upgrade systems reliability, availability, flexibility and growth potential.
1. 1. 1 Purpose of the System
The main objective of the Electricity Billing System is to manage the details of
Electricity, Bill, Connections, Store Record, Customer. It manages all the information
about Electricity, Electricity Board, Customer, Electricity. The project is totally built
at administrative end and thus only the administrator is guaranteed the access. The

purpose of the project is to build an application program to reduce the manual work
for managing the Electricity, Bill, Electricity Board, Connections. It tracks all the
details about the Connections, Store Record, Customer
1. 1. 2 Project Scope
Our project aims at Business process automation, i.e. we have tried computerize
various processes of Electricity Billing System. In sector of electricity board, we have
computerized their department a stock maintenance.
Scope of any software depends upon the following things:
1. It satisfy the user requirement
2. Be easy to understand by the user and operator
3. Be easy to operate
4. Have a good user interface
5. Be expandable
6. Delivered on schedule within the budget.

1. 2 SYSTEM ANALYSIS
1. 2. 1 Existing System
Science and technology with all its fascinating advancements has been taking
human life standards to the next level. The whole world will be literally jammed
without these innovations. This project is an innovation, which makes the way of
paying electricity bill simple compared to other existing projects.
The purpose of the project is to build an application program to reduce the

manual work for managing the number of units consumed by the customers and
generating the electricity bill according to the type of customer – individual or
commercial. It displays the details of the customers, units consumed by them and bill
history. It enables them pay their bill if not paid. The date of payment will be updated
while paying the bill. It maintains error free database and easily incorporates the
future developments and changes.
1. 2. 2 Proposed System
Our project entitled “Electricity Billing System” aims is to gener electricity

bill with all the charges and penalty. Manual system that employed is extremely
The aim of our project is to develop a system that is mean partially computerize the
work performed in the Electricity Board l generating monthly electricity bill, record
of consuming unit of enter store record of the customer and previous unpaid record.
database, Access uses file-server architecture, rather than client-server architecture
1.2.3 Project definition
Nowadays, the monitoring of electricity is still required the human to record

the meter value from the house customers have to receive the electricity bill then able
to make payment without knowing the accuracy of power used by the house owner.
The value of meter may not be very accurate as the meter value is entered by human
and sometimes human may make mistakes when entering the meter value. This leads

to the serious problem when the workers have to go to the house again and re-enter
the meter value in order to correct it. Furthermore, it is difficult to keep track the
customer’s value of meter and calculates the usage of power for large resident area.
Besides, the customer cannot keep track of the usage of the power consumption
hourly and cannot plan on the power consumption. It is also difficult to manage the
price of customer’s power used in meter without centralized server.
1.2.4. Requirement Specification
The successful running of any project primarily depends upon hardware and
software used in its compilation. The hardware used in the machines should be such
that it supports the software that is to be mounted for assembling the project. This
project deals with hardware and software, which is available readily and easy on each
and every machine given to the user.
Hardware Requirements
 Processor : Intel Pentium-IV or more
 Random Access Memory : 1 GB or more
 Hard Disk : 50 GB
Software Requirements
 Front-End : PHP
 Back End : MY SQL
 Operating System : Windows 8
 XAMPP/WAMPP Server: XAMPP stands for Cross-Platform(X), Apache

(A), MySQL (M), PHP (P) and Perl (P). It is a simple, Lightweight Apache
distribution that makes it extremely easy for developers to create a local web
server for testing purpose. Everything you need to set up a web server-server
application (Apache), database (MySQL) and scripting language (PHP)

1.2.5 Introduction of Front-end, Back-end and Server
Frontend- PHP
What is PHP?
 PHP is an acronym for "PHP: Hypertext Preprocessor"
 PHP is a widely-used, open source scripting language
 PHP scripts are executed on the server
 PHP is free to download and use
 PHP is an amazing and popular language!
 It is powerful enough to be at the core of the biggest blogging system on the
web (WordPress)!
 It is deep enough to run the largest social network (Facebook)!
 It is also easy enough to be a beginner's first server side language!
What is a PHP File?

 PHP files can contain text, HTML, CSS, JavaScript, and PHP code
 PHP code is executed on the server, and the result is returned to the browser as
plain HTML
 PHP files have extension ".php"
What Can PHP Do?

 PHP can generate dynamic page content
 PHP can create, open, read, write, delete, and close files on the server
 PHP can collect form data
 PHP can send and receive cookies
 PHP can add, delete, modify data in your database
 PHP can be used to control user-access
 PHP can encrypt data
With PHP you are not limited to output HTML. You can output images, PDF files,
and even Flash movies. You can also output any text, such as XHTML and XML.
Why PHP?
 PHP runs on various platforms (Windows, Linux, Unix, Mac OS X, etc.)

 PHP is compatible with almost all servers used today (Apache, IIS, etc.)
 PHP supports a wide range of databases
 PHP is free. Download it from the official PHP resource: www.php.net
 PHP is easy to learn and runs efficiently on the server side
Backend-MySql
MySQL is a fast, easy-to-use RDBMS being used for many small and big
businesses. MySQL is developed, marketed and supported by MySQL AB, which is a
Swedish company. MySQL is becoming so popular because of many good reasons −
 MySQL is released under an open-source license. So you have nothing to pay

to use it.
 MySQL is a very powerful program in its own right. It handles a large subset
of the functionality of the most expensive and powerful database packages.
 MySQL uses a standard form of the well-known SQL data language.
 MySQL works on many operating systems and with many languages including
PHP, PERL, C, C++, JAVA, etc.
 MySQL works very quickly and works well even with large data sets.
 MySQL is very friendly to PHP, the most appreciated language for web
development.
 MySQL supports large databases, up to 50 million rows or more in a table.

The default file size limit for a table is 4GB, but you can increase this (if your
operating system can handle it) to a theoretical limit of 8 million terabytes
(TB).
 MySQL is customizable. The open-source GPL license allows programmers to

modify the MySQL software to fit their own specific environments.

CHAPTER 2
DESIGN

CHAPTER 2
DESIGN
SYSTEM DEVELOPMENT LIFE CYCLE
Systems Development Life Cycle (SDLC) is the most common process

adopted to develop a project and not surprisingly, this project is following this model
too. To be precise, waterfall model is being applied. Waterfall model is a sequential
model process where the input of a phase actually results from the previous phase.
Figure 2. 1: “SDLC Phases”
There are five phases in this model and the first phase is the planning stage.
The planning stage determines the objectives of the project and whether the project
should be given the green light to proceed. This is where the proposal submission
comes into picture. After obtaining the approval, the next phase is analysis.
Gathering and analysing the system and user requirements is essential for entry to the
design step.
With the user requirements gathering completed, there is a need to prepare the
resources for the project. Be it software or hardware components, careful
consideration and selection is to be taken care at this stage. The decision on the
appropriate resources to be used is further elaborated under the subsections below.
The next step is to design the system and database structure.

Results from the analysis and preparation that were concluded from the
previous stage are put into action. With the user requirements in mind, the flow of the
system is planned and the user interface is designed to suit their easy navigation
needs. In addition, the number of tables, attributes, primary and unique keys of the
database is listed.
After completing the design, actual coding begins. Database is created and
codes are written. Some of the codes required amendments and improvement to it so
these are being developed at this fourth stage of the waterfall model. With the
development completed, testing will begin. The codes and database are tested to
ensure the results obtained are as intended. More time is spent on both development
and testing stages because it is inevitable to have errors and issues and buffer time is
allocated for troubleshooting.

2.1 Use case Diagram:
2.1.1 Login:
LOGIN
EXISTING USER ELECTRICITY BILL PAYMENT SYSTEM
Fig no 2.1.1: Use Case Diagram of Login
2.1.2 Sign up:
REGISTRATION
NEW USER
SIGN UP LOGIN
Fig no 2.1.2: Use Case Diagram for Sign Up

2. 2 DFD
The DFD takes an input-process-output view of a system i. e. data objects

flow into the software, are transformed by processing elements, and resultant data
objects flow out of the software.
Data objects represented by labeled arrows and transformation are represented

by circles also called as bubbles. DFD is presented in a hierarchical fashion i. e. the
first data flow model represents the system as a whole. Subsequent DFD refine the
context diagram (level 0 DFD), providing increasing details with each subsequent
level.
The DFD enables the software developer to develop models of the information
domain & functional domain at the same time. As the DFD is refined into greater
levels of details, the analyst performs an implicit functional decomposition of the
system. At the same time, the DFD refinement results in a corresponding refinement
of the data as it moves through the processes that embody the applications.
A context-level DFD for the system the primary external entities produce
information for use by the system and consume information generated by the system.
The labeled arrow represents data objects or object hierarchy.
RULES FOR DFD:
 Fix the scope of the system by means of constant diagrams.
 Organize the DFD so that the main sequence of the actions
 Reads left to right and top to bottom.
 Identify all inputs and outputs.
 Identify and label each process internal to the system with

Rounded circles.
 A process is required for all the data transformation and

Transfers. Therefore, never connect a data store to a data
Source or the destinations or another data store with just a Data
flow arrow.

 Do not indicate hardware and ignore control information.
 Make sure the names of the processes accurately convey

everything the process is done.
 There must not be unnamed process.
 Indicate external sources and destinations of the data, with

Squares.
 Number each occurrence of repeated external entities.
 Identify all data flows for each process step, except simple
Record retrievals.
 Label data flow on each arrow.
 Use details flow on each arrow.

2.2.1 0 Level DFD
START
LOGIN
MAIN ACTIVITY SIGN UP
LOGOUT
STOP
2.2.1 0 level DFD

2. 2. 2 1 level DFD:
A level 0 DFD, also called a fundamental system model or context diagram

represents the entire software element as a single bubble with input and output data
indicated by incoming and outgoing arrows, respectively.
Figure 2.2.2 1 level DFD

2. 3 ER-Diagram:
The Entity-Relationship (ER) model was originally proposed by Peter in 1976

as a way to unify the network and relational database views. Simply stated the ER
model is a conceptual data model that views the real world as entities and
relationships. A basic component of the model is the Entity-Relationship diagram
which is used to visually represent data objects. Since Chen wrote his paper the
model has been extended and today it is commonly used for database design For the
database designer, the utility of the ER model is:
 It maps well to the relational model. The constructs used in the ER model can
easily be transformed into relational tables.
 It is simple and easy to understand with a minimum of training. Therefore, the

model can be used by the database designer to communicate the design to the end
user.
 In addition, the model can be used as a design plan by the database developer
to implement a data model in specific database management software.
Connectivity and Cardinality

The basic types of connectivity for relations are: one-to-one, one-to-many, and
many-to-many. A one-to-one (1:1) relationship is when at most one instance of a
entity A is associated with one instance of entity B. For example, employees in the
company are each assigned their own office. For each employee there exists a unique
office and for each office there exists a unique employee.
A one-to-many (1:N) relationships is when for one instance of entity A, there

are zero, one, or many instances of entity B, but for one instance of entity B, there is
only one instance of entity A. An example of a 1: N relationships is a department
has many employees each employee is assigned to one department.

E-R Notation:
There is no standard for representing data objects in ER diagrams. Each

modeling methodology uses its own notation. The original notation used by Chen is
widely used in academics texts and journals but rarely seen in either CASE tools or
publications by non-academics. Today, there are a number of notations used, among
the more common are Bachman, crow's foot, and IDEFIX.
All notational styles represent entities as rectangular boxes and relationships

as lines connecting boxes. Each style uses a special set of symbols to represent the
cardinality of a connection.
The notation used in this document is from Martin. The symbols used for the
basic ER constructs are:
 Entities are represented by labeled rectangles. The label is the name of the
entity. Entity names should be singular nouns.
 Relationships are represented by a solid line connecting two entities. The name
of the relationship is written above the line. Relationship names should be verbs
 Attributes, when included, are listed inside the entity rectangle. Attributes
which are identifiers are underlined. Attribute names should be singular nouns.
 Cardinality of many is represented by a line ending in a crow's foot. If the

crow's foot is omitted, the cardinality is one.

2.3.1 E-R-Diagram
Figure 2.3.1 ER Diagram

2. 4 DATABASE DESIGN
2. 4. 1 Admin Table
Column Type Null

ad_id int(9) No
ad_username varchar(200) No
ad_password varchar(200) No
Table: 2. 4. 1 Admin Table
2. 4. 2 Bank Table
Column Type Null

b_id int(9) No
bnk_name varchar(200) No
2. 4. 2 Bank Table
2. 4. 3 Bill Table
Column Type Null

amt_id int(9) No
cus_id int(200) No
billno varchar(200) No
amount varchar(200) No
date varchar(200) No
payment varchar(200) No
2. 4. 3 Bill Table
2. 4. 4 Card Table
Column Type Null

c_id int(9) No
card_name varchar(200) No
2. 4. 4 Card Table

2. 4. 5 Customer Table
Column Type Null

cus_id int(9) No
name varchar(200) No
address varchar(200) No
houseno varchar(200) No
phone varchar(200) No
email varchar(200) No
2. 4. 2 Customer Table
2.5 Module Description
Our system has only two main interfaces. One is for the admin and the other
one is for the user, the here user can be a customer or an employee.

2.6 OUTPUT FORMS
Login Page
This is login Page.
Details Page
This is user details page.

Pay Page
This page is payment page.
Payment Redirected Page
This page redirects to the payment gateway.

Payment Main Page
This page allows the payment.
Card Details
This page is card details page.

Payment Successful
Payment Successful Page.
Logout
This is Logout Page.

CHAPTER 3
IMPLEMENTATION

CHAPTER 3
IMPLEMENTATION
Index page
<?php
include("includes/connect.php");
?>
<html>
<head>
<title>
Electricity Bill Payment || Home
</title>
<link rel="stylesheet" href="css/style.css" type="text/css" />
<link rel="stylesheet" href="css/menustyle.css" type="text/css" />
</head>
<body>
<?php
include("includes/header.php");
?>
<div class="contain">
<div class="section">
<div class="loginpad">
<br>

<form action="" method="post">
<input type="text" name="c_id" id="txt" placeholder="Enter Your

Customer ID" required>
<br>
<br>
<input type="submit" name="btnlogin" id="btn" value="Enter">
</form>
<br>
<br>
<br>
<label>Note: Your Customer Id located with your bill.<br>Namely: CON

ID)</label><br>
</div>
</div>
</div>
<center>
<?php
include("includes/footer.php");
?>
</center>
<?php
if(isset($_POST["btnlogin"]))

function validate_input($data)
$data = trim($data);
$data = stripslashes($data);
$data = htmlspecialchars($data);
return $data;
$c_id = validate_input($_POST["c_id"]);
if($c_id =="")
echo "<script> alert('Please Fill The required

Field!');</script>";
return;
else
$sql = "SELECT * FROM custumer where cus_id='$c_id'";
$result = mysqli_query($con, $sql);
if (mysqli_num_rows($result) > 0)
session_start();
$_SESSION['log_user']=$c_id;

setcookie('user_n',$c_id,time() +
86400*30,'/');
header("location:home.php");
else
echo mysqli_error($con);
return;
?>
</body>
</html>
Home Page
<?php
session_start();
include("includes/connect.php");
if(!(isset($_SESSION['log_user'])))
header("location:check.php");

else
$user_name=$_SESSION['log_user'];
?>
<html>
<head>
<title>
Electricity Bill Payment || Home
</title>
<link rel="stylesheet" href="css/style.css" type="text/css" />
<link rel="stylesheet" href="css/menustyle.css" type="text/css" />
</head>
<body>
<?php
?>
<div class="container">
<?php
include("includes/menu.php");
?>
<div class="bd">

<br>
<table border="1" width="900" id="customers">
<tr>
<th>Name</th>
<th>Address</th>
<th>House Number</th>
<th>Phone</th>
<th>Bill No</th>
<th>Amount</th>
<th>Date</th>
<th>Pending Payment</th>
</tr>
<?php
$query1="select * from bill join custumer on bill.cus_id=custumer.cus_id

where bill.cus_id='$user_name'";
$result1=mysqli_query($con,$query1);
?>
<?php
while($rows=mysqli_fetch_array($result1))

?>
<tr>
<td><?php echo $rows['name']?></td>
<td><?php echo $rows['address']?></td>
<td><?php echo $rows['houseno']?></td>
<td><?php echo $rows['phone']?></td>
<td><?php echo $rows['billno']?></td>
<td><?php echo $rows['amount']?></td>
<td><?php echo $rows['date']?></td>
<td><?php echo $rows['payment']?></td>
</tr>
<?php
?>
</table>
</div>
</div>
<center>
<?php
?>
</center>

</body>
</html>
<?php
?>
Cancel Page
<?php
session_start();
include("connect.php");
else
?>
<html>
<head>
<title>
Meghalaya Power Payment
</title>

<meta http-equiv="refresh" content="10; url=home.php">
</head>
<body>
<center>
<h1>Maharashtra Electricity Bill Payment</h1>
<hr>
<p>
You have Cancel your paymeny<br>
Note: Do not refresh or close this page
</p>
Please wait a moment while your details is clear.
Loading...
</center>
</body>
</html>
<?php
?>

Check Page
<center>
<hr>
<p>
Sorry your are not Authorize to Access This File
</p>
<a href="index.php">Click Here</a> To Exit
</center>
Complete Page
<?php
session_start();
else
?>
<html>

<head>
<title>
Maharashtra Power Payment
</title>
</head>
<body>
<center>
<hr>
<p>
Your Payment Is Received
</p>
<a href="home.php">Click Here</a> To Go Home
</center>
</body>
</html>
<?php
?>

Connect Page
<?php
$con = mysqli_connect("localhost","root","","electribill");
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
?>
Logout Page
<center>
<hr>
<?php
session_start();
session_destroy();
setcookie("user", "", time()-3600);
echo "Your Have Been Logout <br><a href='index.php'> Click Here</a> To Exit";
?>
</center>

Pay Page
<?php
session_start();
else
?>
<html>
<head>
<title>
Electricity Bill Payment
</title>
<link rel="stylesheet" href="css/style.css"/>
<link rel="stylesheet" href="css/menustyle.css"/>
</head>
<body>
<?php

?>
<?php
?>
<div class="bd">
<center>
<input type="submit" name="btn_update" value="Pay Now" id="btn"/>
</form>
</div></div>
<center>
<?php
?>
</center>
</body>
</html>
<?php
if(isset($_POST['btn_update']))
header("location:process.php");
}}?>

Payment Page
<?php
session_start();
else
?>
<html>
<head>
<title>
Meghalaya Power Payment
</title>
<style>
body
background-color:#ccc;
#txt

width:250px;
border-style:groove;
height:30px;
border-radius:4px;
#sl
width:125px;
height:30px;
border-radius:4px;
#btn
background-color:#1e5799;
border-style:none;
width:100px;
height:30px;
border-radius:4px;
color:white;
#btn:hover{

color:#000;
.header
position:fixed;
top:0px;
background-color:#000;
width:100%;
left:0px;
color:#fff;
opacity:.8;
text-align:center;
.footer
position:fixed;
bottom:0px;
width:100%;
left:0px;
color:#fff;

.footer a
color:#fff;
.container
padding-top:120px;
table
text-align:center;
.section
background-color:#fff;
width:700px;
height:490px;
border-radius:10px;
</style>

</head>
<body>
<?php
?>
<center>
<div class="section">
<?php
$bank=$_POST["bank"];
echo "You have Choose: ".$bank."<br>";
$dt=date("m/d/Y");
$query1="select * from bill join custumer on bill.cus_id=custumer.cus_id where

payment='Not Complete'";
$result1=mysqli_query($con,$query1);
$rows=mysqli_fetch_array($result1);
echo "Name: ".$rows['name']."<br>";
echo "Bill NO: ".$rows['billno']."<br>";
echo "Amount: ".$rows['amount']."<br>";
$amount=$rows['amount'];
?>
<br>

<input type="text" name="ch" id="txt" placeholder="Card Holder"

required>
<br>
<br>
<input type="text" name="cn" id="txt" placeholder="Card Number"

required>
<br>
<br>
<input type="text" name="cvs" id="txt" placeholder="CVS" required>
<br>
<br>
<select name="card" id="txt">
<option value="">Select Your Card</option>
<?php
$sql = "SELECT * FROM card";
while($rows=mysqli_fetch_array($result))
?>
<option value="<?php echo $rows['card_name']?>"><?php echo

$rows['card_name']?></option>
<?php
?>

</select>
<br>
<label>Card Expire On</label><br>
<select name="mm" id="sl">
<option value="">Select Month</option>
<?php
for($i=1;$i<=12;$i++)
?>
<option value="<?php echo $i?>"><?php echo $i?></option>
<?php
?>
</select>
<select name="yy" id="sl">
<option value="">Select Month</option>
<?php
$dy=date("Y");
for($j=$dy;$j<=2050;$j++)
?>
<option value="<?php echo $j?>"><?php echo $j?></option>
<?php

?>
</select>
<br>
<br>
<input type="submit" name="btnpro" id="btn" value="Pay Now">
</form>
<a href="cancel.php"><input type="submit"id="btn"

value="Cancel"></a><br>
<?php
echo "Confirm Your Payment of Rs.".$amount." By clicking The Button Pay

Now<br>";
?>
</center>
</div>
</div>
<?php
if(isset($_POST["btnpro"]))
function validate_input($data)
$data = trim($data);
$data = stripslashes($data);

$data = htmlspecialchars($data);
return $data;
$ch = validate_input($_POST["ch"]);
$cn = validate_input($_POST["cn"]);
$cvs = validate_input($_POST["cvs"]);
$mm = validate_input($_POST["mm"]);
$yy = validate_input($_POST["yy"]);
$month=$mm."/".$yy;
if($ch =="" || $cn=="" || $cvs=="" || $mm=="" || $yy=="")
echo "<script> alert('Please Fill The required

Field!');</script>";
return;
else
$query="update bill set date='$dt', payment='Complete' where

cus_id='$user_name'";
if(mysqli_query($con,$query))
header("location:complete.php");

else
echo "<script> alert('Check if the field conatin special charecter

or contact administrator');</script>";
?>
<center>
<?php
?>
</center>
</body>
</html>
<?php
?>

Process Page
<?php
session_start();
else
?>
<html>
<head>
<title>
Maharashtra Power Payment
</title>
<meta http-equiv="refresh" content="10; url=schpayment.php">
</head>
<body>
<center>
<hr>

<p>
Your Will be redirect to payment<br>
Note: Do not refresh or close this page
</p>
Please wait...
</center>
</body>
</html>
<?php
?>
SchPayment
<?php
session_start();
else

?>
<html>
<head>
<title>
</title>
<style>
#txt
width:250px;
height:30px;
border-radius:4px;
#btn
border-style:none;
width:100px;
height:30px;
border-radius:4px;

color:white;
#btn:hover{
color:#000;
.header
position:fixed;
top:0px;
width:100%;
left:0px;
color:#fff;
opacity:.8;
text-align:center;
.footer
position:fixed;
bottom:0px;
width:100%;

left:0px;
color:#fff;
.footer a
color:#fff;
.container
padding-top:140px;
</style>
</head>
<body>
<center>
<?php
?>
<i>Note: Hover Over the Bank or Services Icon</i><br>
<img src="image/apex.jpg" width="80" title="Apex Bank">
<img src="image/Axis.png" width="90" title="Axis Bank">

<img src="image/Canara.png" width="100" title="Canara

Bank">
<img src="image/Citibank.png" width="90" title="Citi Bank">
<img src="image/HDFC.png" width="80" title="HDFC Bank">
<img src="image/ICICI.png" width="80" title="ICICI Bank">
<img src="image/Federal.png" width="80" title="Federal

Bank">
<img src="image/sbi.png" width="80" title="State Bank Of India

Bank">
<img src="image/union.png" width="80" title="Union Bank">
<img src="image/Yes.png" width="80" title="Yes Bank">
<hr>
<p>Onlien Payment Services Supported</p>
<a href="https://www.paypal.com"><img src="image/paypal.png" width="80"

title="Paypal Service"></a>

<a href="https://www.paytm.com"><img src="image/Paytm.png" width="80"

title="Paytm Service"></a>
<br>
<hr>
<h4>Choose Your Payment Method</h4>
<form action="payment.php" method="post">
<select name="bank" id="txt">
<option value="">Select Your bank</option>

<?php
$sql = "SELECT * FROM bank";
while($rows=mysqli_fetch_array($result))
?>
<option value="<?php echo $rows['bnk_name']?>"><?php echo

$rows['bnk_name']?></option>
<?php
?>
</select>
<input type="submit" name="ok" id="btn" value="Proceed">
</form>
<a href="cancel.php"><input type="submit"id="btn" value="Cancel"></a>
</div>
<center>
<?php
?>
</center>
</body>

</html>
<?php
?>
UserUpdate Page
<?php
session_start();
else
$slno=$_GET["Serial_no"];
$query="select * from custumer where cus_id=$slno";
$result=mysqli_query($con,$query);
$rows=mysqli_fetch_array($result);
$serial=$rows['cus_id'];
$name=$rows['name'];
$address=$rows['address'];

$house=$rows['houseno'];
$phone=$rows['phone'];
$email=$rows['email'];
?>
<html>
<head>
<title>
</title>
<link rel="stylesheet" href="css/style.css"/>
<link rel="stylesheet" href="css/menustyle.css"/>
</head>
<body>
<?php
?>
<?php
?>
<div class="bd">
<br>
<center>

<label>ID Number: <?php echo $serial;?></label><br><br>
<input type="text" name="name" placeholder="Name" id="txt" value="
<?php
echo $name;
?>
" required/>
<br><label>Address:</label><br>
<input type="text" name="ad" placeholder="Address" id="txt" value="
<?php
echo $address;
?>
" required/>
<br>
<label>House No:</label><br>
<input type="text" name="hn" placeholder="House NO" id="txt" value="
<?php
echo $house;
?>
" required/>

<br>
<label>Mobile Number:</label><br>
<input type="text" name="phone" placeholder="Mobile Number" id="txt" value="
<?php
echo $phone;
?>
" required/>
<br>
<label>Email:</label><br>
<input type="text" name="email" placeholder="Email" id="txt" value="
<?php
echo $phone;
?>
" required/>
<br> <br>
<input type="submit" name="btn_update" value="Update" id="btn"/>
</form>
<a href="home.php"><input type="submit" id="btn" value="Back"/></a>
</div></div>
</body>
</html>

<?php
if(isset($_POST['btn_update']))
$name=$_POST["name"];
$address=$_POST["ad"];
$house=$_POST["hn"];
$phone=$_POST["phone"];
$email=$_POST["email"];
if( $name=="" || $address=="" || $house=="" || $email=="" || $phone=="")
echo "<script> alert('All field required');</script>";
return;
else
$query="update custumer set name='$name', address='$address',

houseno='$house', phone='$phone', email='$email' where cus_id=$serial";
if(mysqli_query($con,$query))
echo "<script> alert('Successful');</script>";

else
echo "<script> alert('Please check the field if it contain any

special charecter or contact administrator');</script>";
?>
Header Page
<div class="header">
<p><i>"We bring light to your house"</i></p>
<hr>
</div>
Footer Page
<div class="footer">
©2020 <?php echo date("Y")?> <a rel="nofollow" target="_blank"

href="http://www.facebook.com/ChanchalRangari" title="Electricity Bill
Payment">Electricity Bill Payment</a> All Right Reserve <br>

Design and Developed By <a rel="nofollow" target="_blank"

href="http://www.facebook.com/chanchalRangarir" title="CMCS">Chanchal
Rangari</a> ||
<a href="contact.php">Contact US</a> ||
<a rel="nofollow" target="_blank"

href="http://www.facebook.com/Chanchal.Rangari" title="Maharashtra
Power">Social Media</a>
</div>
Connect Page
<?php
$con = mysqli_connect("localhost","root","","electribill");
if (!$con) {
die("Connection failed: " . mysqli_connect_error());
?>

CHAPTER 4
RSEULT AND ANALYSIS

CHAPTER 4
RESULT AND ANALYSIS
Starting the project, we should fully know about the meaning of project. There are
seven letters in the word “PROJECT”. Each character has its own technical
meaning.
P – Planning: this deals with the idea at thinking and which are required for project.
R – Resource: the money problem will be solved and resources from which collected.
O – Operating: the procedure from which getting job is prepared in a systematic way
is known as operation.
J – Joint effort: this is directly proper to a operation output is a made of several

person working sincerely is known as JOIN EFFORT.
E – Engineering: A well educated engineer can do this work in a better way to find
out better result. Hence the project is as engineer function.
C – Cooperation: To make the project successfully, it is necessary for its success and
completion of project.
T – Technique: It must as it gives a better shape. It is not possible to complete the

project without technique.
The project is a system that gives the systematic way of planning and working.
OR
It representing the temporary task, in a scientific manner carried out of engineers to

achieve a goal.

CHAPTER 5
CONCLUSION

CHAPTER 5
CONCLUSION
Even if it is always possible to improve the Electricity Billing System and

make it more user friendly, the system is ready to be used and the basic functionality
has been achieved. When the first version was released, we started a period for testing
the Electricity Billing System but we did not get too much feedback. After that, the
system went into production. The project Electricity Billing System has been
developed based on the business requirements. The project has met its objectives. The
system reliability is high and enough security has been provided. The system is very
simple in design and to implement. The new computerized system was found to be
much faster, reliable and user friendly. We have tried to develop a system that can be
a great help for the owner of the referred electricity department to receiving bill from
the customer. Despite all our efforts there are some bugs in the system, which are still
to be removed. This is possible by the testing being done in the system.
We have left all the options open so that if there is any other future
requirement in the system by the user for the enhancement of the system then it is to
implement them.
In the last we would like to thanks all the persons involved in the development
of the system directly or indirectly. We hope that the project will serve its purpose for
which it is develop there by underlining success of process.
5. 1 LIMITATIONS
 Here in the existing system the customers need to visit the organization.
 The current system is very slow in access.
 The complete current system is manual system and it will not provide any kind of
security to the data.
 Due to the scope of this project work as mention above, this project work is
limited to Complaint management System. This application cannot process the

penalties for anybody found being grieved or the punishment for any staff or
student found being at fault of any complaints. Other limitations are following:
 The application was developed to send notification to only the recipient email
address and not mobile phone
 It does not provide the means of live communication between the complaint and
the responder
 The system cannot work with other web application. This means it is not a web
service-oriented system
5. 2 FUTURE SCOPE
This system is found tested and examined for its successful processing.
Future change in the environment or processing can be easily adopted by having
simple change in coding. It is very user friendly, cost effective, feature rich and it
provides very high level of security. It protects the unauthorized users. Moreover, the
system coding is so well designed that new operations can be easily incorporated
without much modification. A facility to inform through SMS or Email on landing of
the consignment can be added in future.

CHAPTER 6
BIBLIOGRAPHY AND
REFERENCES

CHAPTER 6
BIBLIOGRAPHY
 Schlossnagle.Sams” Advanced PHP Programming” Paperback-October 2003
 Deepak Thomas,” Beginning php for database”. Wrox Press Ltd.Paperback-17
October, 2006.
 Leon Atkinson, ZeevSuraski,” Core PHP Programming”, Prentice Hall
PTRPaperback-4, August 2013.
REFERENCES
 www.W3School.com
 www.waytotutorial.com
 www.phprefernesbook.com
 www.it-ebooks.info

Chanchal Final Report

Uploaded by

Copyright:

Available Formats

Chanchal Final Report

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Chanchal Final Report

Uploaded by

Copyright:

Available Formats

A

“ELECTRICITY BILL PAYMENT SYSTEM”

Sant Gadge Baba Amravati University, Amravati

Master of Science in Computer Science Part-II Semester-IV

Ku. Chanchal D. Rangari

Prof. Atul K. Shingarwade

COLLEGE OF MANAGEMENT AND COMPUTER

“electricity bill payment system”

is completed by Ku. Chanchal D. Rangari in satisfactory manner as a partial

Prof. Atul K. Shingarwade Prof. Atul K. Shingarwade

HOD Project Guide

CMCS, Yavatmal CMCS, Yavatmal

Signature of External Signature of Internal

Ku. Chanchal D. Rangari

M.Sc. Comp. Sci. Part II SEM IV

College of Management and Computer

Science, Yavatmal 445001

All the above information is correct to the best of my knowledge.

Name : - Ku. Chanchal D. Rangari

Class : - M.Sc. Comp. Sci. Part II Sem IV

Sr. No Contents Page No

4 Result and Analysis 65

2.1 SDLC Phases 09

2.1.1 Use Case Diagram for Login 11

2.1.2 Use Case Diagram for Registration 11

2.2.1 0 Level DFD 14

2.2.2 1 Level DFD 15

2.4.1 Admin Table 19

2.4.2 Bank Table 19

2.4.3 Bill Table 19

2.4.4 Card Table 19

2.4.5 Customer Table 20

Our project entitled “Electricity Billing System” aims is to generate electricity

The aim of our project is to develop a system that is meant to partially

MySQL is a powerful relational database application with which a desktop

Managing megabytes of data for multi-user access to the same database,

ELECTRICITY BILL PAYMENT

Sant Gadge Baba Amravati University, Amravati

The specific objectives of the project include:

Scope of any software depends upon the following things:

1. It satisfy the user requirement

2. Be easy to understand by the user and operator

4. Have a good user interface

6. Delivered on schedule within the budget.

The purpose of the project is to build an application program to reduce the

Our project entitled “Electricity Billing System” aims is to gener electricity

CMCS, Yavatmal (2019-20) 1

1.1 SYSTEM STUDY

System analysis will be performed to determine if it is feasible to design

 The new system should be cost effective.

1. 1. 1 Purpose of the System

CMCS, Yavatmal (2019-20) 2

Scope of any software depends upon the following things:

1. It satisfy the user requirement

2. Be easy to understand by the user and operator

4. Have a good user interface

6. Delivered on schedule within the budget.

CMCS, Yavatmal (2019-20) 3

The purpose of the project is to build an application program to reduce the

Our project entitled “Electricity Billing System” aims is to gener electricity