Electric Billing Management System in PHP and SQLite Free Source Code

Language

Introduction

This is a PHP Project entitled Electric Billing Management System. This project is a simple web application that manages the electric provider company's client's bills. This application help to ease to record, manage, and retrieve the said industry's clients' billing data. This also provides their clients an online platform where they can track their billing history. It has a simple/pleasant user interface and user-friendly functionalities.

I developed this project using the following:

  • XAMPP v3.3.0 as my local webserver that has a PHP Version 8.0.7
  • PHP Language
  • SQLite Database
  • HTML
  • CSS
  • JavaScript
  • jQuery
  • Ajax
  • Bootstrap
  • Summernote
  • and more...

About the Electric Billing Management System

This application contains 2 modules which are the Admin Module and the Simple Public Module. The project stores the list of clients, connections, billings, and etc. In this project, the management can create multiple electric connections data for a single client. Each connection has a unique connection code which serves as the connection identification for easy retrieval of the data for a specific connection. The Admin side can be managed by 2 types of users which are the Administrator and Staff. The Administrator can manage all the functionalities and features that the module does while the staff has only limited access.

Project Features

Admin Panel

  • Secure Login/Logout
  • Home Page
  • Manage Client List (CRUD)
  • Manage Client's Connection List (CRUD)
  • Manage Electric Billing List (CRUD)
  • View Client's Data in a Modal with Connection and Billing List
  • Manage User List (CRUD)
  • Manage Website Information
  • Manage Account Credentials

Public Side

  • Home Page
  • Display Welcome Content
  • Display About the Company Content
  • Track/Display Client's Connection Data and Billing History

Some of the System Snapshots

Public Home Page

Electric Billing Management System

Client's Connection's Billing History (Public-Side)

Electric Billing Management System

Admin Panel

Electric Billing Management System

Client's Data Modal (Admin/Staff-Side)

Electric Billing Management System

The project source code is free to download on this website. Feel Free to download and modify the source code the way you wanter. Follow the instruction below to run this project.

How to Run ??

Requirements

  • Download and Install any local web server such as XAMPP/WAMP.
  • Download the provided source code zip file. (download button is located below)

Installation/Setup

  1. Open your XAMPP/WAMP's php.ini file and uncomment the sqlite3 and save the file.
  2. Open your XAMPP/WAMP's Control Panel and start Apache.
  3. Extract the downloaded source code zip file.
  4. If you are using XAMPP, copy the extracted source code folder and paste it into the XAMPP's "htdocs" directory. And If you are using WAMP, paste it into the "www" directory.
  5. Browse the Electric Billing Management System in a browser. i.e. http://localhost/electric_billing/.

Default Admin Access

Username: admin
Password: admin123

You can also create a new user at the admin side using an Administrator System user.

Sample Client's Connection Code

Code: 301370819282

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Electric Billing Management System project in PHP and SQLite Database. I hope this will help you with what you are looking for and you'll find something useful for your future PHP Projects.

Explore more on this website for more Free Source Codes and Tutorials.

Enjoy :)

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Comments

Submitted byjisooooooo (not verified)on Mon, 12/27/2021 - 13:20

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'import sqlite3 ' at line 1 Hi. How to fix this? Thank you
Submitted bySql (not verified)on Mon, 06/06/2022 - 03:05

Hi can i ask how can host a website like this if its using sqlite database
Submitted byshmcnls (not verified)on Sun, 02/25/2024 - 15:01

I cannot add connection. what might be the problem

Add new comment