Online Gas Booking System Using PHP and MySQL

Description

1. Default Login Details

Role / PageUsername / EmailPassword
Admin  (/admin/)admin@example.comPassword
Delivery Staff  (/delivery/)delivery@example.compassword
User  (/user/)ramji@gmail.comRam123

2. Database Design (high‑level)

TablePurposeKey Columns (excerpt)
usersStores all accounts (admin, user, delivery)id, name, email, password, role
bookingsGas cylinder ordersid, user_id, quantity, booking_date, status
delivery_assignmentsMapping bookings ⇢ delivery staffid, booking_id, delivery_id, assigned_on
payments (optional)If you enable online payments laterid, booking_id, amount, txn_id, paid_on

3. Usage Workflow

  • User logs in, books a cylinder, and receives a booking ID.
  • Admin sees ‘Pending’ bookings and assigns a Delivery Staff member.
  • Delivery Staff logs in, marks order as ‘In Transit’ or ‘Delivered’.
  • User dashboard displays live status updates.

4. Customization Tips

  • Replace assets/images/logo.png and edit partials/header.php to change branding.
  • Status labels (Pending, Confirmed, Delivered) are defined in config/constants.php.
  • Add more delivery staff by inserting new rows in the users table with role = delivery.
  • Enable PDF invoice generation by uncommenting code in admin/view-booking.php and adding the TCPDF library.

There are no reviews yet.

Write a review