Water Supply Management System Using PHP and MySQL

The Water Supply Management System (WSMS) is a web based application that can be accessed over the web. This system can be used to automate the workflow of water supply and their invoices.

The project has been planned to be having the view of distributed architecture, with centralized storage of the database. The application for the storage of the data has been planned. Using the constructs of MySQL Server and all the user interfaces has been designed using the PHP technologies. The database connectivity is planned using the “MySQL Connection” methodology.

In WSMS we use PHP and Mysql database. In this project, any person can order a drinking water bottle online. It has two modules, admin and user.

Admin

1. Dashboard: In this section, admin can see all detail in brief like a total order, total new order, total accept order, total order deliver, total cancel order, total company and total register user.
2. Water Bottle info: In this section, admin can manage water bottle(Add/Update/Delete).
3. Company Info: In this section, admin can manage the company(Add/Update/Delete).
4. Pages: In this section, admin can update about us and contact us information.
5. Orders Management: In this section admin can view the order details and they have also right to change order status according to current status.
6. Latest News/Updates: In this section admin can manage news(Add/Update/Delete).
7. Reg Users: In this section, admin can view registered users and their orders.
8. Search: In this section, admin can search a particular order with the help of order number.
9. Reports: In this section admin can view order details, order counts and sales report according to dates.

Admin can also update his profile, change the password and recover password

User

1.Water Bottle: In this section, user can view which drinking bottle available.

2.My Accounts: In this section, user can change his/her own password, view and update his/her profile and logout from accounts.

3.My orders: In this section, user can view order history after login.

4.Cart: In this section, user can add their drinking bottle which he/her want to order.

5.User has also a facility to download his/her invoice and cancel orders if he/she wants to cancel.

Brief Information about the homepage

On this page guest user can only view about us page, contact us page and which drinking bottle is available if anybody wants to order the bottle they must register.