Gas/Petrol Station Management System in PHP and SQLite Free Source Code

Language

This is a Simple PHP Project entitled Gas/Petrol Station Management System. This is a web-based application that provides the Gas or Petrol Station with an automated platform to manage their sales, customer credits, and customer payments. The application was developed using PHP and SQLite3 Database. This can help the management to store their records and easily retrieve the data. This has a simple 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
  • and more...

About the Gas/Petrol Station Management System

This Gas/Petrol Station Management System has 2 types of system users which are the Admin and the Cashier. The Admin User is in charge of managing the important list in the system such as the petrol type and customer list. They are only the ones who can view, edit, or manage the customer credit, and payment details. The cashier user can only access the point of sale feature and can generate sales reports that he/she processed on the system. The POS feature has some functionalities that can help the management to calculate the customer transaction. This project generates a printable date-wise sales report and receipt.

Project Features

Admin Side

  • Secure Login/Logout
  • Home Page
  • Customer List (CRUD)
  • POS or Point Of Sales
  • View Customer Debts and Payment List
  • Add New Customer Payment
  • Generate Printable Receipt
  • Generate Printable Date-wise Sales Report
  • Manage Petrol Type List (CRUD)
  • Manage User List (CRUD)
  • Manage Account Credentials

Cashier-Side

  • Secure Login/Logout
  • Home Page
  • POS or Point Of Sales
  • Generate Printable Receipt
  • Generate Printable Date-wise Sales Report processed by her/him
  • Manage Account Credentials

Some of the System Snapshots

Customer Details

Gas/Petrol Station Management System

POS

Gas/Petrol Station Management System

Customer Balance Details Modal

Gas/Petrol Station Management System

Sales Report

Gas/Petrol Station Management System

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. Then, 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 Gas/Petrol Station Management System in a browser. i.e. http://localhost/psms/.

Default Admin Access

Username: admin
Password: admin123

DEMO VIDEO

That's it! You can now explore the features and functionalities of this Gas/Petrol Station 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 byNox (not verified)on Sun, 11/21/2021 - 20:45

Dear oretnom23, While testing for bugs in your application, I found a critical vulnerability in your application. I would like to request a CVE for this. Kind regards, Nox P.S: Feel free to contact me on Discord Nox#2603
Submitted byronLEBRONmike (not verified)on Thu, 07/07/2022 - 20:08

hey there, good day, when i click the manage account, this will be shown Warning: Undefined array key "admin_id" in C:\xampp\htdocs\psms\manage_account.php on line 3 Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: admin_list in C:\xampp\htdocs\psms\manage_account.php on line 3 Fatal error: Uncaught Error: Call to a member function fetchArray() on bool in C:\xampp\htdocs\psms\manage_account.php:4 Stack trace: #0 C:\xampp\htdocs\psms\index.php(193): include() #1 {main} thrown in C:\xampp\htdocs\psms\manage_account.php on line 4 CAN YOU HELP HOW TO FIX THIS PLEASE, THANK YOU
Submitted byronLEBRONmike (not verified)on Thu, 07/07/2022 - 20:10

Warning: Undefined array key "admin_id" in C:\xampp\htdocs\psms\manage_account.php on line 3 Warning: SQLite3::query(): Unable to prepare statement: 1, no such table: admin_list in C:\xampp\htdocs\psms\manage_account.php on line 3 Fatal error: Uncaught Error: Call to a member function fetchArray() on bool in C:\xampp\htdocs\psms\manage_account.php:4 Stack trace: #0 C:\xampp\htdocs\psms\index.php(193): include() #1 {main} thrown in C:\xampp\htdocs\psms\manage_account.php on line 4 this is shown when i click the manage accoutn,, can you help me fix this please,, thank you very much
Submitted byHernan Serrano (not verified)on Fri, 11/18/2022 - 02:35

Class DBConnection extends SQLite3 That class does not exist. SQLite3
Submitted byIntazul hoque (not verified)on Sat, 01/07/2023 - 23:01

Er diagram
Submitted bykhasharon Tue, 01/10/2023 - 20:20

hi dear h r u? this a very good code....but it will be more good if u can add the petrol stock option also....as if it is not recording any stock in liters available at station. Its currently only generating only invoices manually.

 

Thanks & Regards,

Khawja Shams

Add new comment