A comprehensive web-based waste management system for Douala, Cameroon, built with PHP, MySQL, and Bootstrap.
# Douala Waste Management System
A comprehensive web-based waste management system for Douala, Cameroon, built with PHP, MySQL, and Bootstrap.
## Features
### For Residents (Users)
- **Submit Waste Collection Requests**: Report various types of waste issues (collection, illegal dumping, missed pickup, full bins, hazardous waste)
- **Track Request Status**: Monitor progress from submission to completion
- **View Collection Schedules**: Check when waste will be collected in their area
- **Receive Notifications**: Get updates on request status changes
- **Request History**: View all past requests and their outcomes
### For Waste Collectors
- **Collector Dashboard**: View assigned requests and collection schedules
- **Update Request Status**: Mark requests as in progress or completed
- **Location-Based Assignments**: Manage waste collection in assigned zones
- **Performance Tracking**: Monitor completion rates and response times
### For Administrators
- **Admin Dashboard**: System overview with key metrics and statistics
- **User Management**: Approve new users, manage roles, and handle accounts
- **Request Management**: Assign requests to collectors, update statuses, set priorities
- **Schedule Management**: Create and manage collection zones and schedules
- **Reports & Analytics**: Generate comprehensive reports on system performance
- **Audit Logging**: Track all system activities for accountability
## Technology Stack
- **Backend**: PHP 8.2+
- **Database**: MySQL 8.0+
- **Frontend**: Bootstrap 5, Font Awesome, Chart.js
- **Server**: Apache 2.4+
- **Security**: Password hashing, input sanitization, CSRF protection
## Installation
1. **Prerequisites**
- XAMPP/WAMP or similar PHP development environment
- MySQL database server
- Web browser (Chrome, Firefox, Safari, Edge)
2. **Setup**
```bash
# Clone or download the project files
# Place in your web server's document root (e.g., htdocs/douala_waste)
# Create database
mysql -u root -p < db.sql
# Update datab …