Online Gas Booking System Using PHP and MySQL

Online Gas Booking System Using PHP and MySQL

Project Name               :  Online Gas Booking System Project (OGBS)

Language Used                   :  PHP

Database                              :  MySQL

User Interface Design       :  HTML, AJAX,JQUERY,JAVASCRIPT

Web Browser                       :  Mozilla, Google Chrome, IE8, OPERA

Software                               :  XAMPP / Wamp / Mamp/ Lamp (anyone)

In this project, we use PHP
and  MySQL database. It has two
modules

1. Customer

2. Admin

Customer
Module:
Customer first fill the signup form then login into their
panel and do the following activities

  • Dashboard: This is the Welcome page for the customer.
  • New Connection: In this section, customer sends the request for LPG connection to the organization
  • Book Cylinder: When the organization provides a connection number then the customer can book his/her cylinder.
  • Booking History: In this section, customer can view the history of gas booking.
  • Search: In this section, customer can search gas booking records by entering the booking number.
  • The customer can also update his profile, change the password and recover the password. 

Admin Module

  • Admin is the superuser of the website who can manage everything on the website. Admin can log in through the login page
  • Dashboard: In this section, admin can see all detail in brief like the total new connection, total new connection, total on-hold connection, total approved connection, total rejected connection, total new booking, total confirmed booking, total canceled booking, total assign booking, total delivered LPG, total staff and total registered users
  • Delivery Staff: In this section, admin can manage staff (add/update).
  • Reg Users: In this section, admin can view the detail of registered users.
  • Connection: In this section, admin can view the connection request admin also has the right to change connection status according to the current status and add his/her remarks.
  • Booking: In this section, admin can view booking request and assign to delivery staff or cancel the booking.
  • Assigned Booking: In this section, admin can change the status of booking according to the current status and add his/her remarks.
  • Reports: In this section, admin can view booking and connection requests in a particular period.
  • Search: In this section, admin can search booking and connection details with the help of booking number and connection number respectively.
  • Admin can also update his profile, change the password and recover the password.

Some Project Screenshots

Home Page
Customer and User Signup Page
Admin Dashboard
Connection Details Page

How to run the Online Gas Booking System Using PHP and MySQL

1.Download the zip file
2.Extract the file and copy ogbs folder
3.Paste inside root directory(for xampp xampp/htdocs, for wamp wamp/www, for lamp var/www/html)
4.Open PHPMyAdmin (http://localhost/phpmyadmin)
5.Create a database with name ogbsdb
6.Import ogbsdb.sql file(given inside the zip package in SQL file folder)
7.Run the script http://localhost/ogbs (frontend)
Credential for admin panel :
Username: admin
Password: Test@123

Credential for customer/user panel :
Username: testuser@gmail.com
Password: Test@123

View Demo————————————————

View Demo

Project Download Link

View Demo