Car Pooling System

Posted By phpprojectz on August 28, 2017
Backend: 

Objective of Car Pooling System

Car Pooling System is a web based application which has been developed over PHP and MySQL and runs on WAMP, XAMP or Apache2 server.. The main modules of the project is Cars,Pooling,Car Routes,Bill,Drivers. Admin user can manage all the operations of Bill,Drivers,Cars,Passengar,Pooling and their details. Admin can create different type of reports of Cars,Pooling,Car Routes,Bill,Drivers according to their choise and filters. You can Download PHP and MySQL Project Car Pooling System with source code and database from this site. We also provide Project Report of Car Pooling System.

Functionalities and their descriptions of Car Pooling System are as follows:

  • You can search records on various criterias. Such as Cars, Car Routes, Bill, Drivers
  • Create, read, update and delete (CRUD) application has been implemented on Cars,Pooling,Car Routes,Bill,Drivers
  • Keep the track logs of Pooling, Passengar, Bill ect
  • Advance search has been implemented on Pooling,Passengar, Bill
  • You can see all the details of the Cars, Car Routes, Passengar, Bill
  • All the modules Passengar, Bill, Pooling,Drivers, Cars are inter related and tightly coupled
  • It deals with monitoring the information and transactions of Bill.
  • All the Pooling,Passengar, Bill modules has their unique record ID for fast transactions and searching
  • Editing, adding and updating of Records is improved which results in proper resource management of Cars data.

Modules of Car Pooling System and their descriptions:

  • Cars Module : Manage all the operations of Cars
  • Pooling Module : Manage all the operations of Pooling
  • Passengar Module : Manage all the operations of Passengar
  • Car Routes Module : Manage all the operations of Car Routes
  • Bill Module : Manage all the operations of Bill
  • Drivers Module : Manage all the operations of Drivers

Classes and their methods of Car Pooling System:

  • Cars Methods : addCars(), editCars(), deleteCars(), updateCars(), saveCars(), searchCars()
  • Pooling Methods : addPooling(), editPooling(), deletePooling(), updatePooling(), savePooling(), searchPooling()
  • Passengar Methods : addPassengar(), editPassengar(), deletePassengar(), updatePassengar(), savePassengar(), searchPassengar()
  • Car Routes Methods : addCar Routes(), editCar Routes(), deleteCar Routes(), updateCar Routes(), saveCar Routes(), searchCar Routes()
  • Bill Methods : addBill(), editBill(), deleteBill(), updateBill(), saveBill(), searchBill()
  • Drivers Methods : addDrivers(), editDrivers(), deleteDrivers(), updateDrivers(), saveDrivers(), searchDrivers()

Database tables and attributes of the Car Pooling System:

  • Cars Entity : Attributes of Cars are car_id, car_customer_id, car_number, car_company car_type, car_description
  • Pooling Entity : Attributes of Pooling are pooling_id, pooling_customer_id, pooling_driver_id, pooling_amount, pooling_payment, pooling_type, pooling_description
  • Passengar Entity : Attributes of Passengar are passenger_id, passenger_name, passenger_mobile, passenger_email, passenger_username, passenger_password, passenger_address
  • Car Routes Entity : Attributes of Car Routes are car_route_id, car_route_name, car_route_type, car_route_description
  • Bill Entity : Attributes of Bill are bill_id, bill_customer_id, bill_number, bill_type, bill_receipt, bill_description
  • Drivers Entity : Attributes of Drivers are driver_id, driver_name, driver_mobile, driver_email, driver_username, driver_password, driver_address, driver_licence

Database definition of Car Pooling System:

  • The details of Cars is store into the Cars tables respective with all tables
  • Each entity (Drivers, Passengar, Bill, Pooling, Cars) contains primary key and unique keys.
  • The entity Passengar, Bill has binded with Cars, Pooling entities with foreign key
  • There is one-to-one and one-to-many relationships available between Bill, Car Routes, Drivers, Cars
  • All the entities Cars, Bill, Passengar, Drivers are normalized and reduce duplicacy of records
  • We have implemented indexing on each tables of Car Pooling System tables for fast query execution.

Super admin functionality of Car Pooling System:

  • Admin can add, edit, delete and view the records of Cars, Bill, Passengar, Drivers
  • Admin can manage all the details of Pooling, Passengar, Car Routes, Bill
  • Admin can also generate reports of Cars, Pooling, Passengar, Car Routes
  • Admin can search the details of Cars, Bill, Passengar, Drivers
  • Admin can apply different level of filters on report of Cars, Passengar, Drivers
  • Admin can tracks the detailed information of Bill, Drivers, Cars, Pooling

Report of Car Pooling System:

  • Generates the report on Passengar,Car Routes,Cars,Pooling,Bill,Drivers,
  • Car Routes,Bill,Drivers has been integrated with the dynamic filter. So you can filter the records run time
  • You can also import the report data into PDF of Car Routes,Bill,Drivers
  • Excel Sheet report has also been integrated for Pooling,Car Routes,Drivers
  • You can create the CSV reports for Cars,Bill,Passengar

Limitation of Car Pooling System

  • Run time report generation is not available in Car Pooling System.
  • We have not implemented the dynamic report for Cars,Car Routes,Bill,Pooling,Passengar,Drivers
  • This project Car Pooling System has not been developed on Model View Controller architecture, so its very complex to manage
  • Batch mode execution for Off-line reports of Cars, Car Routes, Drivers cannot be generated.
  • Crystel report has not been integrated

Input Data and Validation of Car Pooling System

  • We have added all the validations for input value on the modules Cars,Pooling,Passengar
  • Car Routes,Bill,Drivers can not be submited without filling all the inout fields
  • Duplicate values testing has been implemented on Cars,Passengar,Drivers
  • CSRF token has also been implemented on Car Routes,Pooling,Cars, Bill,Drivers
  • All the Cars,Car Routes,Bill,Pooling,Passengar,Drivers has integrated with captcha for spam protections
  • Access level validation has been implemented on Drivers,Bill,Car Routes
  • Number and character validation has also been implemented on Passengar,Bill,Cars

Send Message

Vertical Tabs

Latest PHP and MySQL Projects Source Code and Database