prism-application

byAkyes Ahmed Gawai

Here is your master prompt rewritten in clear paragraph form, ready to use in AI tools: You are an expert full-stack web developer, system architect, and UI/UX designer. Your task is to build a complete, production-ready web application named “The Help Hive – Web-Based Service Management System.” The system must be fully functional, scalable, secure, and free from logical, architectural, and database design errors. Use a structured development approach and follow best coding practices throughout the project. The application must strictly use the following technology stack: HTML5, CSS3, and vanilla JavaScript for the frontend; PHP for backend development; and MySQL as the relational database. The system should run on an Apache server using XAMPP. The platform’s main objective is to create a centralized system that connects users with local service providers such as electricians, plumbers, cleaners, tutors, and technicians. The system must support three types of users: Admin, Service Provider, and User (Customer), with proper role-based access control. Implement a secure authentication system that includes user registration, login, password hashing using bcrypt, session management, and logout functionality. Ensure that each user role has restricted and appropriate access to system features. The User (Customer) should be able to register, log in, browse service categories, search for service providers, submit service requests, track request status (such as pending, accepted, or completed), and view their request history. Service Providers should be able to register, log in, create and manage their profiles including skills, experience, and availability, view incoming service requests, accept or reject requests, and update job statuses. The Admin should have access to a dashboard that displays system statistics and allows management of users, service providers, service categories, and all service requests, including verifying providers. Design a normalized MySQL database with appropriate relationships. Include tables such as users, service_providers, categories, and service_requests, with proper primary and foreign keys. Ensure efficient data handling, avoid redundancy, and maintain data integrity. Follow a clean and organized folder structure, separating configuration files, reusable components, role-based modules (admin, provider, user), and assets such as CSS and JavaScript. The UI should be modern, responsive, and user-friendly, using card-based layouts, dashboards, and clear navigation. Include both client-side and server-side validation. Implement strong security measures such as input sanitization, prevention of SQL injection using prepared statements (PDO or MySQLi), session protection, and role-based page access restrictions. Structure the system into key modules including authentication, user management, service provider management, service request handling, and admin control panel. Optionally, include advanced features such as a rating and review system, email notifications, search filters, and AJAX-based dynamic updates to enhance user experience. Test the system thoroughly by validating all forms, checking authentication flows, verifying role-based access, testing the full lifecycle of service requests, and ensuring there are no broken links or runtime errors. Finally, generate the complete project including folder structure, database SQL file, all frontend and backend code, dashboards for each role, and step-by-step setup instructions for running the project on XAMPP. Ensure the code is clean, well-commented, and easy to understand.