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.
Project Requirements
| Project Name | Water Supply Management System |
|---|---|
| Language Used | PHP5.6, PHP7.x |
| Database | MySQL 5.x |
| User Interface Design | HTML, AJAX,JQUERY,JAVASCRIPT |
| Web Browser | Mozilla, Google Chrome, IE8, OPERA |
| Software | XAMPP / Wamp / Mamp/ Lamp (anyone) |
| Last Updated | 20 Dec 2023 |
Project Modules
In WSMS we use PHP and Mysql database. In this project any person can order drinking water bottle online. It has two modules admin and user.
Admin
- Dashboard: In this section admin can see all detail in brief like total order, total new order, total accept order, total order deliver, total cancel order, total company and total register user.
- Water Bottle info: In this section admin can manage water bottle(Add/Update/Delete).
- Company Info: In this section admin can manage company(Add/Update/Delete).
- Pages: In this section admin can update about us and contact us information.
- Orders Management: In this section admin can view the order details and they have also right to change order status according to current status.
- Latest News/Updates: In this section admin can manage news(Add/Update/Delete).
- Reg Users: In this section admin can view registered users and their orders.
- Search: In this section admin can search particular order with the help of order number.
- Reports: In this section admin can view order details, order counts and sales report according to dates.
Admin can also update his profile, change 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.
5User has also a facility to download his/her invoice and cancel order if he/her want to cancel.
Brief Information about homepage
On this page guest user can only view about us page, contact us page and which drinking bottle is available if anybody want to order the bottle they must registered.
Some Project Screenshots
Home Page
User Orders
Admin login
Admin Dashboard
How to run the Water Supply Management System (WSMS) Project
1. Download the zip file
2. Extract the file and copy wsms 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 wsmsdb
6. Import wsmsdb.sql file(given inside the zip package in SQL file folder)
7.Run the script http://localhost/wsms (frontend)
Credential for admin panel :
Username: admin
Password: Test@123
Credential for User panel :
Username: testuser@gmail.com
Password: Test@123
