Civic Issue Reporting Portal Final Year PHP Project

• Admin login for this final year project
• Dashboard with citizens, departments, complaints, submitted, in-progress, and resolved counts
• Recent complaints and needs-assignment queue
• Manage departments with create, edit, delete, activate, and deactivate
• Department staff login management
• Citizen management with search, status filter, pagination, activate/deactivate, and full profile view
• Issue category CRUD with department mapping
• Civic issue list with search, filters, pagination, table view, and card view
• Complaint detail with progress tracker
• Assign complaint to department
• Update complaint status with remarks
• Reject complaint with reason
• Delete complaint permanently
• View complaint history and uploaded photos
• Feedback management with rating filters and average rating
• Printable reports: department-wise, status-wise, date-wise, user-wise, resolved, and pending
• Admin profile update and password change

• Department staff login for this final year project
• Department dashboard with assigned complaint statistics
• View only complaints assigned to logged-in department
• Search complaints by ID, title, citizen, or address
• Filter by status, category, and date
• Complaint detail with citizen contact, issue photo, history, and progress tracker
• Update status: Assigned, In Progress, Resolved, Rejected
• Add department remarks without status change
• Upload, replace, or remove resolution proof photo
• Quick status buttons and remark presets
• View citizen feedback after resolution
• Activity history with date filters and search
• Department profile update and password change
• Citizen registration and login
• Citizen dashboard with complaint stats
• Report civic issue with title, category, description, address, landmark, ward/area, and photo
• Image preview before submission
• Use profile address option
• Category-to-department hint
• View own complaints only
• Search and filter own complaints
• Edit complaint while status is Submitted
• Cancel/delete complaint while status is Submitted
• Complaint detail with progress tracker, history, remarks, issue photo, and resolution photo
• Submit feedback after complaint resolution
• View, edit, or delete own feedback
• Profile update with name, mobile, address
• Password change

• Public landing page included in this final year project
• Complaint status flow: Submitted → Assigned → In Progress → Resolved / Rejected
• Photo upload for issue evidence
• Resolution proof upload by department
• Complaint history and audit trail
• Department-wise complaint routing
• Bootstrap 5.3 responsive UI
• Role-specific themes for Admin, Department, and Citizen
• PDO prepared statements
• Bcrypt password hashing
• htmlspecialchars() output escaping
• Role-based session authentication
• One-click install.php setup
• Seed data with departments, users, complaints, and feedback
• Upload folders for complaints and resolutions
• Suitable for final year project demo, viva, source code review, and report preparation

1. Copy the final year project folder to web root:

   C:\xampp\htdocs\Civic Issue Reporting Portal using PHP and MySQL\

2. Start Apache and MySQL.

3. Edit database credentials in:

   config/database.php

4. Use:

   define('DB_HOST', 'localhost');
   define('DB_NAME', 'civic_portal');
   define('DB_USER', 'root');
   define('DB_PASS', '');

5. Open installer:

   http://localhost/Civic Issue Reporting Portal using PHP and MySQL/install.php

6. Click Install Database & Seed Data.
7. Delete install.php after successful installation.
8. Ensure upload folders are writable:
   • uploads/complaints/
   • uploads/resolutions/

9. Open:

   http://localhost/Civic Issue Reporting Portal using PHP and MySQL/

Admin

• Username: admin
• Email: [email protected]
• Password: admin123

Department Staff
All use password: dept123

• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]
• [email protected]

Citizens
All use password: user123

• [email protected]
• [email protected]